Excel 2010 - Pivot Table

Course details

Excel Pivot table is a powerful method to analyze huge amount of data with huge number of variables. Learn to summarize the data in an intelligent way by creating the Pivot tables. In this course, you will learn in detail how Pivot Tables work and the structure that must be followed to create useful reports and charts. This course is vital to gaining the most from this powerful feature of Excel. This course assumes that you have some basic concepts of Excel. This course is structured in a way to only focus on the most important elements of creating and working with Pivot tables. Pivot Table is a very useful and powerful methods for Financial Analysts, Investment Bankers, Marketing Professionals, Team Leaders, students and professionals working with vast amount of data with different variables. In this course, we will be covering the following modules:

 Basics of Pivot Table

 Summarizing Data Using Pivot Table

 Data Filtering

 Basics Pivot Table Formatting

 Advanced Pivot Table Formatting

 Introduction of Pivot Chart

 How to Print the Pivot Table

 Using Macros In Pivot Tables

 Introduction of Power Pivot

 DAX in Power Pivot

 Introduction of Power View