Mastering Excel: Pivot Tables for Professionals

Get confident with pivot tables and make sense of complex datasets with this quick and easy course. You'll be summarizing and slicing data like a pro in less than a week!

Featuring Chris Hadley, Ph.D. , wikiHow's Excel Expert

5
Format
Each lesson is delivered to your inbox with (1) an easy-to-follow instructional video (2) a summary of key tips and takeaways and (3) a quick assignment to help you apply what you just learned.
Duration
Take the whole course in just 5 days.
Time
Each lesson takes 10-15 minutes to read, watch, and try.

What you will learn

  • The fundamentals—how to create a basic pivot table in Excel
  • How to work with real, comprehensive datasets to build pivot tables
  • How to create a responsive dashboard
  • Ways to quickly give managers a closer look at your data when they have questions
  • Tricks to format your pivot tables for the best presentation of your data

Why should you take this course?

  1. To feel more confident working with datasets. If you've ever been intimidated by having to analyze a dataset at work, this course is perfect for you. Unlock a whole new world of understanding data.
  2. To angle for that promotion. Pivot tables are one of the most practical (and beautiful) skills to show off to your manager. Add that you learned it in your free time, and, well, talk about dedication!
  3. To list Excel on your resume and be able to back that claim up. When you learn pivot tables, you can confidently call yourself an Excel expert. After our course, you'll have the practical experience to showcase your Excel skills at the drop of a hat.


Course Overview

5 Lessons

Pivot Table Basics
Using the Slicer
Calculated Fields
Analyze Data in Detail
Making a Pivot Table Look Good


Meet the Expert

Chris Hadley, PhD
PhD in Cognitive Psychology, University of California, Los Angeles
Chris Hadley earned his PhD in Cognitive Psychology from UCLA in 2006. Chris' research has been published in numerous scientific journals. During his time at UCLA, he was awarded a Kirschstein-NRSA Fellowship from the National Institutes of Health to fund his doctoral research. Chris has worked on improving content quality at wikiHow since 2007. His role on the content team focuses on quality control and content innovation. He works with our editors to ensure accuracy on all wikiHow articles, as well as advising on content strategy.
Show more


Frequently Asked Questions

How is this course different than reading wikiHow articles about Excel?
How will I receive this course?
How much experience do I need for this course?
What is wikiHow's refund policy?


What are others saying?

Sandra

The best part was the real world data sets! It was very cool to practice on the kind of thing they actually have us analyzing at work. The videos were so easy to follow as well. I really couldn't imagine a better way to learn Pivot tables.

Sienna

I hadn't used Excel in a long time... probably years. I have an Excel test coming up in an interview, and this course made me feel completely ready. I can't believe I remember this stuff! Well taught.

A.T.

What helped me most with my questions were the sequential steps and explanations on what to do and how to do it. Some sites provide too much information at one time without providing examples on how to get it done.

Disclaimer: The wikiHow service is provided without warranties of any kind, including that the content is accurate, reliable, correct or will meet your requirements. Use of any information provided is at your own risk. See our full Terms of Use for more information.