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!
Introduction and road rules for the course. Please be sure to download the materials!!
DATA - HOME BASE - Learn the basics of a data table - the source of a PivotTable!
DATA - EXERCISE - Your first exercise!
DATA - SOLUTION
NAVIGATING THE PIVOTTABLE - Take a guided tour of the nuts and bolts of a PivotTable.
FIELD LIST PANEL - Take a closer look at the field list panel, or the control panel of a PivotTable.
VALUES - EXERCISE - Exercise #2!
VALUES - SOLUTION
LABEL FIELD SETTINGS - We will now review label field settings in the control panel.
FORMATTING THE PIVOTTABLE - Learn how to make our PivotTables more presentable.
SORTING THE PIVOTTABLE - Manipulate the PivotTable to show sorted data.
THE KITCHEN SINK - EXERCISE - Let's see what you have learned with this comprehensive exercise!
THE KITCHEN SINK - SOLUTION PART I
THE KITCHEN SINK - SOLUTION PART II
THE KITCHEN SINK - SOLUTION PART III
CONCLUSION - Conclusion and summarize what was learned.
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!