Excel Pivot Tables: The Power of Pivot Tables... Made Easy
4.6 (79 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,347 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Pivot Tables: The Power of Pivot Tables... Made Easy to your Wishlist.

Add to Wishlist

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.6 (79 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,347 students enrolled
Created by IsáBel Harrison
Last updated 7/2017
Current price: $10 Original price: $105 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • 5 Articles
  • 19 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
  • 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.
  • 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!

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
54 Lectures
Latest Quick Tip
1 Lecture 00:25

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

Preview 00:25
Excel 2013 PivotTables
2 Lectures 02:43

Welcome to this Excel 2013 PivotTable course on Udemy.com

Preview 02:43

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.

Steps for a Successful PivotTables Course
1 page
Creating PivotTables
7 Lectures 17:35

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

Preview 09:48

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

Creating PivotTable 2: Focus on Source, PivotTable Fields, and Arranging Fields

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

Exercise: Creating Two PivotTables

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

Creating a PivotTable from a Microsoft Access Database- NEW!
3 pages

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.

Changing Your PivotTable’s Data Source
1 page

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

Moving a PivotTable
1 page

Two ways to delete PivotTables

Two Ways to Delete Your PivotTables
1 page
Filtering & Sorting PivotTables
5 Lectures 31:03

Learn how to filter the data in your Excel PivotTable

Applying Filters to PivotTable Fields

Learn how to filter the entire Excel PivotTable with Report Filters

Report Filters: Filtering the Entire PivotTable

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

Slicers: The User-Friendly Way to Filter Your PivotTable

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

Timelines: Dashboard Filters for Your Date Field

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

Creating a Custom Sort List
Grouping & Formatting Data in Your PivotTables
9 Lectures 33:04

Quickly group the data in your Excel PivotTables

Grouping Records - Quick & Easy

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

Grouping by Date with Just a Few Clicks

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.

How Are You Enjoying the Course?
1 page

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

Formatting All of the Field Values

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

Using Conditional Formatting to Highlight Important Information

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

Understanding Conditional Formatting Rule Precedence- NEW!
1 page

Quickly apply new Style formatting to your Excel PivotTables

Applying Formatting Styles to PivotTables

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

Changing Your PivotTable's Layout

Learn how to move your Values from Columns to Rows.

Displaying Multiple Field Values in Rows
2 pages
Calculating Values in PivotTables
6 Lectures 15:58

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

Summarize Data By…

An introduction to creating Calculated Fields in Excel PivotTables

Creating Custom Calculated Fields

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

Displaying Values as Percentages, Difference, and Rank

Learn how to create Running Totals in your PivotTables

Creating Running Totals in PivotTables
2 pages

Calculating Options for Value Fields

Calculating Options for Value Fields Explained
1 page

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

Finding the Top or Bottom Values in Your PivotTable
Creating PivotCharts
2 Lectures 11:34

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

Introduction to PivotCharts

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

Creating a Dashboard with PivotCharts, Slicers, and Timelines
PivotTable Tips & Tricks
8 Lectures 17:08

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

The Super Easy Steps to Drilling Down on Your 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.

Preview 02:28

Learn the trick to clearing deleted items from your Excel PivotTables

Clearing Deleted Items from a PivotTable

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

What to do with Error in Your PivotTables?
1 page

Frequency Distribution Tables are super easy to create with Excel PivotTables

Creating a Frequency Distribution Table

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

Automatic v. Manual Data Updating

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.

Thank You!

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

Here are your next steps.

Next Steps for Success
1 page
More PivotTable Exercises & Resources
7 Lectures 00:45

Create a PivotTable that displays the products sold by each country

Exercise: Products by Country
2 pages

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

Exercise: Sales by Salesperson Quarter
2 pages

How fast can you create the PivotTable in this exercise?

Test Your Skills: Grouping by Month

How fast can you create the PivotTable in this exercise?

Test Your Skills: Running Totals

How fast can you create the PivotTable in this exercise?

Test Your Skills: Custom Sort Lists

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

Keyboard Shortcuts
1 page

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

eBook: 2013 PivotTables
31 pages
SNEAK PEAK: Excel Tips: Spotlight on Excel Time Savers
7 Lectures 28:54
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

[BONUS LECTURE] Get Going on Your 2017 Goals **COUPON CODE**
About the Instructor
IsáBel Harrison
4.5 Average rating
1,056 Reviews
15,721 Students
16 Courses
Results & Convenience | 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, then ▶Subscribe to My YouTube Channel, because Change Matters, Growth Matters.