Start analyzing data with Excel’s most powerful data analysis tool, Pivot Tables. They’re easier than you think!
What’s this course about
Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they’ll change the way you use Excel.
If you’re not familiar with Pivot Tables, they’re a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.
This is an introductory Pivot Table course and gives the information you’ll need to start using Pivot Tables.
Who will benefit from this course
If you’re somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.
You don’t have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.
This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.
What you’ll learn in this course
- How to structure your data to take advantage of Pivot Tables
- How to create a Pivot Table
- How to summarize information in different ways using Pivot Tables
By the end of this course, you’ll be able to take your own information and leverage Pivot Tables to answer questions you never thought possible!