Microsoft Excel
A brief introduction
In brief, what is Microsoft Excel?
Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.
The built-in functions allow users to:
- create and edit formulas;
- copy and move data;
- format worksheets;
- and set up worksheets for printing.
DATA TYPES, FORMULAS AND FUNCTIONS
A cell can hold different kinds of data (for instance: numbers, text and formulas). Formulas are used for calculations usually involving data contained in other cells. Excel includes hundreds of built-in formulas used for common tasks, known as functions.
EXCEL AND BUSINESS DATA
Spreadsheets are often used to store business data. Formulas and functions that are used on this type of data include:
- Performing basic mathematical operations such as summing columns and rows of figures;
- Finding values such as profit or loss;
- Calculating repayment plans for loans or mortgages;
- Finding the average, maximum, or minimum values in a specified range of data.
EXCEL'S OTHER USES
Excel can be used for other common operations:
- graphing or charting data (to assist users in identifying data trends);
- sorting and filtering data (to find specific information);
- the information stored in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.