Excel Pivot Table Tutorial for Beginners | Step-by-Step Course
Learn how to create an Excel Pivot Table for beginners in this complete step-by-step tutorial.
This Excel Pivot Table tutorial explains how to summarize data, analyze sales, create reports, use slicers, build Pivot Charts, group ages, add calculated fields, and much more.
In this beginner-friendly Excel course, you will learn how to convert normal data into an Excel table and create professional Pivot Table reports using Rows, Columns, Values, and Filters.
We will use a practical customer sales dataset to answer important business questions, including:
✔ How many customers are from each city
✔ Which city has the highest sales
✔ Which weekday generates more sales
✔ Which devices are most popular
✔ How to display the Top 10 items
✔ Which customer age group purchases the most
✔ How to create Pivot Charts
✔ How to use Pivot Table filters and slicers
✔ How to use the Show Values As option
✔ How to create calculated fields and custom formulas
✔ How to expand and collapse Pivot Table data
✔ How to display a Pivot Table in tabular format
This tutorial is helpful for Excel beginners, students, office workers, accountants, business owners, MIS executives, data entry users, financial analysts, and anyone who wants to improve their data analysis and reporting skills.
Video Chapters
00:45 Introduction to Pivot Tables in Excel
01:06 Understanding the Excel Practice Dataset
01:36 Convert Normal Data into an Excel Table
01:55 How to Create a Pivot Table in Excel
04:40 Pivot Table Rows, Columns, Values and Filters Explained
05:40 Customer Count and Total Sales by City
08:11 Create Weekday Sales Report and Pivot Chart
10:05 Find Top 10 Devices and Use Pivot Table Slicers
12:18 Create Age Groups and Analyze Sales by Age Group
14:42 Show Values As Option in Excel Pivot Table
16:30 Create Calculated Fields and Custom Formulas
17:47 Expand and Collapse Pivot Table Data
18:47 Show Pivot Table in Tabular Form
19:16 Summary and Closing Remarks
Practice the steps using your own data to improve your Excel skills.
To receive the practice file, comment:
I need the Pivot Table file.
If this tutorial helped you, please like the video, share it with other Excel learners, and subscribe to Data Universe “B I” for more Excel, Power BI, Google Sheets, finance, and data analytics tutorials.
#ExcelPivotTable #ExcelTutorial #ExcelForBeginners