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
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?
- 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.
- 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!
- 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
Create your first pivot table using real data on land use from the City of San Francisco.
Using the Slicer
Use the slicer function to create an interactive dashboard where you can choose one criteria and instantly update all of your pivot tables.
Calculated Fields
Add custom calculations to pivot tables using affordable housing data.
Analyze Data in Detail
Learn how to quickly zoom in on data in a pivot table based on what you or your boss want to focus on.
Making a Pivot Table Look Good
Put the finishing touches on your pivot tables, so you can guide your viewers through an easy-to-understand presentation.
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?
wikiHow has many helpful articles about Excel, but it can get overwhelming to comb through them all randomly. We selected 5 essential skills for this particular course, starting from the basics and progressing to more sophisticated skills, so you could level up your competency in just 1 week. Each lesson comes with practice exercises that you won't find on wikiHow articles.
How will I receive this course?
Once you've started a course, you'll get a welcome email confirming that you're enrolled. You'll then receive an email lesson each day for the next 5 days. These emails will go to the email address tied to your wikiHow account. To make sure you don't miss them, add learn@courses.wikihow.com to your contact list.
How much experience do I need for this course?
This course is best if you have a bit of experience with Excel already. If you're a beginner, we recommend starting with 5 Must-Have Excel Skills Every Professional Should Know to learn the basics!
What is wikiHow's refund policy?
We want our learners to be satisfied with the wikiHow Pro membership experience. That's why, if you try our courses or other features of wikiHow Pro and aren't satisfied, you can cancel your membership at any time. Contact support@wikihow.pro for help managing your membership.
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.
