Excel Intermediate to Advanced Course
- Best Practice
- Named Ranges
- Sorting and Filtering by colour
- Multilevel sort
- Cross Checks
- Statisitical formulas – Avg, Count, Max, Min
- Rounding, Ceiling, Floor
- Flashfill
- Conditional Formating
- Data Validation
- V and H Lookup
- Tables
- Pivot Tables
- Charts and Graphs
- Specialized Formula – Sumif, Countif, Filter, Unique, Sort
- Introduction to Power Query
- Introduction to Macros
- Any special requests

