Download Excel File: https://excelisfun.net/files/EMT1779.xlsx Solution file here: https://excelisfun.net/files/EMT1779Solution.xlsx
Learn how to create a Monthly Employee Sales By Department report three different ways. Each with their own spectacular use.
Three methods for building report:
1. (00:00) Introduction
2. (00:43) Intro to 3 Methods
3. (01:06)XLOOKUP function, a Spilled Lookup Formula and a PivotTable.
4. (03:53) Relationships and a Data Model PivotTable.
5. (07:40) VLOOKUP function and Show Report Filter Pages (#1 PivotTable Trick).
6. (10:38) Summary
7. (11:11) Closing and Video Links