Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Excel Pivot Tables | Excel Basic Data Analysis
Data Analysis with Excel
course content

Course Content

Data Analysis with Excel

Data Analysis with Excel

1. Excel Data Management and Manipulation
2. Excel Basic Data Analysis
3. Excel Data Visualization and Automation
4. Advanced Data Analytics in Excel

book
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:

question mark

With the Data slicer used in the task, how many items from all categories were sold in total on 01/01/2022?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 2. Chapter 3
We're sorry to hear that something went wrong. What happened?
some-alt