Microsoft Excel course: Learn Pivot Tables in 30 minutes

Microsoft Excel: Learn Pivot Tables in 30 minutes

In this course, you will learn all that is required to make use of Pivot Tables and Pivot Charts in Excel in just 30 minutes! The knowledge you gained in this course will give you a competitive advantage in the jobs marketplace and skyrocket your personal development.

What You Will Learn in the Excel Pivot Table Course?

• How to create and manipulate Excel Pivot Table in just a few minutes!
• How to apply value filters to get different data insights that will take your analytical skills to the next level!
• How to create interactive Excel Dashboards using Slicers and PivotCharts that will blow the mind of your supervisors!
• How to find different trends in data that can help you in decision-making!
• Different Pivot Table tips and tricks that you can use to become faster and more efficient at your work! 

Why You Should Take the Excel Pivot Table Course?

I have been teaching for more than 20 years and I have helped a few thousand students to gain useful knowledge and find good jobs. 

Mastering PivotTables will give you a competitive advantage in the jobs marketplace by gaining career-building skills.

Who Excel Pivot Table Course is For?

This course is not an introduction to Excel and it is not for absolute beginners. This course is right for you if you already have some experience with Excel, but you would like to master the most powerful tool – Excel Pivot Tables. 

What's Inside?

1. Pivot Tables Course Outline and Structure

2. What are Pivot Tables?

3. How to Create Pivot Tables?

4. More about Creating Pivot Tables

5. How to Group Data in Pivot Tables?

6. How to Format Data in Pivot Tables?

7. Calculations in Pivot Table

8. How to Find Data Trends Using Pivot Tables?

9. How to Create Pivot Charts?

10. How to Filter Data?

11. What is Analyze Tab Used for?

12. How to Style and Design a Pivot Table?

PivotTable Exercise.xlsx