Loading...

Course Description

Learn how to save time extracting, organizing, and summarizing meaningful data from Excel spreadsheets or other sources by creating interactive PivotTables and PivotCharts. Explore how to create and customize a PivotTable, view subsets of data, and show or hide details. Discover how to create and design a PivotChart to view the summarized data in graphical format. Set up a PivotTable from a large database to view specific data and work with calculation/date fields. Discover the tips and shortcuts that will make you more efficient and your PivotTables more effective in summarizing your data.

In this course, you will learn to: 

  • Querying large amounts of data in very user-friendly ways 

  • Summarizing data by categories and subcategories, and creating custom calculations and formulas. PivotTables calculate the values for you 

  • Viewing and using the detailed data that exists behind the summarized data 

  • Expanding and collapsing levels of data to pinpoint your results 

  • Switching rows to columns or columns to rows (or “pivoting”) to best suit your needs 

  • Grouping, sorting, or filtering your data to gain the most useful view of your information 

  • Using Slicers to filter data in a user-friendly way 

  • Grouping data to view specific information 

  • Basing one PivotTable on another 

  • Using custom calculations 

  • Viewing data from an Access database with a PivotTable 

Prerequisites

Intermediate Applications of Excel or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to Excel PivotTables
Type
Discussion
Days
W
Time
8:30AM to 4:00PM
Dates
Jun 12, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 10, 2024
Transfer Request Deadline
Jun 10, 2024
Section Title
Introduction to Excel PivotTables
Type
Discussion
Days
W
Time
8:30AM to 4:00PM
Dates
Jun 12, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 10, 2024
Transfer Request Deadline
Jun 10, 2024
Required fields are indicated by .