Master Excel Pivot Tables and save the world.
Master Excel Pivot Tables and save the world.
This course discusses one of the most powerful tools of the Office Ninja's arsenal, Excel Pivot Tables and how to use pivot tables. It's potential for analyzing and summarizing data is legnendary, but few have mastered its intricacies. Through a series of easy to follow lessons on how to use pivot table in excel, you will be introduced to the concepts, techniques and powerful features of this mysterious excel tool, and can follow along with each step with the included sample file.
We will cover:
● Pivot Table Concepts
● Creating A Pivot Table
● Modifying Pivot Table Elements
● Filtering Extraneous Data (the Slicer tool)
● Creating Multiple Pivot Tables
● Creating Pivot Charts
● Advanced Analysis Techniques
Learn how to use pivot table in excel today.
This First lecture sets the stage for understanding Pivot Tables by first explaining how to create automatic Subtotals. In this lecture you will learn how to:
This Lecture explains the fundamental concepts behind what a Pivot Table is and why it is useful. At the end of this lecture you will understand what a pivot table is doing and how it acts as a "Super Subtotal
In this lesson you will create your first pivot table. Learn how to:
Take this quiz and see if you've been paying attention :)
Now that you have created a Pivot Table, we want to learn how to control how values are displayed in that table. In this lesson, you will learn how to:
In this lesson, we uncover a nifty feature of Pivot Tables, the Drill To feature which allows you to easily display the original records that made up a specific value in the pivot table.
This lesson explores how to format your Pivot Table so it looks the way you want, and so you can share it with other people in a professional format. You will learn how to:
In this lesson, we raise the stakes and begin to explore the true power of Pivot Tables by adding more than one field to the row and column areas. This will allow you to get even more specific on the type of trends you are able to extract from your data. You will learn how to:
When dealing with large data sets, it's often important to be able to filter ou the extraneous data that is cluttering the answers you're looking for. In this lesson, you learn how to do that from within the Pivot Table, and with a new filtering tool to Office 2010, the Slicer.
This lesson explores how to create a dashboard, or rollup of lots of different aspects of your dataset onto one sheet with multiple Pivot Tables. This is especially useful when the data is changing regularly or you want to look at different trends in your data at the same time.
By graphically representing data, you can more easily identify trends or key performance indicators in your data, and make it easier to explain your findings to others. In this lesson, we see how to create a Pivot Chart that reflects the Pivot Table, and how to manipulate that chart
In this final lesson, we explore more real world examples of how Pivot Tables can answer important business questions using the tools we've discussed.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.