Back

Microsoft Excel Advanced: InHouse Training – Bappenas

 

Mulai:23 Oct’23
Selesai:24 Oct’23
Hari:Senin – Selasa
Pukul:08.00 – 16.00 WIB
Durasi:16 Hours
Biaya:Rp 7.900.000,-
Tempat:Brainmatics
Min. Peserta:6 Peserta
Confirm:24 Peserta
Terdaftar:– Peserta

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