Easy Excel PivotTable Skills - PivotTable Power Tips
4.7 (11 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
36 students enrolled

Easy Excel PivotTable Skills - PivotTable Power Tips

How to create Excel PivotTables that can quickly be used to summarize large amounts of data and learn some Power Tips
4.7 (11 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
36 students enrolled
Created by Billy Wigley
Last updated 10/2017
English
English [Auto-generated]
Current price: $11.99 Original price: $34.99 Discount: 66% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 41 mins on-demand video
  • 1 article
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Build better PivotTables faster.
  • Know the secret "PivotTable Wizard."

  • Build a simple, quick and easy dashboard.

  • Know how to consolidate multiple worksheets into one PivotTable report.
  • Ask the instructor questions, and synergize with other students in the Q&A section.
Requirements
  • Have an Intermediate level of Excel proficiency or have been using Excel on a daily basis for at least 1 year.
  • Be familiar with Excel 2010 and beyond.
  • Have a 2010 or later version of Microsoft Excel.
Description

No fluff here, just skills!

Unlike other courses, we will not get into the history of PivotTables, instead we just start learning right away. 

Have you been using Excel regularly for over 1 year? Jump right in - you are ready to take your data analysis/reporting to the next level!

  • Would you like to create an interactive report that can quickly be used to summarize large amounts of data? Then look no further than a Pivot Table.
  • Are you swarmed by the mountains of data you have?
  • Do you want to see trends and patterns at a glance?
  • Your bosses want answers (QUICK!) from your collection of data and each of them want something different out of those numbers.  

If you have ever been in any of these situations, then PivotTable reports are just the thing for you.

We just get right into it here.

Ready. Set. Go!

Don't Get Mad...Get Skills!

Who this course is for:
  • Want to become a PivotTable Power User? Then this course is for you!
  • Anyone that has been working with Excel for at least 1 year, and wants to learn PivotTables.
Course content
Expand all 10 lectures 41:26
+ Introduction
2 lectures 09:45

Feel free to watch the Lecture 1: Introduction before taking this quiz. However, I recommend you go for it now, and watch the lecture after you complete this quiz. Test your knowledge, you can always re-take it.  

Confirm Your PivotTable Knowledge.
2 questions

This quiz will help you solidify some important basic PivotTable skills.

PivotTable Basics
6 questions
+ Data Management and Display
4 lectures 17:48
Slicers For Your Data
06:24
Data Consolidation - Meet the PivotTable Wizard!
03:40

In this lecture you will learn how to use the Value Field Settings to view PivotTable data from one value field in two separate ways. One column will display the Total Sales in a currency format, and another column will display the same data as a Percentage of the sales Grand Total.

By learning how to use your Value Field settings you will be able to use custom calculations to better analyze your data.

There are many custom calculations available within your Value Field Settings dialogue box, so be sure to download the additional resource detailing them.

Keep on learning!

Value Field Settings - View The Same Field Differently
04:07

Have you ever had a pivot table report set up just right? You have the columns set up to a specific width, certain rows highlighted, you have the Accounting number format in place, and you've got your column headers centered.

Now you refresh your PivotTable so that you can update your data - suddenly the columns have Auto-Fitted, and all of the formattings are gone!

The centered  Column Headings, the number format, and the highlighted rows are gone!

In this lesson, you will learn how to preserve the formatting when your Pivot Table report is updated. 

Let's Keep On Learning!

Refresh And Keep Format - Update Your Report Data And Preserve Your Formats
03:37

Ensure that you have learned about advanced PivotTable Data Management tools.

Data Management
6 questions
+ Advanced Calculations
4 lectures 13:54
Creating Calculated Fields
11:15
PivotTable Formulas
5 questions
Next Steps For Taking Your PivotTable Skills To The Next Level
01:13
The BONUS Section - Links To Resources So You Can Get More Skills!
00:09