Pivot Tables for Beginners - Lunch and Learn
5.0 (1 rating)
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.
5 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Pivot Tables for Beginners - Lunch and Learn to your Wishlist.

Add to Wishlist

Pivot Tables for Beginners - Lunch and Learn

Learn Excel PivotTable during your lunch hour!
5.0 (1 rating)
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.
5 students enrolled
Created by Fred Rook
Last updated 6/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create PivotTables and have a basic understanding on how to manipulate them.
View Curriculum
Requirements
  • Excel 2010 or later will be needed.
Description

Learn PivotTables during 1 lunch hour!  

Pivot tables are a great way to analyze large volumes of data very quickly.  Pivot tables are extremely flexible and customizable, which makes them such a great tool to have in your toolbox. I can tell you that I use them almost every day in my day job and the feedback I get is, "How did you that?", "That's so cool!", and "Damn, I really have to learn pivot tables one day!"  Well for you, that day is today!

This class is purposely staged to take you about an hour to go through.  At the end of the course, my objective for you is to make sure you have a basic understanding of how to operate a pivot table and how to practically apply it to situations.  

Also, this class is interactive.  You will have an file in excel to download, and you will be working on it, as we go through the course together.  This is the best way to learn - learn by doing!!

I hope you enjoy this course, and I am confident you will have a basic understanding of pivot tables as you are taking your last bite of dessert!

Who is the target audience?
  • Students with a basic knowledge of Excel, but with little or no experience with using PivotTables. This course would not be suitable for people using Excel for the first time.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
01:04:25
+
Introduction and Data Tables
4 Lectures 16:04

Introduction and road rules for the course.  Please be sure to download the materials!!

Preview 03:47

DATA - HOME BASE - Learn the basics of a data table - the source of a PivotTable!

Preview 06:53

DATA - EXERCISE - Your first exercise!

Chapter 3 - Data - Exercise
00:48

DATA - SOLUTION

Chapter 4 - Data - Solution
04:36
+
Components of a PivotTable
4 Lectures 17:29

NAVIGATING THE PIVOTTABLE - Take a guided tour of the nuts and bolts of a PivotTable.

Chapter 5 - Navigating the Pivot Table
05:33

FIELD LIST PANEL - Take a closer look at the field list panel, or the control panel of a PivotTable.

Chapter 6 - Field List Panel
06:10

VALUES - EXERCISE - Exercise #2!

Chapter 7 - Exercise - Values
01:08

VALUES - SOLUTION

Chapter 8 - Solution - Values
04:38
+
Customizing a PivotTable
3 Lectures 13:28

LABEL FIELD SETTINGS - We will now review label field settings in the control panel.

Chapter 9 - Label Field Settings
03:32

FORMATTING THE PIVOTTABLE - Learn how to make our PivotTables more presentable.

Chapter 10 - Formatting the PivotTable
05:12

SORTING THE PIVOTTABLE - Manipulate the PivotTable to show sorted data.

Chapter 11 - Sorting the PivotTable
04:44
+
Final Exam!
5 Lectures 17:24

THE KITCHEN SINK - EXERCISE - Let's see what you have learned with this comprehensive exercise!

Chapter 12 - The Kitchen Sink - Exercise
03:26

THE KITCHEN SINK - SOLUTION PART I

Chapter 13A - The Kitchen Sink - Solution Part 1
04:44

THE KITCHEN SINK - SOLUTION PART II

Chapter 13B - The Kitchen Sink - Solution Part 2
04:16

THE KITCHEN SINK - SOLUTION PART III

Chapter 13C - The Kitchen Sink - Solution Part 3
03:01

CONCLUSION - Conclusion and summarize what was learned.

Chapter 14 - Conclusion
01:57
About the Instructor
Fred Rook
5.0 Average rating
1 Review
5 Students
1 Course
Excel and Microsoft Product Trainer and CPA

I am a Certified Public Accountant by trade, and one of my specialized skill-sets is my knowledge of Excel and other Microsoft Office products.  I quickly became the “go to” person in my office as well as my client base with a variety of “how do I do that” questions.  Soon, I established “lunch and learn” sessions at my company, which were embraced with overwhelming support and demand.  People responded to the interactive nature of the classes, and the fact that they walked away with so much during one lunch hour. 

Give me your lunch hour, and I will give you the tools to succeed!