Excel Pivot Tables | A Quick Start Guide

Learn Excel Pivot Tables in a easy to understand course...
Free tutorial
Rating: 4.6 out of 5 (344 ratings)
3,485 students
1hr 57min of on-demand video
English [Auto]

This course is designed as a launching pad for students who want to grasp the fundamentals of Excel Pivot Tables.
Learn how to use many of the features Pivot Tables have to offer.
How to analyze large lists of data quickly and easily with Pivot Tables.


  • No, not really. Some familiarity with excel helps, but overall not required. :)


Pivot Tables are an extremely powerful tool in Excel and a skill that employers crave!  If you are brand new to Pivot Tables than this course is for you. And by chance you've been working with them for awhile you may benefit as well.  :)

This course starts by giving you the fundamentals of pivot tables and presents the topics in short, fun, easy to follow videos. From there we move into working with calculations/ formulas, the ever cool slicer, charting and conclude the class with some fun miscellaneous topics.

Please note: this course has been designed to provide as much information about Excel Pivot tables as the time constraints allow.  Granted many topics can be explained much more in-depth, yet that is not how this course was designed.  Rather the goal was to be as comprehensive, and to cover as much ground as possible.  :)

By the way did you know that only 5% of excel users know how to make Pivot Tables?*  So you are about to join an exclusive club! :)

Who will benefit from this course?

If you use large lists of data and are interested in learning the story behind the data then Pivot Tables are the way to go! Excel Pivot Tables provide quick, accurate and intuitive insight into your data and can provide answers to the even the most complicated of analytics tasks.

Do you need previous experience with Excel to take this course?

Not really.  Even though Pivot Tables are often promoted as an intermediate/ advanced topic in Excel, the key is to recognize everything in the Excel curriculum is topical, not progressive- so the order in which you learn things is up to you. Therefore if you have experience great, if not as long as you...

  1. Can select cells on a spreadsheet

  2. Have a basic understanding of formulas in Excel

  3. Able to navigate between sheets

  4. Somewhat familiar with sorts and filters (if not, that's okay since we give a brief explanation)

All things considered... you'll be just fine.  :)

Technical Requirements

  • This course was created using Excel 2019. Yet can be used with Excel 2016/ 2019 or Office 365 (primarily for PC/Windows)

  • Mac users are welcome, but be aware your screen will be somewhat different

Course Progression

  • Overview of source data and basic Pivot Table fundamentals

  • Learning simple then advanced formulas used within Pivot Tables

  • What are slicers and how to use them, including how to connect slicers to multiple Pivot Tables (yep... you read that right.)
    Pivot charts

  • Concluding with some miscellaneous topics including filter reports and the GETPIVOTDATA function


Let’s face it being able to read and analyze data in today’s word is a highly sought after skills and being competent with Pivot Tables will help move you to the front of the proverbial line.

So if you're looking for a Pivot Table fundamental class, wanting to broaden your existing skills in Excel, or have a need to develop your analytical skills- this class has something for you because knowing Pivot Tables can give you the extra advantage in developing your career.

* Source:  Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016; Collie, Singh 2016

Who this course is for:

  • Any one who is new to Pivot Tables
  • This course is intended for anyone who wants to learn a very in-demand skill.
  • Experienced Excel users who want to be more competent in data/ list analysis
  • Anyone looking to begin a career in business intelligence/ data science


Training Alchemist
Dave Mc
  • 4.6 Instructor Rating
  • 1,425 Reviews
  • 17,118 Students
  • 4 Courses

            Dave has been engaged in computer training over the past 20+ years and is the founder and CEO of Skootzi [dot] com.  During this time he has been fortunate to work with many great people, and been able to impact them through his unique, laid-back, fun, yet quirky, learning style. He has trained extensively domestically and internationally, along with personally training over 100,00 people. 

            He does not believe in overly polished, eloquent presentations. Rather he focuses on a more conversational approach to learning. Subsequently, he does NOT consider himself an expert by any stretch. Why? Simply because that term reeks of arrogance and is not his modus operendi. Instead, he views himself as a perpetual apprentice in the computer field and believes there is always something new to be learned, no matter how long you've been doing "it". 

            True to form, he would like to thank the people that have mentored him throughout the years. 

Top companies trust Udemy

Get your team access to Udemy's top 19,000+ courses