Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel Data Analysis With Pivot Tables & Pivot Charts - 2026

Name: Excel Data Analysis With Pivot Tables & Pivot Charts - 2026
Rating: 4.5 (500 reviews)

Data analysis excel, data analysis, Pivot Chart, Microsoft excel, advanced excel, ms excel, Data Analytics, Excel, Data

Created byA.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office & Power BI)

Last updated 1/2026

English

English [Auto],

What you'll learn

Introduction Of Data Analytics
Introduction Of Pivot Table & Pivot Charts
The Five Steps For Data Analytics With Pivot Tables & Pivot Charts
Format The Raw Data For Pivot Tables
Convert The Raw Data To Table
Create The Pivot Tables
Create Recommended Pivot Tables
Change Pivot Table Name & Design
Work With Pivot Table Builder
Clearing & Reapplying Pivot Table
Copy , Move And Delete The Pivot Table
Creating Groups In Pivot Table
Custom Calculation In Pivot Table
Sorting , Filtering In Pivot Table
Working With Slicer
Update The Data In Pivot Table
Create The Pivot Charts
Change Pivot Charts Name & Design
Create Line Charts
Create Bar Charts
Create Column Charts
Create Pie Charts
Insert Slicers & Connect With Reports
Analysis Pivot Table & Pivot Charts
Create Dynamic Pivot Table And Pivot Charts Based On Our Needs And Wants

Course content

10 sections • 34 lectures • 2h 55m total length

Introduction Of Data Analytics5:31
Explore data as raw, unorganized facts such as texts, numbers, and observations, and apply data analytics to transform input into insights and outputs that inform decisions, performance, and customer-focused strategies.
Introduction Of Pivot Table And Pivot Charts5:34
Explore how pivot tables and pivot charts enable interactive, multi-perspective data analytics in Excel, linking tables to charts for quick, flexible, and visually clear insights.

Format The Raw Data For Pivot Tables4:47
Format the raw data for pivot tables by ensuring headers, removing blank rows and columns, maintaining consistent data types, and using the Kornblum blank function to check blanks.
Insert New Column4:37
Insert a column in Excel to compute work experience, placing it between nationality and date of joining, using today minus date joined, convert days to years, and round the result.

Create Pivot Table By Using Range4:13
Learn to create a pivot table using a range in Excel, compare range and table approaches, and insert the pivot table on a new or existing worksheet.
Convert Raw Data To Table3:50
Convert raw data to a table in Excel to prepare for pivot tables, using format as table, insert table, or keyboard shortcut, then customize the table name and style.
Modify The Table2:57
Learn how to add new records to an Excel table using end and mark shortcuts, navigate to first and last rows, and adjust font size and header selection.

Create Pivot Table4:13
Master data analytics with pivot tables and pivot charts by creating and naming pivot tables from a converted table, using the pivot table builder, design options, and slicer.
Create Recommended Pivot Table2:37
Learn to create a recommended pivot table in Excel using the insert ribbon, preview layouts like net salary by region and department, and place the result on a new worksheet.
Change Pivot Table Name & Design8:28
Learn to rename pivot tables and customize their design using the pivot table tools, adjusting headers, fields, values, filters, and font style for clear data analysis.
Pivot Table Builder & Clear & Rearrange3:53
Open the pivot table dialog with a shortcut, then build, rearrange, and clear pivot tables using drag-and-drop in the pivot table builder, applying nationality, region, gender, and salary layouts.
Copy , Move And Delete The Pivot Table3:24
Learn how to copy, move, paste, cut, and delete a pivot table, and analyze data by placing department in rows and net salary in values to gain insights.
Creating Groups In Pivot Table – Date Group6:05
Explore how to create groups in a pivot table using the date grouping feature, grouping by year, quarter, or month to analyze joining data across periods.
Creating Groups In Pivot Table – Number Group5:42
Learn to create pivot tables and group numeric data by intervals, such as 50 and 100, set start and end values, and apply counts or percentages of the grand total.
Custom Calculation In Pivot Table2:03
Create a calculated field in a pivot table to compute the year salary by multiplying monthly salary by 12, using the pivot table tools and the calculated field option.
Sorting , Filtering In Pivot Table6:51
Learn to create pivot tables, sort data by values, and filter by region, department, and nationality to count employees across the organization.
Working With Slicer6:29
Master pivot tables and slicers to filter data by gender, region, department, and nationality, connect slicers via report connections to multiple pivot tables for unified salary insights.
Update The Data In Pivot Table3:57
Learn to update and refresh pivot tables by adjusting source data, using find and replace for department changes, and refreshing all to reflect raw data updates.

