Microsoft Excel Pivot Tables - The Complete Course

Pivot Tables are the most powerful tool in Excel to analyze large sets of information. If you've never used Pivot Tables before, don't worry. This course takes you from the very beginning of Pivot Tables and slowly builds on your skills and knowledge by breaking up new skills into short but comprehensive videos.

By the end of the course, you'll be confident using Pivot Tables on the data that you use every day.

Who will benefit from this course?

If you use large sets of information within Excel, then you'll definitely benefit from learning Pivot Tables. You might get this data from other departments in your company or maintain it on your own, but if you ever need to analyse that information or understand it more thoroughly, Pivot Table will be essential.

What skills do you need?

Pivot Tables are an intermediate topic in Excel so before you take this course you should be comfortable with the following tasks in Excel. 

1. Copying and pasting information

2. Creating formulas in Excel

3. Navigating between sheets and using the Ribbon

Why this course?

This course stands out in a few key areas. Firstly, we actually show you how to ensure your data is in the right format to start using Pivot Tables. This is one of the most critical elements of Pivot Tables, but it's something that most courses leave out. Without the correct structure, you'll struggle to effectively analyse your data.

Additionally, this course uses the same sample data throughout the majority of the course. So instead of showing you a new skill on data that you're not familiar with, we build your skills on data that you've used throughout the course. This way you can focus on learning new skills without being bogged down with trying to understand the new data set.

The course does have practice activities that use different data sets to test your skills and expose you to some other data. In those videos, we spend time ensuring you understand the data set and pose specific questions for you to answer. We then walk through the practice answers together to ensure you get the most out of them.

Conclusion

Pivot Tables have the power to change the way you use Excel and give you skills that will set you apart from your colleagues. With Excel being a critical tool in almost every business, these skills will go a long way to boosting your career.