Pivot Tables in Microsoft Excel: Pivot Table & Data Analysis

Name: Pivot Tables in Microsoft Excel: Pivot Table & Data Analysis
Rating: 4.2 (10 reviews)

Learn Pivot Tables in Microsoft Excel to Boost Your Pivot Table & Data Analysis Skills.

Created byLogic Labs

Last updated 1/2026

English

What you'll learn

Removing Blank Rows & cell
Removing Duplicate Rows
Clearing Formatting
Removing Spaces and Non-printing Characters
Merging and Splitting Columns
Convert Number To Text Without VBA
Finding and Replacing Text
Excel Tables vs Pivot table
Format Data as a Table
Using Recommended Pivot Tables
Creating a Pivot Table from Scratch
Pivot Table Ribbons and Fields
Pivoting the Fields and More

Course content

1 section • 36 lectures • 4h 51m total length

Removing Blank Rows & Cell8:55
Remove blank rows and cells from your Excel worksheets to clean data for analysis and presentation. Use techniques like count blank, go to special, and filters.
Removing Duplicate Rows6:45
Learn to clean Excel data by removing duplicate rows using the data tab's remove duplicates feature, selecting columns to check, and preserving unique values.
Clearing Formatting7:27
Master how to clear formatting in Excel by using the clear format option, the format painter, and clear rules from conditional formatting to keep sheets clean.
Removing Spaces and Non-printing Characters8:52
Merging and Splitting Columns8:46
Master merging and splitting columns in Excel to organize data efficiently. Use concatenate, merge and center, and text to column, choosing delimited or fixed width as needed.
Convert Number To Text Without VBA8:48
Learn to convert numbers to text in Excel without VBA, including money to text for different currencies, using formulas and add-ons in Google Sheets.
Finding and Replacing Text10:19
Master finding and replacing text in Excel with the find and replace tool, choosing scope (workbook or sheet), look in values or formulas, and applying match-case control.
Excel Tables vs Pivot table8:50
Learn how to create and use Excel tables for structured data management and simple calculation, and how pivot tables summarize and analyze large datasets with filtering and field options.
Format Data as a Table7:30
Using Recommended Pivot Tables8:11
Explore how to use Excel's recommended pivot tables to quickly summarize sales data by regions, items, or countries, and customize layouts, filters, and calculations.
Creating a Pivot Table from Scratch7:27
Learn to create a pivot table from scratch in Excel, using a dataset with stores, countries, regions, items, salesperson, and actual price, to analyze and summarize data.
Pivot Table Ribbons and Fields10:39
Pivoting the Fields7:30
Master pivoting the fields in Excel to summarize sales data by regions and quarters with pivot tables, and tailor calculations, filters, and presentation for insights.
Deleting Fields and Locking the Report Layout7:13
Learn to create and customize pivot tables, delete fields, and lock the report layout with slicers and protected sheets for polished, consistent data analysis.
Excel Aggregate Function12:50
Grouping and Ungrouping Data7:33
Subtotals and Grand Totals12:32
Explore subtotals and grand totals in Excel to summarize data efficiently, using subtotal and sum functions, plus grouping, ungrouping, and comparing grand totals with subtotals for data analysis.
Pivot Table Layouts10:12
Inserting Blank Rows3:49
Learn to insert blank rows in Excel to organize data and boost readability, using quick tricks like auto-filling serial numbers, dragging fills, and applying filters.
Create Pivot Table Styles6:54
Learn to create and apply custom pivot table styles in Excel, using the design tab to select, modify colors, borders, fonts, and table elements for visually appealing data analysis.
Change the Pivot Table Style5:29
Sorting Pivot Table6:57
Filter Data in Pivot table using Slicer7:00
Master dynamic data analysis in Excel by creating a pivot table, adding fields, and inserting slicers to filter by country and year with multi-select options.
Filter Top 10 Items In Pivot Table6:14
Master filtering top ten items in an Excel pivot table, using value filters to reveal top trends and key insights from your data.
How To Select The Right Chart Type7:41
Learn to pick the right chart type in Excel by understanding your data and goals, matching data to column, line, bar, pie, scatter, or area charts.
Pivot Table Clustered Column Chart6:14
Line Charts7:33
Pie & Donut Charts8:25
Map Charts7:17
Create a map chart from pivot tables to visualize sales and quality by country, then customize colors, styles, data labels, and filters.
Pivot Table Slicer10:34
Learn to create and customize pivot table slicers in Excel to filter by region, date, retailer type, and customers, making interactive, easily filterable reports.
Pivot Table Timeline7:48
Connecting Slicers and Timelines with Multiple Pivot Charts7:53
Connect slicer timelines and multiple pivot charts to build a dynamic dashboard in Excel, linking pivot tables, slicers, timelines, and charts for interactive data analysis.
Highlight Cell Rules10:33
Master highlight cells rules in Excel's conditional formatting to emphasize data using greater than, less than, between, equal to, date occurrences, text contains, and duplicates or unique values.
Data Bars in Excel5:47
Learn to visualize numerical data in Excel with data bars using conditional formatting, customize colors, manage rules, and display bars only for clear, engaging data analysis.
Color Scales in Excel7:43
Learn to apply color scales in Excel through conditional formatting, using three-color gradients to reveal trends and patterns in unit price data, customize colors, and manage or remove rules.
Icon Sets In Excel7:22
Master icon sets in Excel via conditional formatting to visualize data with arrows and color scales, tailor rules, and display icons to highlight values in your data set.

