Excel Pivot Tables

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.

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
  

Advanced Features

• 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