Working with Lists

Sorting data
Using the automatic filter
Entering subtotals
Data validation

Pivot Tables

Summarising data using pivot tables
Formatting the pivot table
Formulas in pivot tables
Creating a pivot table chart
Linking to another sheet

Functions

Review of Basic functions
IF function
Creating multiple IF statements
Look ups
Date calculations
Testing for errors
Naming ranges

Working with multiple sheets

Creating a new workbook
Selecting cells across worksheets
Entering formulae across worksheets
Using paste link
Splitting the worksheet into panes
Copying and moving between worksheets
Copying and linking between workbooks
Insert, delete and group worksheets

Charting & Drawing tools

Using the Chart Wizard
Using the Drawing tools