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

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel Advanced: InHouse Training – Bappenas”

Your email address will not be published.