This tutorial combines 4 separate features or tricks that we can bring together to make a dynamic worksheet that allows us to filter data, sort data, chart data, summarize data, and update data dynamically.
Using these Excel tricks, we can make it easy to analyze and interpret data in a visual way in Excel.
The 4 tricks that we combine are:
Excel Tables (Microsoft Link)
Excel Slicers (Microsoft Link)
Excel Charts (Microsoft Link)
Excel AGGREGATE() Function (Microsoft Link)