Hi everyone,
This is part 2 on how to build a dynamic dashboard and in this video, we are to build a scrollable table where you can scroll through the data both vertically and horizontally, and finally, build text boxes to display high-level numbers.
00:00 - Intro
00:07 - Short explanation
01:52 - Create the Scrollable Table
02:47 - Create a Help Column
03:45 - Design the Scrollable Table
06:46 - Create the Pivot Table
08:47 - Use the OFFSET function to return the data
18:38 - Use IF function to hide zeros
19.44 - Create Text Boxes
Please comment below if you would like to see more videos like this one, or if you have any ideas on how to improve this part of the dashboard.
If you like this video, please leave a like and subscribe.
Thanks for watching.