Requirements

No microsoft excel experience needed
You only need access to Microsoft PowerPoint (Office 365, 2019, 2021 or recommended) and a computer.

Description

Unlock the full power of your data with this comprehensive course on Pivot Tables in Microsoft Excel. Whether you’re a beginner or someone looking to refine your skills, this training will show you how to confidently summarize, analyze, and present data using one of Excel’s most powerful tools.

Pivot Tables are essential for anyone who works with data—students, professionals, business analysts, or managers. In this course, you’ll learn how to turn raw information into meaningful insights, allowing you to make smarter decisions faster.

understanding what a Pivot Table is, why it’s so useful, and how to create one step by step. Even if you’ve never worked with Pivot Tables before, you’ll quickly discover how intuitive and valuable they can be.

From there, I explore practical techniques for organizing data, grouping values, sorting, filtering, and applying different layouts. You’ll gain hands-on experience working inside Microsoft Excel to perform tasks that once seemed complicated.

As the course progresses, you’ll learn advanced Pivot Table features such as calculated fields, slicers, timelines, and Pivot Charts. These tools allow you to build dynamic and interactive dashboards that elevate your Data Analysis to a professional level.

Throughout each lesson, you’ll work with real-world examples designed to mirror the challenges faced in business, finance, marketing, and operations. This ensures you're learning directly translates into practical workplace results.

You’ll also learn best practices for cleaning and structuring data before building a Pivot Table. Good preparation makes data analysis faster, easier, and far more accurate, especially when working with large datasets.

What You Will Learn

How to create Pivot Tables from scratch—even if you’ve never used them before
Techniques for grouping, sorting, and filtering data efficiently
Using Pivot Charts to visually present data trends
How to build interactive reports using Slicers and Timelines
Calculated Fields & Items for deeper analysis
Summaries like COUNT, SUM, AVERAGE, MAX/MIN, and percentages
Data cleaning and preparation for better analysis
Real-world techniques used in business, finance, and data analytics
Best practices for automating repetitive analysis tasks

Why This Course?

This course is designed to be simple, practical, and result oriented. Every lecture is built around examples that reflect real office scenarios. You’ll gain the confidence to handle data professionally and create reports that impress clients, employers, and stakeholders.

By the end of this course, you’ll not only master Pivot Tables but also understand how to apply them strategically. You’ll know how to identify trends, spot patterns, highlight opportunities, and present findings clearly to colleagues or clients.

Whether your goal is to save time, improve reporting, or strengthen your analytics skills, this course offers everything you need. With clear instruction and practical examples, you’ll gain confidence in using Microsoft Excel for effective Pivot Table & Data Analysis.

Enroll today and take the next step in your data journey. Mastering Pivot Tables will not only improve the way you work—it will transform the way you understand and communicate information.

Who this course is for:

Beginners who want clear guidance from start to finish
Professionals preparing for job interviews or career advancement
Anyone handling large datasets and needing quick insights
Excel users wanting to enhance their data analysis skills
Data analysts, accountants, business managers, and students