Pivot Table Data Crunching
Pivot tables are the single most powerful feature in all of Excel. With a pivot table, you can take 1 million rows of transactional data and transform it into a summary report in seconds. If you can drag a mouse, you can create a pivot table. In addition to quickly summarizing and calculating data, pivot tables allow you to change your analysis on the fly by simply moving fields from one area of a report to another. There is simply no other tool in Excel that gives you the flexibility and analytical power that pivot tables can give you.
Course Fees: Rs.1000/-
Duration: 8 Hours
Course Outline…
Ø Pivot Table Fundamentals
Ø Creating a Basic Pivot Table
Ø Customizing a Pivot Table
Ø Controlling the Way You View Your Pivot Data
Ø Performing Calculations Within Your Pivot Tables
Ø Using Pivot Charts and Other Visualizations
Ø Analyzing Disparate Data Sources with Pivot Tables
Ø Common Pivot Table Issues and Questions
