Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Pivot Tables - Microsoft Excel Pivot Table and Data Analysis
Rating: 4.4 out of 5(26 ratings)
3,670 students

Pivot Tables - Microsoft Excel Pivot Table and Data Analysis

Hands-On Microsoft Excel Pivot Table Training for Effective Data Analysis
Created byLogic Labs
Last updated 1/2026
English
English [Auto],

What you'll learn

  • Importing data from a Text File, Website and Access
  • Data Cleaning Techniques for Data Analyst
  • Creating and Manipulating a PivotTable
  • Combine Data from Multiple Sheets in a Single Sheet
  • Formatting Error Values and Empty Cells
  • PivotTable Styles
  • Custom Number Formatting
  • Summarizing Values
  • Advanced Sorting and Filtering
  • Inserting and formatting Slicers
  • Connecting Slicers to Multiple PivotTables
  • Use Pivot Tables and Slicers on Protected Worksheets
  • Creating a Calculated Field and Item
  • PivotTable Calculated Items and Solve Order
  • GETPIVOTDATA
  • Creating a Pivot Chart
  • Dynamic Chart Titles
  • Dynamic Sparklines with PivotTable
  • Highlight Pivot Table Cells With Conditional Formatting
  • Conditional Formatting and Slicers
  • Creating a Pivot table Dashboard
  • Advanced Pivot Table Techniques

Course content

1 section • 27 lectures • 5h 30m total length

  • Importing Data From a Text File6:10

    Master how to import data from text files such as CSV or TXT into Excel, choose delimiters, preview, and load for analysis and reporting.

  • Importing Data From Website8:22

    Learn to import data from a website into Excel using the get & transform from web feature, refine with Power Query, and keep datasets current with refresh.

  • Importing data from Access7:36

    Learn how to import data from a Microsoft Access database into Excel using get and transform data tools, choose table or pivot options, and refresh as needed.

  • Data Cleaning Techniques for Data Analyst15:49

    Master data cleaning in Excel to turn large datasets into reliable insights, using techniques to detect errors, blanks, hard-coded values, and inconsistent formulas for accurate data analysis.

  • Combine Data from Multiple Sheets in a Single Sheet12:17

    Learn to consolidate data from east, north, south, and west sheets into a single sheet using Excel's consolidate function and a pivot table report, enabling a data view and totals.

  • Grouping and Ungrouping8:50

    Group and ungroup data in excel to collapse and expand rows or columns using the data tab and outline options. Create hierarchical groups for multiple levels and manage visible data.

  • Formatting Error Values and Empty Cells11:35

    Learn to format error values and handle empty cells in Excel, using pivot tables, and adjust zero and blank displays to keep spreadsheets clean for accurate data analysis.

  • PivotTable Styles12:06

    Discover how to create and style pivot tables in Excel. Use the design tab to apply built-in or custom styles, adjust layout, and save your styles for reuse.

  • Custom Number Formatting20:38

    Master custom number formatting in Excel to display numbers with units, handle text alongside numbers, and create polished formats using currency, date, percentage, and conditional formatting.

  • Summarizing Values8:14

    Harness pivot tables to summarize data in Excel, using fields like store, country, region, price, and discount. Apply sum, average, max, and min via field settings to tailor value reports.

  • Show Values As9:48

    Use show values as in pivot tables to display revenue as percent of grand total, row totals, or column totals, using value field settings.

  • Advanced Sorting8:57

    Unlock advanced sorting algorithms, including merge sort and radix sort, and master Excel sorting options—ascending, descending, custom lists, color sorts—while considering time complexity and memory usage.

  • Advanced Filtering10:27

    Learn to apply advanced Excel filters to multi-criteria queries, using criteria and list ranges, wildcard text filters, and conditional operators to refine data analysis.

  • Inserting and Formatting Slicers8:27

    Insert and format slicers in pivot tables to visually filter data and enhance revenue analysis, with customizable styles and multi-select options for country and customer type.

  • Inserting and Formatting Timelines11:01

    Learn to add and use a timeline in a pivot table to filter data interactively by date, using slicers and pivot table tools for dynamic analysis in Excel.

  • Connecting Slicers to Multiple PivotTables11:58

    Connect a slicer to multiple pivot tables in Excel to filter several data views simultaneously, enabling coordinated analysis and visually appealing reports.

  • Use Pivot Tables and Slicers on Protected Worksheets9:47
  • Creating a Calculated Field9:29

    Create calculated fields in Excel pivot tables to perform custom calculations on sales data, such as sum of sales and commission across quarters.

  • Creating a Calculated Item8:48

    Create calculated items in Excel pivot tables to perform custom calculations and gain insights, using calculated fields and items to summarize orders by status.

  • PivotTable Calculated Items and Solve Order12:59

    Master calculated items and solved order in pivot tables to perform custom calculations and control calculation order for advanced data analysis in Excel.

  • GETPIVOTDATA9:35

    Learn how to use getpivotdata to extract specific data from pivot tables by setting data field, pivot table reference, and filters, enabling dynamic, searchable reports without vlookup.

  • Creating a Pivot Chart11:39

    Learn to create a pivot chart in Excel by organizing data, building a pivot table, and visualizing insights with column, line, or pie charts using fields and filters.

  • Dynamic Chart Titles10:23

    Learn to create dynamic chart titles in Excel by linking chart titles to pivot table data, using a text join formula and slicers to reflect data changes in pivot charts.

  • Creating an Interactive Dashboard16:48

    Create an interactive Excel dashboard using pivot charts, maps, and slicers to visualize data such as total sales, unit sales, and operating margins, driven by a clear dashboard layout.

  • Creating a Pivot table Dashboard13:33

    Learn to build an interactive pivot table dashboard in Excel using pivot tables, slicers, charts, and timelines to slice data by regions, retailers, customers, and metrics like revenue and profit.

  • Advanced Pivot Table Techniques24:19

    Master advanced pivot table techniques in Excel, including calculated fields, data bars, one-click multi-report creation, grouping and timeline filtering, and custom formatting for deeper data insights.

  • Top 25 Advanced Pivot Table Tips & Tricks31:02

    Master Microsoft Excel pivot tables with the top 25 advanced tips and tricks, from grouping and slicers to conditional formatting, report filters, and timeline insights for data analysis.

