Easy Excel PivotTable Skills - PivotTable Power Tips
5.0 (3 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.
9 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Easy Excel PivotTable Skills - PivotTable Power Tips to your Wishlist.

Add to Wishlist

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
5.0 (3 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.
9 students enrolled
Created by Billy Wigley
Last updated 6/2017
English
Current price: $10 Original price: $35 Discount: 71% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 38 mins on-demand video
  • 1 Article
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
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
3 Lectures 14:11
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

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
About the Instructor
Billy Wigley
4.5 Average rating
242 Reviews
3,238 Students
4 Courses
Microsoft Certified Trainer (MCT), MOS Excel Expert

As a Microsoft Certified Trainer, Billy Wigley is a Microsoft Office Expert in Excel. He actively travels throughout the USA, and other countries leading public seminars teaching Excel skills. In just five years, he has personally trained more than 45,000 professionals in over 100 cities. Wigley also consults with emergent business owners on their plans and projects to ensure success. With over 25 years of leadership experience, and from having resided in various cities worldwide, Wigley is well-known around the world. With his strong USA and Colombian heritage, Wigley takes pride in his multi-cultural background, and being able to reach English, and Spanish speakers around the globe.

Billy Wigley always says: "Don't Get Mad…Get Skills!"