interactive
Microsoft Office 2016: Excel Part 4 (Data Analysis with PivotTables)
Master PivotTables and PivotCharts in Excel 2016 to transform raw data into insightful analyses and presentations.
Sonic Performance Support
Updated Jul 03, 2025
What you'll learn
- Prepare and manipulate data to create insightful PivotTables from a variety of sources, including external databases.
- Analyze complex data sets using advanced PivotTable techniques, including grouping, slicing, and custom calculations.
- Create and customize PivotCharts to visually represent data and enhance the interpretability and impact of your findings.
- Use advanced data analysis tools within PivotTables and PivotCharts to make strategic business decisions.
- Refresh and modify PivotTable data as source data changes, ensuring that your analysis remains current and relevant.
Course Description
"Microsoft Excel 2016 - Part 4: Data Analysis with PivotTables" is an advanced course designed for Excel users who want to take advantage of the advanced features of PivotTables and PivotCharts. Over the course of 1 hour and 11 minutes, this course explores the transformation of raw data into insightful PivotTables and dynamic PivotCharts that enable data-driven business decisions.
This course is designed to provide you with the skills to effectively organize, analyze, and present data, giving you a competitive edge in data analysis and presentation.
THIS COURSE IS SUITABLE FOR YOU, IF
- You are an experienced Excel user who wants to enhance your data analysis skills with PivotTables.
- You want to understand and apply advanced features of PivotTables to analyze large and complex data sets.
- You want to present data in a compelling way and make data-driven decisions that are critical to business success.