Create Pivot Table For Pivot Chart10:14
Create pivot charts from pivot tables, customize design, and connect slicers to multiple tables to analyze region, department, nationality, and gender performance.
Create Line Charts6:58
Create a region-wide line chart from a pivot table by inserting a pivot chart, customizing design, colors, and data labels to display region performance.
Create Bar Charts3:06
Learn to create a department-wise bar chart from a pivot table, customize its design, colors, fonts, and chart title to visualize department performance.
Create Column Charts3:30
Create a column chart from the nationality pivot table, then customize its name, data labels, fonts, and appearance to show nationality wise performance.
Create Pie Charts4:27
Create a pie chart from a pivot table using the pivot chart tool, add data labels, adjust design and fonts, and set a title such as gender based performance report.
Insert Slicers & Connect With Reports8:29

Pivot Table & Pivot Chart Example-025:47
Explore data analytics with pivot tables and pivot charts on sales data, filter by province, analyze turnover and promotions, and build an interactive dashboard with a slicer.
Answer Question 1 & 28:56
Analyze sales data using pivot tables and pivot charts, converting raw data into a table, eliminating blanks, and identifying the highest and lowest selling provinces and sales reps.
Answer Question 32:21
Identify the highest and lowest turnover by using a pivot table, showing grapes as highest and watermelon as lowest, and note pricing with lower margins to boost sales.
Answer Question 4 & 5 & 63:03
Use pivot tables and charts to identify orange, banana, and watermelon as low turnover products and apply a 25% discount; analyze first quarter 2021 to spotlight Western Province and Karthik.
Answer Question 77:20
Create and customize pivot charts from pivot tables in Excel to visualize sales and product performance. Switch chart types, add data labels, and fine-tune design and titles for clear reporting.
Answer Question 85:11
Connect pivot tables and pivot charts with slicers, filter by zone, sales rep, demand, and product, and apply the report connection to link slicers with all pivot tables.

Requirements

No prior Excel knowledge is needed
Installed Microsoft Excel

Description

The Recent Student's Reviews

I am gassed to say that this course is practical and give you deep knowledge about data analysis - Mohammad M.
Wonderful Course. Really Loved it. - Syed Gohar A.
The instructor has good knowledge about the topic. It is really good course to learn Pivot tables and Pivot charts in short time - Nuha Fathin
crisp and clear, easier to understand - Rahul Parmar
Its good course - Jash Ruparalia

Eight Reasons why you should choose this Excel Data Analytics With Tables and Pivot Charts Course

You will learn various data analysis techniques using MS Excel
Latest updated and Doubts Are Solved in this course
Carefully designed curriculum By Proficient In Microsoft Excel Expert
you can complete this course In Short time
Pivot table & Pivot charts related examples and case studies Provided
Practical Examples And practice exercises Are Able to Download in The Recourse Section
Your queries will be responded by the Instructor With In Short time
A Verifiable Certificate will Be Provided On the Completion

Excel Pivot Tables & Pivot Charts are an absolutely Fundamental tool for anyone working with data in Excel. Pivots Table allow you to quickly explore and analyze raw data in Excel. It is powerful tools to analyze Excel Data in Different perspective. Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.
This course gives you a deep & comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you how to use Excel Pivot Tables & Pivot charts and introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way. After Completing This Course Your Are Able To Create Interactive & Visually Effective Pivot Charts Based On Your Pivot Table. it help us easy to analyzing and visualizing data with Microsoft excel.

This Course is covered the Following areas such as Excel Data Analytics, Pivot Table Tutorial, Pivot Charts Mastery, Data Analysis in Excel, Excel Analytics Course, Excel Pivot Table Skills, Advanced Excel Data Analysis, Pivot Table Techniques, Data Visualization with Pivot Charts, Excel Analytics Training.

What is key section in this course?

Chapter -01 Introduction Of Data Analytics With Pivot Tables & Charts

Introduction Of Data Analytics

Introduction Of Pivot Table And Pivot Charts

Chapter -02 The Five Steps For Data Analytics With Pivot Tables And Charts

The Five Steps For Data Analytics With Pivot Table And Pivot Charts
Chapter -03 Pivot Table & Pivot Chart Example -01
Data Analytics With Pivot Table & Pivot Chart Example-01

Chapter -03 Data Analytics With Pivot tables & Pivot Charts Example -01

Introduction Of Data Analytics With Pivot tables & Pivot Charts Example -01

Chapter -04 Format The Raw Data For Pivot Tables (Step 01)

Format The Raw Data For Pivot Tables
Insert New Column

