Review of Basics

IF, DATE and TEXT functions
Using the IF function
Nesting IF functions
Using DATE functions
Using TEXT function

Sorting and Querying Data
Sorting data
Filtering data
Advanced filters
Extracting Records

Workbook Maintenance
Arranging Workbooks
Freezing Panes
Copying Worksheets
Using comments
Using Go To Special
Changing Excel defaults

Styles
Working with Workbook styles
Creating styles by example
Modifying and deleting styles

Naming Cells and Ranges
Using names in formulas

Subtotals and Grand totals
Creating and working with the Subtotal feature

View Manager
Creating views
Using views
Deleting views Report Manager
Creating reports
Printing reports

Workbook Templates
Creating and using Templates

Analysing data using charts
Creating a chart
Adding items to a chart
Amending a Chart
Changing the chart type
Printing Charts