Microsoft Excel
Course Curriculum
Introduction to Excel
- 04:31
-
Komponen Utama Excel
09:30 -
Membuat, Menyimpan, dan Membuka File
03:56
Data Entry & Formatting Basics
Introduction to Formulas & Functions
Rows, Columns, and Worksheets
Sorting and Filtering
Introduction to Conditional Formatting
Basic Charts & Visualizations
Tables
Data Validation & Dropdown Lists
Basic Printing and Page Setup
Intermediate Formulas & Functions
Lookup Functions (Part 1)
Lookup Functions (Part 2)
Pivot Tables (Part 1)
Pivot Tables (Part 2)
Advanced Charting
Time and Date Functions
Data Cleaning
Advanced Conditional Formatting
Macro and VBA
Advanced Functions (Part 1)
Advanced Functions (Part 2)
Power Query Basics
Power Pivot
Data Analysis with Power Pivot
Error Handling and Troubleshooting
Collaboration and Protection
Project: Dynamic Dashboards
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet
Student Ratings & Reviews
No Review Yet