Requirements

  • Basic knowledge of Microsoft Excel is beneficial but not required

Description

Mastering data is no longer optional—it's essential. Whether you're a business professional, student, analyst, or someone working with spreadsheets every day, understanding Pivot Tables can completely transform how you organize, interpret, and present information. This course is designed to take you from the basics to advanced techniques, giving you full confidence in using Microsoft Excel Pivot Table tools for real-world Data Analysis. With a clear, step-by-step approach, you will learn not just how Pivot Tables work, but how to use them to uncover insights that drive smart decisions.


In this comprehensive training, we begin by helping you understand why Pivot Tables are one of the most powerful features in Excel. You will explore the core structure of Pivot Tables, learn how to create them from scratch, and understand key components such as rows, columns, values, and filters. Through practical examples, you will see how Pivot Tables instantly summarize large datasets, turning thousands of rows into meaningful information within seconds. Even if you have never used Pivot Tables before, this course ensures that every learner quickly becomes comfortable and capable.


You will explore advanced functionalities such as grouping data, applying number formats, customizing layouts, and using calculated fields. You will also work with Pivot Charts to visually represent your data for clearer presentations and reports. These lessons are filled with real-life business examples, allowing you to practice with scenarios that mirror common workplace tasks. Our goal is to ensure you not only understand the tools but also know how to apply them effectively in your daily responsibilities.


The course also focuses heavily on central Data Analysis skills. You will learn how to clean, organize, and prepare data so your Microsoft Excel Pivot Table reports are both accurate and insightful. Topics such as sorting, filtering, removing duplicates, and structuring tables play an essential role in ensuring your results are reliable. By building a strong foundation in data preparation, you’ll become more efficient and confident when working with large or complex datasets.


One of the highlights of this course is learning how to analyze trends and patterns using Pivot Tables. You will discover how to compare monthly performance, measure year-over-year growth, identify top-performing segments, and evaluate business KPIs—all with simple drag-and-drop tools inside Excel. Whether you work in sales, finance, HR, marketing, or operations, these techniques allow you to create dynamic reports that offer immediate insights and simplify decision-making.


Beyond the instructional lessons, you will also get hands-on practice with real datasets designed to simulate workplace tasks. Each exercise reinforces what you’ve learned and helps you build confidence using Pivot Tables for various Data Analysis needs. By the end of the course, you will be able to create automated dashboards, summarize any dataset, and quickly answer complex data questions—all within Microsoft Excel. This practical, skill-based approach ensures that you can apply your new knowledge immediately at work or in academic projects.


What You’ll Learn

  • How to create, customize, and update Pivot Tables

  • Sorting, filtering, and grouping data for better insights

  • Using Pivot Charts to visualize patterns and trends

  • Advanced tools: Slicers, Timelines, and Calculated Fields

  • Best practices for cleaning and preparing data

  • How to build automated, interactive dashboards

  • Time-saving techniques every Excel analyst should know


By enrolling in this course, you are investing in a skillset that makes you more productive, more informed, and more valuable in any professional environment. Whether you're analyzing sales reports, tracking expenses, managing employee data, or preparing presentations, Pivot Tables allow you to work smarter and deliver results faster.


Enroll now and discover how mastering Pivot Tables, Microsoft Excel Pivot Table techniques, and essential Data Analysis skills can elevate your career, boost your confidence, and transform the way you work with data.

Who this course is for:

  • Anyone who wants to analyze data faster and more accurately
  • Students preparing for data-driven careers
  • Beginners wanting to learn Excel data analysis
  • Professionals working with reports, finance, accounting, HR, sales, or operations

Report abuse