Course Overview
Pivot table:
Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features.
In this training you will learn
- Basics o Pivot
- Preparation of Raw Data
- Feature and Formulas in Pivot Table
- Representation of Data in Pivot
- Generating Multiple sheets in one Go using “Report Filter Pages”
- Formatting of Multiple sheets in one Go
Target Customers:
- Students
- Working Professionals
- Data Analysts
- Business Analysts
- Anyone who wants to learn Pivot Tables
Pre-Requisites:
- Basic computer knowledge
- Familiarity with the Microsoft Office work environment