This is a three-part series of recorded webinars run over three consecutive days. Each day a new video is released. Each session is about 1.5 hours long. There are also bonus videos included.
The sessions take you through the following topics
- Advanced summing techniques
- Logic formulas
- INDEX-MATCH combination
- Text functions
- INDIRECT function
- Power Query single, multiple files and merging
- Advanced Pivot Tables
- Relationships
- GETPIVOTDATA function
Along the way there are lots of shortcuts and advice on creating effective spreadsheets.
Level: Advanced
Duration: 4.5+ hours
Price: AU$49