We may earn an affiliate commission when you visit our partners.
Course image
Alex Mozes

Master Excel Pivot Tables and save the world.

This course discusses one of the most powerful tools of the Office Ninja's arsenal, Excel Pivot Tables and how to use pivot tables. It's potential for analyzing and summarizing data is legnendary, but few have mastered its intricacies. Through a series of easy to follow lessons on how to use pivot table in excel, you will be introduced to the concepts, techniques and powerful features of this mysterious excel tool, and can follow along with each step with the included sample file.

We will cover:

● Pivot Table Concepts

● Creating A Pivot Table

Read more

Master Excel Pivot Tables and save the world.

This course discusses one of the most powerful tools of the Office Ninja's arsenal, Excel Pivot Tables and how to use pivot tables. It's potential for analyzing and summarizing data is legnendary, but few have mastered its intricacies. Through a series of easy to follow lessons on how to use pivot table in excel, you will be introduced to the concepts, techniques and powerful features of this mysterious excel tool, and can follow along with each step with the included sample file.

We will cover:

● Pivot Table Concepts

● Creating A Pivot Table

● Modifying Pivot Table Elements

● Filtering Extraneous Data (the Slicer tool)

● Creating Multiple Pivot Tables

● Creating Pivot Charts

● Advanced Analysis Techniques

Learn how to use pivot table in excel today.

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Learning objectives

  • Master excel pivot tables
  • Learn to harness these skills to get a raise
  • Solve world hunger

Syllabus

section 1
Welcome!
The basics
EXERCISE FILES
Read more

This First lecture sets the stage for understanding Pivot Tables by first explaining how to create automatic Subtotals.  In this lecture you will learn how to:

  • Analyze large data sets by the different types of field data
  • Quickly create subtotals
  • Collapse lists for a given type of groupable data

This Lecture explains the fundamental concepts behind what a Pivot Table is and why it is useful. At the end of this lecture you will understand what a pivot table is doing and how it acts as a "Super Subtotal

In this lesson you will create your first pivot table. Learn how to:

  • Insert a pivot table to your workbook
  • Work with the Field List
  • Modify your Pivot Table
  • Remove fields

Take this quiz and see if you've been paying attention :)

Now that you have created a Pivot Table, we want to learn how to control how values are displayed in that table. In this lesson, you will learn how to:

  • Change the Pivot Table function from the default Sum to other functions
  • Change the Way values are displayed to % of ...

In this lesson, we uncover a nifty feature of Pivot Tables, the Drill To feature which allows you to easily display the original records that made up a specific value in the pivot table.

This lesson explores how to format your Pivot Table so it looks the way you want, and so you can share it with other people in a professional format. You will learn how to:

  • Apply a Style to your Pivot Table
  • Change the Number Format of your values

In this lesson, we raise the stakes and begin to explore the true power of Pivot Tables by adding more than one field to the row and column areas. This will allow you to get even more specific on the type of trends you are able to extract from your data. You will learn how to:

  • Add multiple fields to the Row and Column labels
  • Re-organize the layout of the fields
  • Manage multiple fields in the Pivot Table

When dealing with large data sets, it's often important to be able to filter ou the extraneous data that is cluttering the answers you're looking for.  In this lesson, you learn how to do that from within the Pivot Table, and with a new filtering tool to Office 2010, the Slicer.

  • Filter the row and column labels to hide certain values
  • Create a slicer to filter the entire table without showing values
  • Use the slicer tool to quickly manipulate your data

This lesson explores how to create a dashboard, or rollup of lots of different aspects of your dataset onto one sheet with multiple Pivot Tables.  This is especially useful when the data is changing regularly or you want to look at different trends in your data at the same time.

  • Add multiple Pivot Tables to the same sheet
  • Manage multiple Pivot Tables
  • Connect one Slicer to multiple Pivot Tables

By graphically representing data, you can more easily identify trends or key performance indicators in your data, and make it easier to explain your findings to others.  In this lesson, we see how to create a Pivot Chart that reflects the Pivot Table, and how to manipulate that chart

  • Create a Pivot Chart
  • Format a Pivot Chart
  • Add additional elements to a Pivot Chart

