Excel Intermediate Course

Session 1 – Revision

Session 2 – Absolute Cells

Session 3 – Absolute Cells: Further Practice

Session 4 – Multiple Sheets Naming, Grouping, Moving

Session 5 – Multiple Sheets: Moving and copying sheets

Session 6 – Multiple Sheets; Linking formula

Session 7 – Multiple Sheets: 3D formula

Session 8 – Tables: Creating a table

Session 9 – Tables: Using the Table toolbar

Session 10 – Tables: Basic Filters

Session 11 – Tables: Navigating using names, selecting, conditional formats

Session 12 – Conditional Formatting: Creating

Session 13 – Conditional Formatting: Duplicates, Editing, icon and colour sets

Session 14 – Charts: Creating a Chart

Session 15 – Charts: Formatting a Chart

Session 16 – Charts Practice

Session 17 – IFS Using Wizard

Session 18 – IFS Practice