Excel Pivot Tables: The Power of Pivot Tables... Made Easy
4.8 (69 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,282 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.8 (69 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,282 students enrolled
Last updated 1/2017
English
Current price: $10 Original price: $105 Discount: 90% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 5 Articles
  • 19 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
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.
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!

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
Expand All 54 Lectures Collapse All 54 Lectures 03:31:03
+
Latest Quick Tip
1 Lecture 00:24

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

Preview 00:24
+
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
03:47

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

Exercise: Creating Two PivotTables
04:00

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

Learn how to filter the entire Excel PivotTable with Report Filters

Report Filters: Filtering the Entire PivotTable
04:33

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

Slicers: The User-Friendly Way to Filter Your PivotTable
06:46

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

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
03:17
+
Grouping & Formatting Data in Your PivotTables
9 Lectures 33:04

Quickly group the data in your Excel PivotTables

Grouping Records - Quick & Easy
04:59

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

Grouping by Date with Just a Few Clicks
02:26

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
02:24

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

Using Conditional Formatting to Highlight Important Information
12:32

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
07:55

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

Changing Your PivotTable's Layout
02:48

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

An introduction to creating Calculated Fields in Excel PivotTables

Creating Custom Calculated Fields
02:55

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
07:46

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
03:39
+
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
05:24

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
06:10
+
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
01:13

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

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

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

Automatic v. Manual Data Updating
03:34

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!
00:53

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:44

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
00:12

How fast can you create the PivotTable in this exercise?

Test Your Skills: Running Totals
00:13

How fast can you create the PivotTable in this exercise?

Test Your Skills: Custom Sort Lists
00:18

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:52
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

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

[BONUS LECTURE] Get Going on Your 2017 Goals
00:00
About the Instructor
IsáBel Harrison
4.6 Average rating
728 Reviews
14,226 Students
16 Courses
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.