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

What You Will Learn

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)