Microsoft Excel
Course Curriculum
Introduction to Excel
-
04:31
-
Komponen Utama Excel
09:29 -
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
Biar Skill Nggak Cuma Diomongin
Punya skill? Buktiin lewat sertifikat ini. Bisa kamu pajang di LinkedIn, portfolio, atau impress calon client.
Student Ratings & Reviews
Lengkap bgt materinya
Mudah dipahami, materi cukup lengkap