Mastering Pivot Tables To Analyze Business Data in Excel
What you'll learn
- Master Pivot Tables for analyzing data and converting it into actionable information
- Find simple ways to look the the same data in different ways & gather insights
Requirements
- Basic Knowledgo Excel. Familiar with Excel Version 2007, 2010, 2013, Excel 2016 or Office 365
Description
This course is designed for people familiar with Excel and who want to learn how to analyze data within Excel. We will use the in-built Pivot Table tool, and show how to use the tool, and how to go beyond the basics, to more advanced functionality to analyze data, performing complex calculations, and be able to turn data into actionable information easily.
It is meant for the data warriors to learn the Advanced Excel techniques of Pivot Tables to make sense of huge amount of data in Excel, and be able to create simple management reports which compare data as Percentages, perform year or year, quarter on quarter comparisons etc.
Who this course is for:
- Beginners to Pivot Tables
- People who know pivot tables, but want to take their knowledge further and use advanced features of Pivot Tables
Course content
- Preview04:48
Instructor
Vinai Prakash is the founder of ExcelChamp.Net, and an avid Microsoft Excel user with over 30 years of experience in data ware housing, business intelligence, data analysis.
He loves to share his Excel knowledge to people all around the world in Excel workshops, in Excel dashboard trainings in Singapore, Middle East, etc.
Vinai is a sought after trainer for Project Management & IT training. He lives in Singapore with his wife, and 2 lovely boys.