Bundling Microsoft Excel (Beginner 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)
FREE WORKSHOP ONLINE DATA VISUALIZATION & STORYTELLING WITH GOOGLE LOOKER STUDIO
1. EDA Thinking for Business (EDA, data insight decision, business question, pola data)
2. Mapping Insight to Visualization (prinsip visualisasi, jenis chart, visual efektif)
3. Dashboard Building with Looker Studio (import data, KPI, chart, filter, calculated field)
4. Dashboard Design & Best Practices (hierarchy, konsistensi, layout, common mistakes)
5. Data Storytelling (insight, storytelling framework, penyampaian data)
