Excel Pivot Tables & Analysis 2026

Name: Excel Pivot Tables & Analysis 2026
Rating: 4.5 (2062 reviews)

Create, Analyze Data and Report with Excel Pivot Tables

Highest Rated

Created byKadhiravan Jayachandiran, KultureHire Edtech, Priyanka P

Last updated 7/2026

English

English [Auto],

What you'll learn

Fundamentals to Advanced Techniques: Start from basic data analysis and become proficient with Excel Pivot Tables.
Exclusive Insights: Access unique Pivot Table strategies and tools, with insights not found in other courses.
Engaging & Effective Learning: Experience interactive lessons from a top-rated Excel instructor.
Learn how to use Pivot Tables to streamline and absolutely revolutionize your workflow in Excel

Course content

7 sections • 60 lectures • 3h 53m total length

Introduction1:19
Download Practice Files0:01
Introduction to Pivot Tables3:09
Pivot Table Interface and our First Pivot Table2:46
How Pivot Table Works2:35
Learn how pivot tables create a separate analysis environment, connect to your data, and use pivot table fields (filters, rows, columns, and values) to compute sums like price.

First Pivot Table with a Calculation9:23
Different Calculations from the Same Field7:57
Using Rows and Columns for 2 different fields2:17
Explore how to use rows and columns in pivot tables to compare online and offline average sales by agent, and manage field labels for a cleaner report.
Using Rows for categorical analysis in Pivot Tables4:34
Create a pivot table with the agent field in rows to show each agent's number of sales, total sales, and average sales, then format as currency and set clear headers.
Using Rows and Columns in Pivot Tables for the Same Field5:22
Managing Labels of a Complex Pivot Table1:32
Sorting Values in Pivot Table4:26
Sort pivot table values to rank products by overall sales in descending order, identifying top and bottom performers using the sort options.
Label and Value Filtering in Pivot Tables6:30
Values Filtering in Pivot Tables1:39
Learn how to apply values filtering in pivot tables to show only results where the total sales exceed 10,000, using value filters on the calculated outcome rather than individual transactions.
Report Level Filters in Pivot Tabels8:06
Formatting Values in Pivot Table1:45
Managing Date Information in Pivot Tables4:55
Moving and Managing Pivot Tables1:16

Multi Field Calculations in Pivot Tables1:54
Top 3 and Bottom 3 in Pivot Tables6:57
Learn to build a pivot table that shows the top 3 and bottom 3 products by overall sales, with average customer satisfaction, using dynamic filters.
Changes in the Data Source1:48
Adding New Rows of Data to the Pivot Table - Manual Method2:27
Range Vs Table Source for Pivot Tables2:55
Convert the data range to a table to enable automatic expansion with new rows or columns, then refresh the pivot table to reference the updated table.

Grouping Data in Pivots5:28
Grouping Date info in Pivot Table5:10
Group dates into weeks in a pivot table, sum weekly sales, rename weeks, and format to reveal seasonality and guide business decisions.
Grouping Text Info in Pivot Table7:45
Using Slicers to Filter Reports10:44
Using Timelines to Filter Reports5:55
Pivot Tables Assignment Answer11:53
Create pivot tables to answer assignment questions, computing overall sales, average ratings, orders, and average discount, then add slicers and connect reports by agent, product, location, and order type.
Answer File for Pivot Tables So far0:03

Practice file for this section0:01
Introduction to Advanced Pivot Tables0:39
Understanding Distribution and Converting Insights into Actionable Ones2:27
Calculating % of Grand Total and its Significance3:08
How % of ROW Total works1:47
Calculating - % of Row Total on a Dataset1:47
Visualizing Complex Pivot Data2:59
Calculating % of Column Total1:22
Changing the Calculations to % of Column Total2:33
Set pivot table values to percentage of column total to compare product sales across online and offline channels. Visualize the distribution with a 100% stacked bar chart for clear insights.
Visualizing the Distribution Charts2:56
Calculating % of Custom Field1:54
Calculating % of Parent Row Total1:51
Calculating Difference From in %2:06
Running Total and Assignment Walkthrough2:40
Explore how running totals reveal monthly sales trends in pivot tables, show final price values, and analyze the percentage of running total to derive actionable insights.
Practice file with answers - Download0:01

Project Data Download0:01
Monthly/Quarterly/Yearly Analysis of No of Marketing Campaigns6:22
1. How many orders were placed each day/week/month?
Average duration of campaigns and Channels6:28
Campaign performance over a period of time - CTR using Calculated Field11:35
Find the distribution of campaigns across different channels5:54
Create a pivot table to count campaigns by channel and view the distribution across channels. Customize the pivot chart with a bar chart, adjust layout, and colors for clarity.
Find the variations of click through rate across channels3:34
Distribution of campaigns targeting different age groups4:03
Create a pivot table from marketing data to analyze the distribution of campaigns across different age groups, then visualize with a pivot chart to compare campaigns by age group.
Find out which age groups have the highest engagement rates5:48
Find what is the distribution of campaigns by target location3:36
Find out the average budget allocated to campaigns6:04
Learn to compute the average budget allocated to marketing campaigns with Excel pivot tables, format currency in USD, and visualize results with a pivot chart.
Find the actual campaign spend vs the allocated budget6:11
Find the campaigns returns on investment across formats6:14
Explore how to calculate and visualize campaign ROI using pivot tables, calculated fields, and combo charts in Excel, showing spend and sales to compare performance across campaigns and channels.
Find the average cost per click for campaigns and formats6:45
Calculate the average cost per click by building a calculated field in a pivot table (spend divided by clicks), then analyze CPC across campaigns and formats.
Answer File for this Marketing Analytics using Pivot Tables0:02

Requirements

Basic Excel Knowledge
Microsoft Excel 2010-2019 or Office 365

Description

PIVOT TABLES are the most sought out feature of Excel and is often used at work environment.

In this course you will learn a lot about Pivot Tables.

You'll get to learn about the below scenarios:

Inserting a Pivot table from a simple dataset
Inserting Fields and giving a shape to Pivot Table
Changing Views and understanding Views for different data
Moving Pivot Tables
Inserting and Managing Timelines
Inserting and Managing Slicers
Grouping Data on Excel
Filtering Data on Excel

Pivot Tables has been critical for most of the tasks at work. However it had its disadvantages and is often time consuming if the data is complex.

YourExcelGuy is the first and only platform that provides animation videos for excel skills. We have put together more than 100 videos that demonstrate every excel skill you can imagine - whether it's for absolute beginners or advanced users. Our content includes transformations, graphics, conditional formatting, data tables, pivot tables, dashboards, or VBA macros.

About the Instructor: I'm a Microsoft Certified Excel Expert and a full time Excel coach, I train people on Excel and that's something I really love doing.

Currently I have trained over 50000+ students. With over 4 years of training experience and 11+ years of using Excel every single day I've learnt a lot of tricks in excel

Who this course is for:

Anyone getting started with Pivot Tables

Excel Pivot Tables & Analysis 2026

What you'll learn

Explore related topics

Course content

Pivot Table Foundations5 lectures • 10min

Building Business Reports with Pivot Tables13 lectures • 1hr

Real-World Pivot Table Analysis5 lectures • 16min

Advanced Pivot Table Reporting & Automation7 lectures • 47min

Advanced Business Calculations in Pivot Tables15 lectures • 28min

Marketing Analytics Dashboard with Pivot Tables14 lectures • 1hr 13min

Course Wrap-Up1 lecture • 1min

Requirements

Description

Who this course is for: