Introduction
  • Introduction
  • Setting up your Spreadsheet with Quick Access Toolbar
  • Opening Up Excel
  • Adding style to your Excel document
  • Adding Colour to a Spreadsheet
  • Use an Excel spreadsheet to make a timetable
Using Filters and Writing Formulae
  • How to create simple formulae
  • How to write divide, subtract and multiply formulae
  • Basic Formulas in Excel
  • How to filter and sort data
  • Writing Basic Formulae
VLOOKUP functions
  • How to use VLOOKUP
  • VLOOKUP questions
  • Formatting Cell Styles in Excel
  • Formatting a Work Rota
Format Tables to Summarise Data
  • Advanced settings for viewing Excel Spreadsheets
  • How to format a table and use functions
  • Sum up your travel adventures
  • Table format quiz
Advanced Snapshots of data - Using Slicer and PivotTable
  • How to use slicers and charts
  • How to Create a Pivot Table
  • Slicer and Pivot Table Quiz
Macro
  • How to Record a Macro
  • Macro Quiz