Use Nested XLOOKUPs to unpivot data
What you will learn?
Please download this practice file to use while you watch the videos
Each tab ties into a lesson or video
Please download the completed practice file with populated formulas and functions
Quick introduction and overview of Part II
Overview of the XLOOKUP Syntax
Learn how to unpivot data to convert a grouped data view into a list of data.
Learn how to pivot data to convert a list of data into a grouped data view.
Learn how to use the IMAGE function with XLOOKUP to create heat maps
Use XLOOKUP to make your graphs and charts dynamic
Pairing XLOOKUP and the SUM function results in a dynamic SUM function which is ideal for interactive dashboards and reports
Well done on completing the XLOOKUP Part II Workshop
You have achieved XLOOKUP Rockstar status :)
