This course introduces the PivotTable feature and covers all of the essentials. We start here to ensure that all participants, regardless of previous PivotTable experience, have the skills needed to do fundamental PivotTable activities and to build toward more advanced pivot table capability. We discuss the four report layout areas: rows, columns, values, and filters. We then discuss how to update PivotTable reports and ensure that any new transactions appended to the data source are included in the report. We explore how to create monthly columns and how to properly format the values in a PivotTable.
Course Series
This course is included in the following series:
4 CoursesPivotTable Essentials
- PivotTable Essentials
- How to Use PivotTables instead of Formula-Based Reports
- PivotTable Conclusion and External Data Introduction
- Using PivotTables and PivotCharts to Prepare External Data
Learning Objectives
- Explore the process to create a PivotTable report
- Identify the four PivotTable report layout areas
- Recognize which type of PivotTable field will create report filters
Included In Certifications
This course is included in the following Certification Programs:
9 CoursesExcel for Professional Applications Certification
- Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
- Excel Training: Skills for Better Workbook Design
- Excel Training: Boosting Proficiency with Selected Shortcuts (PC Version)
- Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
- Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
- PivotTable Essentials
- How to Use PivotTables instead of Formula-Based Reports
- PivotTable Conclusion and External Data Introduction
- Using PivotTables and PivotCharts to Prepare External Data
66 Reviews (214 ratings)
Prerequisites
No Advanced Preparation or Prerequisites are needed for this course.
Education Provider Information
![Instructor for this course Instructor for this course](https://www.illumeo.com/sites/proformative.com/files/imagecache/user_image_large/pictures/picture-57977-1461112412.jpg)