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