Statistical Formulas

• Nested Ifs
• Combining If with Sum and Count Formulas
• V Lookups
• Using And / Or Formulas

Manipulating Charts

• Changing the chart layout
• Adding Trend lines and Average lines
• Saving the Chart Design

Macros

• Recording a Macro
• Play back a Macro

Pivot Tables

• Creating a Pivot Table from a data range
• Adding and Removing fields in a Pivot Table
• Refreshing Pivot Table data
• Creating a Chart from a Pivot Table

Outlines, Subtotals and Views

• Creating an Outline
• Adding and Editing Subtotals
• Saving Custom Views

Customising Toolbars

• Opening and Closing Toolbars
• Customising Toolbars
• Creating Icons and changing button images

 Templates

• To Create a New Template
• To Edit an Existing Template