Pivot Tables for Beginners - Lunch and Learn

Learn Excel PivotTable during your lunch hour!
0.0 (0 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.
0 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 16
  • Length 1 hour
  • Skill Level Beginner Level
  • 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 6/2016 English

Course 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!

What are the requirements?

  • Excel 2010 or later will be needed.

What am I going to get from this course?

  • Create PivotTables and have a basic understanding on how to manipulate them.

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

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: Introduction and Data Tables
03:47

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

06:53

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

00:48

DATA - EXERCISE - Your first exercise!

04:36

DATA - SOLUTION

Section 2: Components of a PivotTable
05:33

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

06:10

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

01:08

VALUES - EXERCISE - Exercise #2!

04:38

VALUES - SOLUTION

Section 3: Customizing a PivotTable
03:32

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

05:12

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

04:44

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

Section 4: Final Exam!
03:26

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

04:44

THE KITCHEN SINK - SOLUTION PART I

04:16

THE KITCHEN SINK - SOLUTION PART II

03:01

THE KITCHEN SINK - SOLUTION PART III

01:57

CONCLUSION - Conclusion and summarize what was learned.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Fred Rook, 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!

Ready to start learning?
Take This Course