Excel Pivot Tables & Analysis 2026

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

Create, Analyze Data and Report with Excel Pivot Tables

Created byKadhiravan Jayachandiran, KultureHire Edtech, Priyanka P

Last updated 7/2026

English

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

Introduction to the Course1:19
Download Practice Files0:01
Introduction to Pivot Tables3:09
Pivot Table Interface and our First Pivot Table2:46
How Pivot Table Works2:35

First Pivot Table with a Calculation9:23
Different Calculations from the Same Field7:57
Using Rows and Columns for 2 different fields2:17
Using Rows for categorical analysis in Pivot Tables4:34
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
Label and Value Filtering in Pivot Tables6:30
Values Filtering in Pivot Tables1:39
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

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
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
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
Find the variations of click through rate across channels3:34
Distribution of campaigns targeting different age groups4:03
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
Find the actual campaign spend vs the allocated budget6:11
Find the campaigns returns on investment across formats6:14
Find the average cost per click for campaigns and formats6:45
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: