Excel Pivot Tables: Pivot Tables Made Easy

Excel Pivot Tables: Organize data in Excel. View it in a way that helps you make informed decisions. Use Pivot Tables!
4.6 (41 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,125 students enrolled
$105
Take This Course
  • Lectures 54
  • Contents Video: 2.5 hours
    Other: 1 hour
  • 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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.

GAIN MICROSOFT EXCEL PIVOTTABLE SKILLS.

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

What 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.

Curriculum

Section 1: Latest Quick Tip
Article

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

Section 2: Excel 2013 PivotTables
02:43

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
09:48

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

03:47

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

04:00

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
10:18

Learn how to filter the data in your Excel PivotTable

04:33

Learn how to filter the entire Excel PivotTable with Report Filters

06:46

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

06:09

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

03:17

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
04:59

Quickly group the data in your Excel PivotTables

02:26

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.

02:24

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

12:32

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?

07:55

Quickly apply new Style formatting to your Excel PivotTables

02:48

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
01:38

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

02:55

An introduction to creating Calculated Fields in Excel PivotTables

07:46

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

03:39

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

Section 7: Creating PivotCharts
05:24

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

06:10

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
01:13

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

02:28

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.

04:29

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.

04:31

Frequency Distribution Tables are super easy to create with Excel PivotTables

03:34

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

00:53

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

Article

How fast can you create the PivotTable in this exercise?

Article

How fast can you create the PivotTable in this exercise?

Article

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 2013 Tips: Spotlight on Excel Time Savers
Customizing the Ribbon
09:31
Named Ranges for Navigation
04:53
Track, Accept, and Reject Changes Made to Your Workbooks
04:07
Creating Forms Using the Form Command
03:34
Absolute Reference: Why You Absolutely Need to Know It
04:11
Creating Drop-Down Lists
02:36
Bonus Lecture: $15 Deals Are Back!!- UPDATED
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, Online & In-Person Technical Trainer :: 12 Udemy Courses ::

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 in 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