Training videos

Our short training videos are useful guides to a range of topics.

Excel

video screenshotIf statements
Video: using If statements in Excel

video screenshotSum If
Video: conditional sum formulae in Excel

video screenshotHLOOKUP and VLOOKUP
Video: lookup functions in Excel

video screenshotDefined names
Video: using defined variables in Excel

video screenshot showing Excel referencing videoRelative referencing
Video: managing associations when copying formulas in Excel

video screenshot showing password changeRecommended Pivot Tables
Video: quickly adding a pivot table in Excel

video screenshot showing Excel conditional formatting videoConditional formatting
Video: controlling formats dynamically in Excel


MindView