Excel Pivot Tables
Welcome to the Excel V Pivot Tables class!
In this course, we will dive into the powerful world of pivot tables in Microsoft Excel, empowering you to efficiently organize, analyze, and gain valuable insights from your data. Pivot tables offer a dynamic and flexible way to summarize and manipulate large amounts of information. We will explore the features of pivot tables, starting with sorting and grouping pivot table items, allowing you to organize your data in a meaningful way. You will learn how to customize pivot table layouts, enabling you to rearrange and structure your data to suit your analysis needs. Additionally, we will delve into the functionality of adding data fields that calculate, such as sums, averages, counts, and more, providing you with the ability to derive key metrics and perform in-depth analysis. By the end of this class, you will possess the skills to create and customize pivot tables that transform raw data into meaningful reports, enabling you to make informed decisions and uncover valuable insights. Get ready to harness the power of pivot tables and take your data analysis capabilities to new heights in Excel.
|Open Seats In-Person
|Open Seats Online
|Excel Pivot Tables
|1PM - 4PM
Need a Different Date?
Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.
Pivot Table Basics
- Creating A Pivot Table
- Laying out a New Pivot table On the Worksheet
- Adding Sub-Details to an Item
- Managing Pivot Tables
- Grouping Pivot Table Items
- Displaying Pivot Table Details
- Creating a Slicer
Pivot Table Layouts
- Adding/Deleting Subtotals
- Grouping Text Fields
- Inserting a Chart
- Adding a Calculated Percentage Field
- Displaying the Top/Bottom Number of Items
- Adding a Calculated Field
- Adding a Data Field That Calculates the Difference Between Two Data Fields
- Adding a Data Field That Calculates Percentages from One Item of the Row Field
- Adding a Data Field That Calculates
- Automatically separating data with pivot tables