In this final lesson, we explore more real world examples of how Pivot Tables can answer important business questions using the tools we've discussed.

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Helps learners harness analytical skills to get a raise or solve world hunger, indicating a connection between developing skills and real-world benefits
Explores Excel Pivot Tables, a powerful tool for data analysis and summarization, indicating relevance to spreadsheet users and analysts
Taught by Alex Mozes, indicating the involvement of an industry professional
Provides step-by-step lessons and an included sample file for hands-on practice, indicating a practical approach and support for learners
Covers various techniques and features of Pivot Tables, indicating comprehensive instruction

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Mastering excel pivot tables for professionals

According to learners, this course offers a highly practical and clear guide to mastering Excel Pivot Tables. Students consistently praise the instructor's clear explanations and the course's hands-on exercises, which are deemed instrumental for learning. Many find the content immediately applicable, enabling them to enhance their professional data analysis skills and address real-world business questions. Specific features like using slicers, creating multiple pivot tables and dashboards, and pivot charts are frequently highlighted as beneficial. While generally considered excellent for building strong foundational to intermediate skills, some learners noted the 'Deep Dive' title might suggest a more advanced scope than what is delivered, particularly for seasoned users seeking highly complex scenarios.
Highlights useful Excel Pivot Table features and advanced concepts.
"The 'Drill-To' feature and the section on connecting one slicer to multiple pivot tables incredibly useful."
"Loved the section on Pivot Charts and integrating multiple pivot tables."
"I liked the 'Black Belt Training' section, especially the part on adding multiple fields."
Exercises and downloadable files significantly reinforce learning.
"I really appreciate the hands-on exercises that reinforced learning."
"The exercise files were super helpful."
"The downloadable exercise files were a huge plus."
Exceptional clarity and easy-to-follow explanations.
"The instructor explains complex concepts... with such clarity."
"The content is delivered very clearly, and the pace is just right."
"The step-by-step approach and clear explanations made it easy to follow."
Highly valuable for immediate real-world use in professional settings.
"Incredibly useful for my work. My data analysis skills have vastly improved."
"It truly helped me see how to apply pivot tables to actual business questions."
"I've already applied what I've learned to my current projects."
Suggestions for more diverse data or updated content.
"I wish there were more diverse datasets for practice."
"It might be slightly outdated for the very latest Excel features..."
"Some parts felt a bit rushed."
Mixed views on depth; excellent for fundamentals, less for 'deep dive'.
"I didn't feel it was a 'deep dive' as advertised. It barely scratched the surface of advanced analysis techniques."
"I felt some of the 'Advanced Analysis Techniques' could have gone deeper."
"Some sections felt a little basic given the 'Deep Dive' title."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Excel Deep Dive: Pivot Tables Workshop with these activities:
Review Prerequisite Resource
Review key concepts in Pivot Tables and related topics to strengthen your foundation and prepare for the course.
Browse courses on Pivot Tables
Show steps
  • Revisit the basics of Pivot Tables and their uses.
  • Review common Excel functions used in Pivot Tables, such as SUM, COUNT, and AVERAGE.
  • Recall techniques for organizing and filtering data in Pivot Tables.
Brush Up on Excel Basics
Ensure proficiency in fundamental Excel skills to support your learning in Pivot Tables.
Browse courses on Excel Functions
Show steps
  • Revisit basic Excel operations, such as creating and formatting spreadsheets.
  • Review common Excel functions and formulas.
  • Practice navigating and manipulating data within Excel.
Participate in Peer Discussions
Engage with fellow learners by sharing tips, insights, and questions related to Pivot Tables, fostering a collaborative learning environment.
Show steps
  • Join an online forum or study group focused on Pivot Tables.
  • Ask questions, share your experiences, and provide support to other learners.
  • Attend virtual or in-person meetups to connect with other Pivot Table enthusiasts.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice Creating Pivot Tables
Gain hands-on experience by creating Pivot Tables from scratch using sample datasets.
Show steps
  • Set up a sample dataset in Excel.
  • Create a Pivot Table based on the dataset, choosing appropriate fields for rows, columns, and values.
  • Practice modifying Pivot Table elements, such as adding filters or changing value fields.
