Learning Method: Take Pivot Tables Classes Online or In-Person. Duration: 0.5 Day
*Click here to view upcoming Excel Pivot Tables Classes
Overview:
In this course, students will create and analyze PivotTable data in Microsoft Office Excel worksheets and workbooks.
Who Should Attend:
This course is designed for people who would like to become experts in creating and using excel PivotTables and PivotCharts. Students must be competent to use Excel to take this course.
At Course Completion:
Upon successful completion of this course, students will be able to:
- Build a Pivot Table
- Analyze data using Pivot Tables
- Present Pivot Table data visually
Course Outline:
Lesson 1: Building a PivotTable
- Insert a Pivot Table
- Create a Pivot Table Based on External Data
- Categorize Pivot Table Data
- Customize a Pivot Table
Lesson 2: Analyzing Data Using Pivot Tables
- Create Custom Calculations in a Pivot Table
- Restructure a Pivot Table
Lesson 3: Presenting Pivot Table Data Visually
- Format a Pivot Table
- Present a Pivot Table in a Pivot Chart
- Print Pivot Tables and Pivot Charts
Appendix A: Solvers
Appendix B: Goal Seek
Appendix C: Troubleshooting Pivot Tables
