Basic Excel Skills
- Good notes and metadata
- Tables
- Pivot Tables
- Pivot Charts
- Slicers
- Power Query
Excel Formulas
- COUNT, COUNTA, COUNTIF
- SUM, SUMIF
- VLOOKUP
- AVERAGEIF
- OFFSET
- MATCH
- MATCH/INDEX
- LARGE
- IF, NESTEDIF
Outputs/Resources
- Excel is fun! - YouTube channel with 2,500 how-to videos with a wide range of excel tutorials from beginner to advanced
- Excel Training 101 - Simple easy to follow instructions and videos on a wide range of Excel basic functions