Mentor From Industry Professionals 

• Senior Analyst, Business at Lazada
• Ecommerce Specialist at Eka Jaya Internasional
• HRBP for Operations at Danone
• Human Resources at Kompas
• 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

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

Mastering PivotTables and PivotCharts for Better Insights

• Introduction and Create PivotTable
• Advanced Data Aggregation SUM, COUNT, AVERAGE, MAX, MIN
• Creating a PivotChart for Fast Visual Analysis

Advanced PivotTable Techniques & Report Automation

• Data Grouping: Organizing PivotTable by Date, Category & Number Range
• Calculations: Mastering Calculated Fields & Items in PivotTable
• Show Values As (Growth %, Rank & % of Total)
• Interactive Data Navigation: Slicer & Timeline in PivotTable
• Business Reporting: Automating Data Updates in PivotTable

Create Eye-Catching Charts and Graphs

• Chart Designs: Mastering Bar, Line, Pie, Waterfall, Scatter, Bullet Charts
• Formatting Techniques: Heatmaps & Performance Indicators
• Highlighting Key Insights: Using Data Bars, Color Scales & Icon Sets
• Charts: Using Named Ranges & OFFSET for Auto Updates
• Trendlines & Forecasting: Predicting Future Data Trends

Build Dashboards That Impress and Deliver

• Designing an Effective Dashboard Layout for Business Reports
• Enhancing Interactivity with Form Controls: Dropdown & Scroll Bars
• Visualizing Multi-Metric Comparisons with Combo Charts
• Managing Dynamic Data Without PivotTables: INDIRECT, INDEX & MATCH
• Building Scorecards & Progress Indicators Using Excel Formulas
• Automating Data Updates with Dynamic Named Ranges & Formula Arrays

Building Interactive HR Dashboards for Quick Insights

• Introduction and Designing an Effective Employee Database
• Employee Data Lookup: Mastering VLOOKUP, HLOOKUP, and XLOOKUP
• Analyzing Employee Data with PivotTables
• Highlighting Critical Data with Conditional Formatting
• Analyzing Employee Turnover: Calculating Turnover Rate
• Building Interactive HR Dashboards

Macro Basics & Simple Automation

• Excel Workflows: Mastering VBA for Efficiency
• Developer Tab in Excel
• Recording and Running Macros
•  Into the VBA Editor: The Heart of Excel Automation
• Writing VBA Code: Simple, Efficient, and Powerful

Automate Your Work with Macros

• Sprint Review
• Variables & Data Types: Laying the Foundation for VBA Programming
• Automating Repetitive Tasks with Loops
• Conditional Statements (If-Then-Else)
• Writing Efficient VBA Code

SmartSheet Unleash Collaboration’s True Potential

• Understanding Google Sheets & Excel
• Real-Time Collaboration in Google Sheets
• Importing/Exporting Data & Add-ons
• Automating Tasks with Google Apps Script
• Best Practices for Data Integration

Task Insights Review & Practical Outcomes

• Evaluating Project Progress
• Syntax Procedure
• VBA Excel Object
• Msg Box and Input Box
• Gathering Feedback and Refining Skills (Study Case)

Professional Document Processing

• Efficient Document Navigation & Management
• Document Formatting: Paper Size, Margins, Headers, Footers & Page Numbering
• Reviewing & Collaborating on Documents with Track Changes & Comments
• Automating Document Creation with Mail Merge
• Securing Sensitive Documents with Restrict Editing & Password Protection

Microsoft Word for Thesis

• Automated Thesis Formatting: Streamlining Your Document Setup
• Mastering Citation Management with Mendeley
• Managing Page Numbers and Section Breaks for Structured Document Layout
• Enhancing Writing and Research Efficiency with AI Tools in Word

Microsoft PowerPoint Basics to Advanced

• PowerPoint The Ultimate Presentation Tool
• Slide Design Mastery Creating Consistency and Impact
• Essential PowerPoint Features for Professional Presentations
• Dynamic Presentations Animations, Audio & Video Integration
• Visualizing Data Using Charts & SmartArt for Clarity
• Interactive Presentation: Hyperlinks & Action Buttons
• Pitch Deck Essentials: Crafting the Perfect Business Story