Excel Pivot Tables: The Power of Pivot Tables... Made Easy

Regular Tables Are Great But When You Really Need to Analyze, Drill-Down, and Quickly Calculate, PivotTables Are the Way
4.7 (55 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,233 students enrolled
86% off
Take This Course
  • Lectures 54
  • Length 3.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

  • Downloadable Excel Workbooks
  • Free eBook

You use Excel for a reason, and I'm sure it's not to spend hours analyzing data.

You could sit for hours, pouring over hundreds, or thousands of rows.
Filtering, sorting, and calculating like there's no tomorrow.
And when you need to alter the data, you can do it all again.

Or you could take a different approach.

You can spend seconds, and create PivotTables.

Some people spend so much time creating formulas, copying and pasting numbers and records, when they can use PivotTables.

Those that do use PivotTables can make better business decisions, analyze faster, and have more control over their data, and confidence in their skills.

In this course you'll learn:

  • How to create PivotTables
  • How to filter, and create custom sorting lists
  • How to format values, and create calculated fields
  • How to create Slicers and Timelines for ultra fast filtering
  • How to change the layout and style
  • How to create PivotCharts
  • and more

Learn to create PivotTables in hours, not days. Then use that knowledge to create user-friendly, interactive reports in minutes, not hours!

Whether you are a small business owner looking to better understand sales trends, an assistant creating weekly reports, or you're looking for a way to better track household expenses, if you are using Excel, you need PivotTables!

Most exercises can also be applied to Excel 2007, Excel 2010, and Excel 2016 as well.


Click The Take This Course Button On The Right & I'll See You In Class!

What are the requirements?

  • This course is designed for creating and managing PivotTables in Excel 2013, however, if you use Excel 2010, or even 2007 most exercises will also apply to you. Spreadsheets for the exercises are provided in the Resources section for each lecture.

What am I going to get from this course?

  • QUICKLY CREATE PivotTables
  • FILTER Data Fast
  • CREATE Custom Sort Lists
  • FORMAT Your PivotTable
  • CREATE Calculated FIelds
  • CREATE Slicers & Timelines
  • CHANGE the Layout & Style of Your PivotTables
  • CREATE PivotCharts
  • ... and more

Who is the target audience?

  • This course is intended for Excel users who are not yet familiar with PivotTables, but have a real desire to learn them. No prior PivotTable experience is needed, however experience with tables in Excel is recommended.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Latest Quick Tip

Get the latest Quick Tip from Excel 2013 PivotTables: How to Quickly Analyze Your Data

Section 2: Excel 2013 PivotTables

Welcome to this Excel 2013 PivotTable course on Udemy.com

1 page

Make the most out of this course. Follow these steps for a successful course experience, and as always, feel free to message me or post a discussion.

Section 3: Creating PivotTables

Learn about what is needed to have a good data source before creating your Excel PivotTable, and how to navigate and use the PivotTable environment


Learn how to arrange, or pivot, your fields in your Excel PivotTables


Use the workbook attached in the Resource section of this lecture to create two Excel PivotTables

3 pages

Need to create a PivotTable, but the data source is Microsoft Access?
No problem.

1 page

The might be an instance when you create a PivotTable with the wrong data, or you receive new data that you need the PivotTable to be based on.

If that is the case, you can easily change the data source of your PivotTable.

1 page

When you need to move your PivotTable, here's how...

1 page

Two ways to delete PivotTables

Section 4: Filtering & Sorting PivotTables

Learn how to filter the data in your Excel PivotTable


Learn how to filter the entire Excel PivotTable with Report Filters


Slicers are the User-Friendly Way to Filter Your Excel PivotTables using graphical objects


Timelines are a new feature in Microsoft Excel, and are a great way to filter your PivotTables by dates


When sort ascending or descending just won't do, learn how to create your own custom sort list in Microsoft Excel

Section 5: Grouping & Formatting Data in Your PivotTables

Quickly group the data in your Excel PivotTables


Group your Excel PivotTable by date fields with just a few clicks of the mouse

1 page

If you are enjoying this Microsoft Excel PivotTable course, please leave a positive comment, and a rating, which you can do at the top right hand corner of the Course Dashboard.

It takes less than a minute and it is a huge help to other students, and to me too.


Make sure that you are properly formatting the value fields in your Excel PivotTable


Use Conditional Formatting in Excel PivotTables to to dynamically, and automatically, adjust how the data looks

1 page

When you create multiple conditional formats, which one takes precedence?


Quickly apply new Style formatting to your Excel PivotTables


When you are not satisfied with the layout of your Excel PivotTable, learn how to change it

2 pages

Learn how to move your Values from Columns to Rows.

Section 6: Calculating Values in PivotTables

Learn about the different options available with the Summarize Data By tool


An introduction to creating Calculated Fields in Excel PivotTables


Learn how to take the values in your Excel PivotTables and display them as Percentages of the values, the difference between values, and rank them among values

2 pages

Learn how to create Running Totals in your PivotTables

1 page

Calculating Options for Value Fields


Learn how to filter your Excel PivotTable to display the top item or percent of the values

Section 7: Creating PivotCharts

PivotTables and PivotCharts go hand-in-hand. Get an introduction to creating PivotCharts in Microsoft Excel


Bring all of your knowledge together to create a dashboard that easily displays and filters information in your PivotTable and your PivotChart

Section 8: PivotTable Tips & Tricks

Find out how easy it is to drill down on the data in your Excel PivotTable


Quickly create a separate PivotTable for each item in the Report Filter. Each new PivotTable will be on its own sheet, and maintain all formatting from the original.


Learn the trick to clearing deleted items from your Excel PivotTables

1 page

Change the way Errors are displayed in your PivotTables with this quick tip.


Frequency Distribution Tables are super easy to create with Excel PivotTables


Automatically or Manually update the data in your Excel PivotTable? What is the difference, and why should you care?


Thanks for being a part of this course. I hope that it has helped to further your understanding of Microsoft Excel PivotTables. if you have any questions, please let me know.

1 page

What can you do, now that the course is complete, to help you with Microsoft Excel 2013 PivotTables & PivotCharts?

Here are your next steps.

Section 9: More PivotTable Exercises & Resources
2 pages

Create a PivotTable that displays the products sold by each country

2 pages

Create a PivotTable that display the total sales amounts, for each salesperson, by quarter


How fast can you create the PivotTable in this exercise?


How fast can you create the PivotTable in this exercise?


How fast can you create the PivotTable in this exercise?

1 page

Save even more time, become even faster with keyboard shortcuts for Microsoft Excel 2013 PivotTables.

31 pages

This Bonus step by step eBook covers the lectures in this Microsoft Excel 2013 PivotTable Udemy.com course.

Section 10: SNEAK PEAK: Excel Tips: Spotlight on Excel Time Savers
Customizing the Ribbon
Named Ranges for Navigation
Track, Accept, and Reject Changes Made to Your Workbooks
Creating Forms Using the Form Command
Absolute Reference: Why You Absolutely Need to Know It
Creating Drop-Down Lists

Get Going on Your 2017 Goals by Enrolling in My Courses for $10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, Computer Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.

Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.

Ready to start learning?
Take This Course