Deskripsi
Mentor:
Muhammad Rifky - Senior Analyst, Business at Lazada, Ecommerce Specialist at Eka Jaya Internasional
Mochammad Tri Antoro - Key Account Manager at Lazada, Digital Marketing at Fastwork
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