Interactive dashboards in Google sheets

Google Sheets allows you to create charts and choose to aggregate easily, and if you add Slicers then it can become interactive. Card visuals and Table visuals are interesting to explore as Excel doesn't have them, plus using Pivot Tables allows you to sort the charts or have crosstab analysis which can be made more visual through sparklines and conditional formatting. I cover all this in my video.

Other links:
You can download the example files here: https://www.xlconsulting-asia.com/you...
Sparklines in Google Sheets:    • Sparklines: In cells charts in Google...  
Pivot Tables in Google Sheets:    • Google sheets Pivot tables  
Interactive dashboards in Excel:    • Interactive dashboards in Excel with ...  

00:00 Introduction
00:37 Create an aggregated chart
02:30 Card visuals
03:18 Pivot Tables and sorted charts
04:22 Chart only dashboard
06:09 Slicer for interactivity
11:03 Pivot table date groups
12:21 Paginated table chart
13:20 Conditional format and sparklines
14:34 Colour picker to match logo etc
16:04 Final dashboard touches
16:38 Marker 11