Course Content
Data Analysis with Excel
Data Analysis with Excel
Pivot Tables
PivotTables are one of Excel's most powerful features, enabling users to quickly and efficiently summarize large datasets into meaningful tables.
They offer dynamic arrangement of data, allowing for easy aggregation, comparison, and analysis.
With slicers and other tools, PivotTables offer personalized views of data, making them incredibly versatile for different analytical needs.
Task
Now apply the skills you've learned to create a similar table, reflecting Location as rows, Category as columns, and Quantity_Sold as the value.
Then, incorporate a slicer using the Date column, so the final display appears as follows:
Thanks for your feedback!