CONTENT
1. Structured Range of Data
1.1. Introduction
1.2. Range name
1.3. Excel Table and Advanced Sorting
1.4. Filtering Data
1.5 Advanced Functions
1.6 Ensuring Data’s Integrity
1.7 Data Combination
2. Data Analysis
2.1 quick analysis tools
2.2 Whatif Analysis
2.3 Forecasting & Trandline
2.4 Conditional Formating
3. Data Visualization
3.1 Database Concepts
3.2 Introducing the PivotTable
3.3 Customizing PivotTable
3.4 PivotChart and Slicers
4. Data Preparation
4.1 Understanding the Internal Data Model
4.2 Introduction to a Power Pivot
4.3 Automating Tasks with Macros
4.4 Transform Data with Power Query
4.5 Improving Calculation Performance
- 1. PERSIAPAN
- 2. PEMBELAJARAN
- 3. PENUTUPAN
