Introduction to Pivot Tables

Learn Pivot Table Must-Knows in Just 2.5 Hours!

Get Hands-On Practice with Workbooks, Quizzes and Challenges

Learn to create and customize Pivot Tables in Excel. Refresh your data without issues.
Analyze your data quickly and confidently - all with zero stress.

Get started now!



Are you ready to get comfortable with Pivot Tables?

This course is ideal for Pivot Table beginners. It will boost your confidence in using Pivot Tables in Excel.

In just 2.5 hours, you'll be able to create, format, and refresh Pivot Tables without the usual frustrations.

What You’ll Learn:

  • Create Pivot Tables from scratch and customize them to fit your needs.
  • Format numbers and headers to make your reports look polished.
  • Use filters and slicers to drill down.
  • Refresh data to work with the latest info.
  • Troubleshoot common issues, like missing data and slicers showing deleted items.

Your Instructor


Leila Gharani
Leila Gharani

My courses & tutorials are for ambitious beginners and professionals who want to upgrade their data analysis skills. If you hate doing things manually, you’ll love my approach.

I don’t just want to show you solutions to specific problems, but to teach you to find solutions to ALL your future data analysis problems.

On my YouTube channel, I share Office Productivity tips & tricks based on questions I get from our online community & professionals at my training sessions.

I am a Certified Microsoft Excel Expert and was given the Microsoft MVP award in 2017. I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature - these include SAP BW and Oracle HFM.

My background is: Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. My passion is teaching and solving difficult Excel problems. I am also addicted to learning and enjoy taking online courses on a variety of topics.

I founded my online learning company, XelPlus, in 2015. Our aim is to help you gain the knowledge you need so you can create useful tools, solve problems and get more done.

Let's start now.


Hands-On Learning:

This course lets you practice every step. You’ll get:

  • Practice workbooks to follow along and apply what you’re learning.
  • Challenges to help you test and solidify your skills.
  • Quizzes to make sure you’re on track.
  • Key takeaways at the end of each section to summarize what you’ve learned.

By the end of the course, you'll know the must-knows of Pivot Tables.

You'll also be able to refresh your data and update your reports - without the usual headaches.

Here’s a Peek at the Lectures You’ll Cover:

  • How to Create a Pivot Table in Excel
  • Filters, Columns & Hierarchies in Pivot Tables
  • How to Drill Down a Pivot Table to Show Detailed Data
  • Pivot Table Layout to Separate Fields into Columns
  • Add Slicers to Pivot Tables
  • Stop Pivot Table Columns From Resizing
  • And much more! (see the full curriculum below👇)

Course Curriculum


  🎯 Pivot Table Success Essentials
Available in days
days after you enroll
  🗃️ Pivot Table Basics & Must-Knows
Available in days
days after you enroll
  🔃 Refresh Data Without Issues
Available in days
days after you enroll
  🥳 Wrap-Up & Your Next Steps to Master Pivot Tables
Available in days
days after you enroll

 

Who Is This Course For?

  • Beginners who want to build a strong foundation with Pivot Tables.
  • Excel users who need to learn how to refresh data correctly and troubleshoot common issues.
  • Anyone looking to save time and boost their productivity in Excel.

What’s Next?

If you want to learn advanced features, check out our full Pivot Table Essentials course. Besides this intro course, the Pivot Table Essentials course covers dashboards, complex formulas, pivot charts, and more.

Frequently Asked Questions


When does the course start and finish?
It’s up to you! This course is self-paced, meaning you can start anytime and go at your own speed. Begin when you’re ready and finish on your schedule.
How long do I have access to the course?
You get access for the lifetime of the course, which means you can retake it for as long as it’s in existence – for FREE.
What if I am unhappy with the course?
We aim for your complete satisfaction. If you find the course isn’t right for you, just email us at [email protected] within the first 14 days of your purchase for a full refund.