Creating and Managing PivotTables 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 in Excel 365 are vital for organizing, summarizing, and refining large data sets efficiently. In this course, you will learn how to create and customize PivotTables, selecting the appropriate data for analysis and enhancing the table's visual layout for better readability. Next, discover advanced features such as slicers for dynamic data filtering, which enhance the user's ability to explore and present data. Additionally, you will learn how to apply label and value filters to focus on specific data points. The course also covers adding calculations within PivotTables for complex data operations. Lastly, you will learn to address common PivotTable issues, offering troubleshooting strategies that help users solve problems independently and maintain the quality of their data analysis. 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.