Our Mentor

• Muhammad Rifky - Senior Analyst, Business at Lazada, Ecommerce Specialist at Eka Jaya Internasional
• Fajar Juliansyah - HRBP for Operations at Danone, Human Resources at Kompas
• Mochammad Tri Antoro - Key Account Manager at Lazada, Digital Marketing at Fastwork
  

Curriculum

Lookup & Data Reference Functions

• VLOOKUP, HLOOKUP
• XLOOKUP
• INDEX MATCH
• Common Errors in VLookup and HLookup
• Best Practices and Tips for Efficient Data Search

Advanced Lookup: Multi-Criteria & Dynamic Searches

• MATCH Multiple Criteria
• Flexible Searches with CHOOSE
• Dynamic Data with FILTER & UNIQUE
• Flexible Range Searching with OFFSET
• Adaptive Lookups with INDIRECT

Descriptive Statistics & Correlation Analysis in Excel

• MEDIAN, MODE
• STDEV.P, STDEV.S, VAR.P, VAR.S
• QUARTILE, PERCENTILE: Understanding Data Distribution
• CORREL, COVARIANCE: Evaluating Relationships
• Linear Regression with LINEST & Analysis ToolPak
• Trends & Future Insights: Mastering Predictions with Excel

Distribusi Probabilitas & Pengujian Hipotesis

• Binomial & Poisson Distributions
• Skewness & Kurtosis: Understanding Distribution Shape
• Z-Score & Normal Distribution Analysis
• ANOVA with Analysis ToolPak
• T-Test & Chi-Square: Key Hypothesis Tests

Master Financial Formulas for Smarter Decisions

• Unlocking Business Insights with Dynamic Reporting
• Investment Mastery: NPV, IRR, PMT & Future Value Insights
• Financial Forecasting: Predicting Future Business Trends
• Budgeting & Variance Analysis: Tracking Financial Performance
• What-If Analysis: Scenario Planning for Better Decision Making

Mastering Excel For Sales

• Leveraging the Power of GROWTH Function
• Ranking Products & Maximizing Sales Efficiency
• Data FILTER Techniques
• Maximizing ROI with Accurate Investment & Marketing Analysis
• Optimizing Sales Reports with Excel's LET Function