Objectives
By the end of this course you will be able to create a wide range of advanced calculations, be able to create custom formats and use conditional formatting to display data in various formats based on a condition.
Advanced Autofill
- Flash Fill
- Fill Options
Advanced Formatting
- Styles and Themes
- Custom Number Formatting
- Conditional Formatting
- Quick Analysis Tool
Formulae
- Refresh on Formulae and basic Functions
- Absolute referencing ($)
- Mixed referencing
- Use Names in a formula
Advanced Functions
- Text Functions to Clean Data
- IF and Nested Functions – IF / COUNTIF /SUMIF
- Logical Functions - using AND / OR
- Lookup Functions - VLOOKUP / HLOOKUP
- Date Functions – TODAY / NOW / NETWORKDAYS
Auditing Worksheets
- Formula Auditing
- Formula Evaluator
- Checking Errors
- Watch Window
- GoTo Special