Catalog

As data volumes grow, the ability to analyze and present data effectively has become crucial for informed decision-making. This course is tailored for individuals who already have experience with Microsoft Excel and basic PivotTables but are looking to deepen their skills. By mastering advanced PivotTable functionality and creating PivotCharts, participants will be equipped to not only summarize and analyze data but also to organize it in ways that can be effectively communicated to stakeholders. Throughout the course, participants will engage in hands-on exercises using Office 365 to prepare data for PivotTable reporting from various sources, analyze that data, and create PivotCharts that visually represent key insights. By the end of the course, attendees will have the skills necessary to leverage Excel’s powerful tools to support data-driven decisions that contribute to business success.

##### Module 1 - Preparing Data and Creating PivotTables - Prepare Data - Create a PivotTable from a Local Data Source - Create a PivotTable from Multiple Local Data Sources - Create a PivotTable from an External Data Source ##### Module 2 - Analyzing Data by Using PivotTables - Summarize PivotTable Data - Organize PivotTable Data - Filter PivotTable Data - Format a PivotTable - Refresh and Change PivotTable Data ##### Module 3 - Working with PivotCharts - Create a PivotChart - Manipulate PivotChart Data - Format a PivotChart