Back
Short Courses
Regular Courses
Private Courses
About Us
Account
Login
|
Register
|
Cart
6 Sections
22 Lessons
24 Hours
Expand all sections
Collapse all sections
PERSIAPAN
2
1.1
Pre-Test
10 Minutes
10 Questions
1.2
Download Bundle Materi
1. STRUCTURED RANGE OF DATA
5
2.1
1.1 Introduction
2.2
1.2 Name A Range of Cells
2.3
1.3 Excel Table
2.4
1.4 Advanced Functions
2.5
1.5 Ensuring Data’s Integrity
2. DATA ANALYSIS
4
3.1
2.1 Quick Analysis Tools
3.2
2.2 What-If Analysis
3.3
2.3 Forecasting & Trandline
3.4
2.4 Conditional Formating
3. DATA VISUALIZATION
5
4.1
3.1 Database Concepts
4.2
3.2 Introduction to the PivotTable
4.3
3.3 Customizing PivotTable
4.4
3.4 Creating Dashboard with PivotChart and Slicers
4.5
3.5. Adding Location Intelligence with Power Map
4. DATA PREPARATION
6
5.1
4.1 Understanding the Internal Data Model
5.2
4.2 Introduction to a Power Pivot
5.3
4.3 Loading External Data into Power Pivot
5.4
4.4 Automating Tasks with Macros
5.5
4.5 Transform Data with Power Query
5.6
4.6 Improving Calculation Performance
PENUTUPAN
2
6.1
Post-Test
10 Minutes
10 Questions
6.2
Kuesioner
This content is protected, please
login
and
enroll
in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content