Mentor From Industry Professionals

• Senior Analyst, Business at Lazada
• Ecommerce Specialist at Eka Jaya Internasional
• Key Account Manager at Lazada
• Digital Marketing at Fastwork.

Curriculum

Boost Your Career with MS Office Skills

• The Power of MS Office in Career Development
• Bridging the Gap and Overcoming Fear in Learning MS Office
• How Mastering MS Office Can Skyrocket Your Career and Salary
• MS Office Trends and Evolution in the Workplace
• How Word, PowerPoint, and Excel Can Elevate Your Professional Skills
• Automasi & AI di Microsoft Office
• Q&A and sharing session with mentor

Excel Functions To Simplify Your Work

• Data Validation, Conditional Formatting & Remove Duplicate
• Workbook Navigation, Range, and Cell Management
• Basic Excel Functions SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
• Understanding Basic Math Operations in Excel
• ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR
• CEILING & FLOOR for Rounding to Specific Multiples
• Working with Cell References: A1, $A$1, A$1

Logical Calculations, Random Data, & Absolute References

• Using POWER for Exponential Calculations
• Modulo Operation & Cyclical Calculations with MOD
• Rounding and Absolute Values with INT & ABS
• Generating Random Data with RANDOM & RANDBETWEEN
• Understanding Cell References: Absolute, Relative, and Mixed

Logical & Conditional Functions

• Logical Functions: IF, AND, OR, NOT, XOR
• SWITCH Function: A Faster Alternative to Nested IF
• Conditional Data Analysis with SUMIF, COUNTIFS, AVERAGEIFS
• Subtotal and Aggregate Functions
• Error Handling and Data Validation with IFERROR, ISERROR, ISBLANK

Troubleshooting and Optimizing Excel Formulas

• Error types and troubleshooting (#VALUE!, #REF!, #DIV/0!, etc.
• Debugging Formula
• Tips for Avoiding Errors in Excel
• Performance optimization (Performance Analyzer)

Clean and Analyze Data Like an Expert

• Data Cleaning Techniques
• Text Replacement Techniques SUBSTITUTE, REPLACE
• Text Extraction Techniques
• Data Organization Techniques LEFT, RIGHT, MID
• Data Concatenation Techniques
• TEXTJOIN, CONCATENATE (Menggabungkan teks)
• Data Modelling

Data Standardization & Validation for Analysis

• Logical and Conditional Function for Text Standardization
• Standardizing Number and Date Formats for Analysis
• Organizing Input with Dropdown Lists
• Handling Duplicate Data with Conditional Formatting
• Data Validation with Excel Functions