Revision of Intermediate:                       

· Number Formatting

· Filtering

· Custom Filtering

· Data Validation

· Subtotals

Analysing Data Lists:

· Advanced Filtering

· Creating Pivot Tables

· Creating Pivot Charts

· Using Outlines

Customising Excel: 

· Customising Toolbars

· Customising Toolbar Buttons

· Setting Options

Macros:    

· Recording a Macro

· Running a Macro

· Deleting a Macro

· Assigning a Macro to a Toolbar

Auditing: 

· Formula Auditing Toolbar

· Trace Precedents & Dependants

· Tracking Changes