Introduction to Excel

The Excel Environment

Understanding Excel terminology
The Formula Bar and Status Bar
Moving around the worksheet
The active cell

Worksheets

Moving, copying, renaming and deleting worksheets
Inserting and deleting worksheets

Workbooks

Selecting cells, rows, columns
Selecting ranges and non-contiguous ranges

Working with Data

Entering data using in-cell and Formula Bar
Entering labels, dates, and numbers
Copying and pasting using the clipboard
Using AutoComplete and the pick list

Formatting Worksheets

Applying font styles and number formats
Creating custom date formats
Aligning, wrapping and merging cells
Using the Format Painter
Changing the column width and row height
Inserting and deleting rows and columns

Formulae and Functions

Using mathematical operators
Entering and editing formulas
Sum, Average, Count, Max and Min functions
AutoSum
Relative and absolute cell references