Chapter -05 Convert The Raw Data To Table (Step 02)

Create Pivot Table By Using Range
Convert Raw Data To Table
Modify The Table

Chapter -06 Create Pivot Tables (Step-03)

Create Pivot Table
Create Recommended Pivot Table
Change Pivot Table Name & Design
Pivot Table Builder & Clear & Rearrange
Copy , Move And Delete The Pivot Table.
Creating Groups In Pivot Table – Date Group
Creating Groups In Pivot Table – Number Group
Custom Calculation In Pivot Table.
Sorting , Filtering In Pivot Table.
Working With Slicer.
Update The Data In Pivot Table.

Chapter -07 Create Pivot Charts (Step-04)

Create Pivot Table For Pivot Chart
Create Line Charts.
Create Bar Charts.
Create Column Charts.
Create Pie Charts.
Insert Slicers & Connect With Reports

Chapter -08 Analysis The Pivot Table & Pivot Charts (Step-05)

Analysis The Pivot Table & Pivot Charts

Chapter -09 Pivot Table & Pivot Chart Example-02

Introduction Of Question
Answer Question 1 & 2
Answer Question 3
Answer Question 4 & 5 & 6
Answer Question 7
Answer Question 8

This Course will be covered the following areas, who are trying to learn under these following topics such as Excel data analysis, pivot charts Excel course, advanced pivot tables, Excel pivot charts, Excel analysis techniques, data analysis in Excel, pivot tables for beginners, Excel for data analysis, Excel business analysis, mastering pivot tables, Excel data visualization, pivot table functions, pivot charts and tables, Excel data reporting, Excel dashboard, Excel for data analysis online, Excel training for data analysis, pivot table tips, Excel data manipulation, data analysis pivot table, advanced Excel data analysis, Excel reports with pivot tables, pivot tables in Excel tutorial, how to use pivot tables in Excel, Excel data analysis for business, data insights with Excel, Excel data analysis course, pivot table tricks, data presentation with Excel, learn Excel pivot charts.

This course will be answered for following questions and topics such as excel data analysis full course,excel data analysis crash course,excel data analysis online course,best excel data analysis course,excel course for data analysis,how to learn excel data analysis,advanced excel course for data analysis,excel data analysis course,ms excel data analysis course,excel data analysis training,excel data analysis courses,excel data analytics training,data analysis using excel training,excel used for data analysis,excel tools for data analysis,microsoft excel data analysis training,excel data analysis training online,data analysis training using ms excel,excel data analysis examples,best pivot table training excel course ,pivot tables pivot table training for beginners.

This course is covered for following areas such as summarize and analyse large data sets with Microsoft Excel Pivot Tables, Learn and Master Pivot Tables in Excel with this Beginner to Advanced course from Microsoft experts, Create and Analyse Data and Report with Excel Pivot Tables, Learn Data Analysis and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users, Master Excel Pivot Tables: Data Analysis, Advanced Charts and Dashboards | Downloadable Resource file and Practice file, learn to analyse and summarize data in seconds using Excel's most powerful data feature - pivot tables and Pivot Charts

Go ahead and click the enroll button, and I'll see you in Chapter 1!

Cheers

A.M.A.M.Mubeen

(Expert In Tally & Finance & Microsoft Office & Power BI)

Who this course is for:

Anyone who works with Microsoft Excel Even if you've never used a Data Analytics & Pivot Table & Pivot Charts
Anyone looking For A Career in Data Analytics or Business Intelligence
Students looking for a comprehensive Training For Data Analytics & Pivot Table & Pivot Charts

Excel Data Analysis With Pivot Tables & Pivot Charts - 2026

What you'll learn

Explore related topics

Course content

Chapter -01 Introduction Of Data Analytics With Pivot Tables & Charts2 lectures • 11min

Chapter -02 The Five Steps For Data Analytics With Pivot Tables And Charts1 lecture • 7min

Chapter -03 Pivot Table & Pivot Chart Example -011 lecture • 7min

Chapter -04 Format The Raw Data For Pivot Tables (Step 01)2 lectures • 9min

Chapter -05 Convert The Raw Data To Table (Step 02)3 lectures • 11min

Chapter -06 Create Pivot Tables (Step-03)11 lectures • 54min

Chapter -07 Create Pivot Charts (Step-04)6 lectures • 37min

Chapter -08 Analysis The Pivot Table & Pivot Charts (Step-05)1 lecture • 5min

Chapter -09 Pivot Table & Pivot Chart Example-026 lectures • 33min

BONUS SECTION1 lecture • 1min

Requirements

Description

Who this course is for: