Using PivotTables and PivotCharts in Excel 365 (2024)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. PivotTables and PivotCharts are useful tools to enhance Excel 365's data analysis capabilities. In this course, discover the different techniques to manipulate data in a PivotTable and create an insightful PivotChart to visualize data. First, discover how to sort and filter data within PivotTables to concentrate on pertinent information, and to group data to uncover trends and summarize complex datasets. To filter data by time periods, learn how to insert and work with a Timeline. Next, analyze data within PivotTables by comparing values and extracting significant insights. Similarly, learn how to manage PivotTables connected to multiple data sources, enabling the transformation of extensive databases into concise reports. In addition to data analysis, discover how to work with PivotCharts, a dynamic visual tool to represent PivotTable data effectively. For instance, learn how to customize and modify PivotCharts to ensure data visualization aligns with presentation objectives. This course aligns with the objectives of MO-211: Microsoft Excel Expert (Microsoft 365 Apps). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.