Our short training videos are useful guides to a range of topics.
If statements
Video: using If statements in Excel
Sum If
Video: conditional sum formulae in Excel
HLOOKUP and VLOOKUP
Video: lookup functions in Excel
Defined names
Video: using defined variables in Excel
Relative referencing
Video: managing associations when copying formulas in Excel
Recommended Pivot Tables
Video: quickly adding a pivot table in Excel
Conditional formatting
Video: controlling formats dynamically in Excel
Updated on 16 October 2020