CONTENT
1. Data Analysis
1.1. Quick Analysis Tools
1.2. Whatif Analysis
1.3. Forecasting & Trandline
1.4. Conditional Formating
2. Data Visualization
2.1 Database Concepts
2.2. Introducing the PivotTable
2.3. Customizing PivotTable
2.4. PivotChart and Slicers
2.5. Adding Location Intelligence with Power Map
2.6. Presenting Dashboard with PowerPoint
3. Data Preparation
3.1. Understanding the Internal Data Model
3.2. Introduction to a Power Pivot
3.3. Loading External Data into Power Pivot
3.4. Automating Tasks with Macros
3.5. Transform Data with Power Query
3.6. Improving Calculation Performance
