outlines (all versions) - all courses can be customised

Understanding Excel and the ribbon

Entering and editing data

Printing and page layout

Adding/deleting rows and columns

Row height, column width

Freeze panes

Cut copy paste

Formatting and autofill

Borders

Basic formulas and functions

Autosum

Basic charts/graph

Recap on basics  (if needed)

IF  VLOOKUP  HLOOKUP XLOOKUP

SUMIF  COUNTIF  AVERAGEIF

Linking worksheets and workbooks

Date functions

Named cells and ranges

Filters, sorting,  Subtotals,  basic Pivot Tables

Conditional formatting, password protecting worksheets and parts of worksheets, data validation

Recap on intermediate (if needed)

IF AND OR MATCH  INDEX

COUNTIFS  SUMIFS  AVERAGEIFS

Nesting functions

Array formulas

Text functions

Database functions

More on Pivot Tables, pivot charts and slicers

Custom views, shared workbooks, Goal Seek,  Solver and Scenarios

Intro to Macros

What is a Macro and what can they do

Recording and editing Macros

Using relative references

Personal Macro Workbook

Visual Basic Editor

Writing code VBA

Testing code

Message and dialog boxes

IF THEN ELSE   -    SELECT CASE

Looping statements   FOR NEXT  etc

User forms