Deskripsi
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
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