Explore Advanced Pivot Table Techniques
Delve deeper into Pivot Tables by following guided tutorials on advanced techniques, such as creating multiple Pivot Tables and using slicers.
Show steps
  • Identify advanced Pivot Table features covered in the course.
  • Seek out tutorials on these advanced techniques.
  • Work through the tutorials, implementing the techniques in your own practice Pivot Tables.
Contribute to Open Source Pivot Table Projects
Gain practical experience and contribute to the Pivot Table community by participating in open-source projects related to Pivot Tables.
Show steps
  • Identify open-source libraries or projects related to Pivot Tables.
  • Review the project documentation and codebase.
  • Contribute bug fixes, feature requests, or documentation improvements.
Create a Pivot Table Dashboard
Demonstrate your mastery by creating a comprehensive Pivot Table dashboard that summarizes and visualizes key insights from a dataset.
Show steps
  • Prepare a dataset with multiple data dimensions.
  • Create multiple Pivot Tables based on the dataset.
  • Combine the Pivot Tables into a single dashboard, using slicers to filter and interact with the data.

Career center

Learners who complete Excel Deep Dive: Pivot Tables Workshop will develop knowledge and skills that may be useful to these careers:

Reading list

We've selected 49 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Excel Deep Dive: Pivot Tables Workshop.
Seminal work on the grammar of graphics, a formal language for describing data visualizations. It covers a wide range of topics, from the basics of the grammar of graphics to the use of the grammar of graphics to create a variety of charts and graphs.
This classic book by Edward Tufte must-read for anyone interested in data visualization. It covers a wide range of topics, from the principles of visual perception to the design of effective charts and graphs.
The third edition of the essential guide to data wrangling with pandas, NumPy, and Jupyter in Python. Updated for newer versions of the libraries, this book remains a core resource for anyone performing data analysis in Python. It widely used textbook and reference for its clear explanations and practical examples.
More than just a basic Excel guide, this book focuses on applying Excel to real-world data analysis and business problems. It's ideal for those looking to deepen their understanding of using Excel for practical applications, including newer features like dynamic arrays and Power Query. is commonly used as a textbook and strong reference for business professionals.
A recent edition of a popular series, this book covers pivot tables with an emphasis on new features like Dynamic Arrays, Power Query, and Copilot. It provides updated techniques for data crunching and reporting, making it highly relevant for users of the latest Excel versions. valuable resource for staying current with contemporary pivot table capabilities.
This practical guide is specifically tailored for those interested in financial modeling using Excel. It provides step-by-step instructions and focuses on applying Excel features to solve common business and financial problems. It's a valuable resource for students and professionals in finance and business roles looking to solidify their modeling skills.
Focuses specifically on Power Query, a powerful tool within Excel and Power BI for connecting, transforming, and combining data from various sources. It's highly relevant for contemporary data analysis workflows and is essential for users who need to clean and prepare data efficiently before analysis. This book adds significant depth to data manipulation skills within Excel.
Combines financial analysis and modeling concepts with the application of Excel and VBA. It's a valuable resource for those in finance who want to leverage Excel's power for complex analysis and automation. It deepens understanding by integrating financial theory with practical Excel implementation.
Offers a detailed look at Power Query, focusing on practical techniques for data collection, combination, and transformation. It's an essential resource for anyone dealing with messy data and provides valuable skills for efficient data preparation in Excel and Power BI. This book significantly deepens understanding of data wrangling.
Is highly recommended for those who want to master financial modeling in Excel. It simplifies complex financial concepts and provides in-depth techniques for building, developing, and deploying financial models. It's a valuable resource for finance professionals and students seeking to deepen their financial modeling expertise.
Provides a foundational understanding of the fundamental principles of data science and the data-analytic thinking necessary for extracting value from data in a business context. It is highly relevant for undergraduate business analytics programs and working professionals. It serves as a useful reference for understanding the business applications of data analysis and is commonly used as a textbook.
Provides a comprehensive overview of data visualization, covering the basics of visual perception, data types, and chart types. It great resource for beginners who want to learn the fundamentals of data visualization.
Comprehensive guide covering a vast range of Excel topics from beginner to advanced levels. It's an excellent resource for gaining a broad understanding of Excel's capabilities and serves as a valuable reference tool for various functions, formulas, and features. While published in 2018, its foundational content remains highly relevant for solidifying core Excel skills.
Considered a classic in financial modeling, this book focuses entirely on using Excel to implement financial models. It's a thorough resource for those seeking a deep understanding of financial modeling principles and their practical application in Excel, drawing on real-world company data.
This comprehensive 'Bible' covers all aspects of Excel 365, with dedicated sections on pivot tables and related features like Power Query and Power Pivot. It's an excellent all-in-one reference for users of the subscription version of Excel, providing in-depth coverage of both basic and advanced functionalities.
Focuses on modern data analysis techniques within Excel, including Power Query and Power Pivot. It's a contemporary resource for users looking to update their data cleaning and reporting processes and perform more rigorous data analysis directly within Excel. It's highly relevant for professionals working with data regularly.
Offers a visual and comprehensive guide specifically focused on pivot tables. It aims to cover all aspects of this feature, making it a deep dive for those who want to master pivot table creation and manipulation. Its visual approach makes it accessible for learners of varying levels.
Focuses on the crucial skill of communicating insights from data effectively through compelling visualizations. is highly relevant for all levels, emphasizing the importance of clear and impactful data presentation. It is valuable additional reading that complements technical data analysis skills.
This handbook provides a solid foundation in financial modeling concepts and their implementation, often using Excel as a tool. It's a good resource for those who want to understand the theory behind financial models while also learning how to build them practically. It's suitable for both students and professionals.
Bridges the gap between statistical theory and its practical application in data science using R and Python. It focuses on the statistical concepts most relevant to data scientists and provides code examples. It's a useful reference and learning resource for those applying statistics in their work.
Is for users who want to leverage the power of Power BI and Power Pivot for more advanced data analysis and business intelligence. It delves into data modeling and DAX formulas, which are essential for creating sophisticated reports and dashboards using pivot tables and related technologies. It is geared towards users with a solid foundation in Excel and pivot tables.
An updated guide to VBA and macros in the latest Excel versions, this book strong resource for automating tasks and extending Excel's functionality. It's suitable for users who want to move beyond basic formula and function usage and into more powerful automation.
Offers a new way of thinking about data science and ethics informed by intersectional feminist thought. It challenges existing power structures within data and explores how data can be used to work towards justice. It's highly relevant for contemporary discussions around fairness and bias in data analysis.
Another visual guide by Paul McFedries, this book focuses on data analysis techniques in Excel, with a strong emphasis on using pivot tables and charts. It is designed for Excel power users who want to enhance their analytical skills through clear, visual explanations. good reference for practical application of pivot tables in data analysis.
Provides a guide to creating effective and aesthetically pleasing data visualizations. It delves into the principles behind good visualization design, helping readers make informed choices about how to represent their data. It valuable reference for anyone creating visualizations, from students to professionals.
While not solely an Excel book, 'Data Smart' must-read for anyone in data analysis. It provides a comprehensive guide to using data analysis techniques and tools, including how Excel can be used in real-world scenarios. It helps contextualize Excel within the broader field of data science and is valuable for both beginners and experienced professionals.
Is an excellent starting point for anyone new to data analysis or statistics. It demystifies core statistical concepts without relying heavily on mathematical formulas, making it highly accessible for high school and undergraduate students. It provides a strong foundation in the intuition behind statistical analysis and helps readers understand how data can be used and misused. This is valuable background reading that builds prerequisite knowledge.
Focuses on using pivot tables to create dashboards, which common application in business. It guides users through the process of transforming raw data into interactive reports and visualizations using pivot tables. This book is particularly relevant for professionals who need to create summary reports and dashboards.
A concise and practical guide for absolute beginners, this book introduces the basic interface, creating worksheets, using simple formulas, and basic data manipulation. It's an excellent starting point for those with no prior Excel experience and helps build foundational knowledge.
Teaches probability and statistics using a computational approach with Python. It's ideal for students and professionals with programming experience who want to understand statistical concepts by doing. It helps solidify understanding through hands-on application.
A guide aimed at quickly improving Excel skills from beginner to advanced, covering recent features and practical data analysis techniques. is useful for those seeking an up-to-date resource with a focus on practical application and a faster learning curve.
Introduces users to Power Pivot and Power Query, which extend the capabilities of pivot tables for handling larger datasets and performing more complex data modeling. It's written in the accessible 'For Dummies' style, making it suitable for users who are new to these advanced Excel features but have a basic understanding of pivot tables.
Beginner's guide to using Tableau, one of the most popular data visualization tools. It covers the basics of Tableau, as well as how to use Tableau to create a variety of charts and graphs.
A timeless classic that remains highly relevant today. exposes common ways statistics can be manipulated or misinterpreted, fostering a critical eye essential for anyone working with data. It's valuable for all levels, from high school to professional, as it highlights the importance of data integrity and ethical considerations. This serves as crucial additional reading to develop data literacy.
Aims to take users from novice to proficient in Excel pivot tables. It covers the basics, data cleaning, and enhancing pivot table presentations with charts, slicers, and conditional formatting. It also touches on handling multiple data sets, making it a good resource for building a solid understanding.
SQL fundamental skill for data analysis, and this book delves into advanced techniques for working with data in databases. It's essential for anyone who needs to retrieve and manipulate data stored in relational databases. It serves as a valuable reference for more complex data extraction and transformation tasks.
A beginner-friendly introduction to Excel VBA programming, this book is suitable for those new to automation in Excel. It provides clear explanations and examples to help users understand the fundamentals of creating macros and custom functions. It's a good starting point before moving to more advanced VBA resources.
Explores the world of prediction and forecasting across various fields, demonstrating how data analysis and statistical modeling are used in practice. It's particularly engaging for undergraduate and graduate students interested in the application of data analysis in real-world scenarios. It adds breadth by showcasing diverse applications and the challenges involved in making accurate predictions.
Provides a high-level overview of the data science process, from asking questions to interpreting results. It focuses on the principles and concepts rather than specific tools, making it suitable for a broad audience. It helps in gaining a broad understanding of the data analysis workflow.
This 'All-in-One' guide covers a wide range of Excel topics, including an introduction to pivot tables. It's an excellent starting point for beginners who need a broad understanding of Excel's capabilities, with step-by-step instructions that are easy to follow. It provides foundational knowledge necessary before diving deeper into pivot tables.
Combines the power of SQL for data extraction and manipulation with Excel for analysis, including the use of pivot tables. It is relevant for users who need to work with data stored in databases and analyze it using Excel. This book is suitable for those with some technical background or professionals working with data from multiple sources.
While more focused on the engineering aspects of data systems, this book provides a deep understanding of the underlying infrastructure for data analysis. It's particularly valuable for graduate students and professionals involved in building and maintaining data pipelines and databases. It adds significant depth to understanding the data landscape.
This guide is specifically aimed at beginners who are new to pivot tables. It provides a step-by-step introduction to creating and using pivot tables for basic data analysis and modeling. good starting point for high school students or those in introductory undergraduate courses.
This guide is designed for absolute beginners to pivot tables in Excel. It provides step-by-step instructions with screenshots to help users understand and utilize pivot tables from the ground up. It suitable starting point for anyone with no prior experience with pivot tables.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Excel Deep Dive: Pivot Tables Workshop.
Excel Data Analysis and DAX Essentials Course
Most relevant
Excel Basics for Data Analysis
Most relevant
Excel Skills for Business: Intermediate I
Most relevant
Excel Essentials and Beyond
Most relevant
Excel for Business Analysts Online Course
Most relevant
Data Visualization in Excel: Build an Interactive...
Most relevant
Excel Fundamentals for Data Analysis
Most relevant
Excel Dashboard for Beginners: AI & Pivot Tables Mastery
Most relevant
Mastering Advanced Pivot Tables in Excel
Most relevant

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser