1. Bundling E-Course Microsoft Excel Beginner to Advance
2. Bundling E-Course Google Spreadsheet Basic to Advance
3. Workshop Online Google Spreadsheet Special AI
4. Live Mentoring & QnA Session bersama Mentor Professional
5. 20++ Video Pembelajaran Microsoft Excel Beginner to Advance
6. 20++ Video Pembelajaran Google Spreadsheet Basic to Advance
7. 10++ Ebook
8. 10++ Real Case & Materi
9. Sertifikat Setiap Level
10. PreTest dan PostTest Setiap Level
11. Akses 6 Bulan
12. VIP Grup Telegram Lifetime
What You'll Learn:
Bundling E-Course Microsoft Excel (Level Basic, Intermediate, Advance)
1. Data Preparation & Structuring (text to columns, absolute cell)
2. Essential Excel Functions (SUMIF, COUNTIF, DATE)
3. Logical Functions & Error Handling (IF, IFERROR)
4. Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
5. Data Validation & Input Control (data validation)
6. Data Analysis with Pivot Table (create & modify pivot table)
7. Advanced Data Processing (AGGREGATE)
8. Data Visualization (charts, graphs, conditional formatting)
9. Professional Excel Practices (hyperlink, protect sheet)
Bundling E-Course Google Spreadsheet
1. Basic Spreadsheet Functions (SUM, AVERAGE, MIN, MAX, CONCATENATE)
2. Logical Functions & Data Counting (IF, IFS, AND, OR, COUNT, COUNTA, COUNTBLANK)
3. Error Handling & Data Cleaning (IFERROR, ISBLANK, ISERROR, ISERR)
4. Lookup & Reference Functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH)
5. Advanced Formula Combination (VLOOKUP, MID, RIGHT, VALUE)
6. Data Automation with Formula Logic (IF + VLOOKUP + VALUE untuk auto calculation)
7. Data Transformation & Simulation (generate angka 099 dengan formula kombinasi)
8. Financial Calculation Automation (auto saldo calculation dengan formula kombinasi)
9. Data Visualization (charts & graphs di Google Sheets)
Workshop Online Google Spreadsheet Special AI Materi:
1. Data Cleaning
2. Smart Fill & AI Formula
3. Dashboard Report with AI
Tanggal Pelaksanaan:
Hari / Tanggal: Selasa, 30 Juni 2026
Waktu: 19.0021.00 WIB
Venue: Zoom
