Overview
This course focuses on advanced Excel features in order to maximize productivity on the desk.
- Logic functions
- AND, IF, OR, IFERROR
- Math functions
- AVERAGE, AVERAGEIF, AVERAGEIFS
- COUNT, COUNTA, COUNTIF, COUNTIFS
- MAX, MEDIAN, MIN
- SUM, SUMIF, SUMIFS
- Extracting information from a database/model
- CHOOSE
- VLOOKUP, HLOOKUP
- OFFSET, INDEX, MATCH
- INDIRECT
- Data validation
- Lists
- Other
- Text functions
- Date functions
- Data tables
- Pivot tables
- Conditional formatting
- Self-referencing IF statements