Module 1: Formulas
-
Quick Analysis
-
Absolute and mixed referencing
-
Working with Range Names
-
Calculating across worksheets
-
Exploring Excel’s functions
-
Criteria-based functions
-
Text functions
-
Calculating with dates
-
Logical functions
-
Using the VLOOKUP function
-
Using XLOOKUP (Excel 365 only)
Module 2: The Auditing tools
-
Tracing precedents and dependents
-
Tracing errors
-
Viewing formulas
-
The Watch Window
-
Evaluating formulas
Module 3: Working with data lists
-
Creating an effective list
-
Applying basic sorting
-
Advanced sorting
-
Summarising data with subtotals
Module 4: Filtering data lists
-
Applying basic filters
-
Advanced filters
-
Custom views
Module 5: Mastering Excel tables
-
Introducing tables
-
Creating a table
-
Managing a table
-
Calculations and totals in tables
-
Formatting a table
-
Further table tools
Module 6: Charts
-
Understanding charts
-
Creating a chart
-
Resizing and moving charts
-
Managing a chart
-
Working with chart elements
-
Formatting charts
-
Working with chart templates
-
Analyse data with sparklines
Module 7: Additional features
-
Comments and notes
-
Hyperlinks
-
Templates
-
Excel options
Module 8: Conditional formatting
-
Applying conditional formatting
-
Modifying and deleting
-
Creating custom conditional formats
-
Sorting and filtering by colour