Pivot Tables for Data Analysis & Visualization
Pivot Tables for Data Analysis and Visualization
Description
The Pivot Table is one of the most intuitive and powerful tools in Excel. With any list or table in your workbook, you can create a summary analysis and a chart highlighting insights in just seconds. Taking more time than that, you can build an interactive dashboard with multiple charts and filters.
Topics include:
Designing and controlling lists and tables as the Pivot Table source
Creating Pivot Tables to analyze data populations
Adding Slicers and Timelines to Pivot Tables for interactivity
Visualizing insights with Pivot Charts
Making multiple-chart dashboards