Excel is Microsoft’s Spreadsheet program. Spreadsheets are often used as a method of displaying and manipulating groups of data in an effective manner. It was originally created for accounting. Excel is useful when you have a very large set of data and need to perform the same operation on each Series / Set of it. It is well-suited to tasks such as sorting, alphabetizing, and performing more complex mathematical functions on data such as adding 2 columns together.

Things to Note – Data Types and Formulas
Entering Data
Data does not have to start at Cell A1. Data can be placed wherever you like as long as your data is in a solid block of adjacent cells. When you print, you can select a specific set of cells so that empty cells are not printed.

Data Types
There are several different types of data that can be entered into a cell. Some common Data Types are:
- Text
- Numbers
- Dates
- Currency
Each of these can be formatted to suit the requirements of your data. For instance, you can alter the number of decimal places for a Number, or the way a date is written out or abbreviated with a Date. Most Data is entered by typing Data into a cell or group of cells, then defining a Data Type and Format for the cells. If you have a large block of cells with the same Data Type and Format, you can select them all at once and set the Data Type and Format for all of them.

Get pdf Microsoft Excel 2007