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: To download example workbooks, enter email here: https://www.xlconsulting-asia.com/socials.html Sparklines in Google Sheets: https://youtu.be/Ar23lpaxEpI Pivot Tables in Google Sheets: https://youtu.be/dK095tShezk Interactive dashboards in Excel: https://youtu.be/nw9VyPNS-tY 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