Introduction & files
  • Course introduction
  • Pre-course survey
  • Course and Exercise files
Navigating Excel
  • Excel Terminology
  • Navigating the ribbon interface
  • Excel toolbars
  • The Excel file menu
  • Tips & Tricks
Working with Worksheets
  • Working with worksheets
  • Creating, moving and deleting sheets
  • Renaming sheets
  • Copying and moving sheets
  • Worksheet organisation
  • Formatting cells and worksheets
Number Formats
  • Introduction to number formats
  • Different number formats
  • Assigning number formats
  • Number format options
  • Custom number formats
  • Dates in Excel
  • Midway review and Exercise
Functions and calculations
  • Formulas introduction
  • Math calculations
  • Introduction to functions
  • Absolute vs relative references
  • Most commonly used functions
  • Section wrap-up and exercise
Charting
  • Charting introduction
  • Do you need to use a chart
  • Anatomy of a chart
  • Chart types
  • Creating a column chart
  • Creating a line chart
  • Creating a bar chart
  • Creating a pie chart and wrap-up
Course project
  • Project introduction
  • A look at what we will be making
  • Creating the data section
  • Creating the overview section
  • Creating the chart and conditional formatting
Course wrap-up
  • Course wrap-up and thanks!
  • Post course survey
Bonus content
  • Lookups (V & H lookups)
  • Named ranges - adding meaning to your formulas
  • Adding comments to your spreadsheets
  • Printing and exporting spreadsheets