

Aaron's email address and phone number have been validated.
Aaron
- Rate $5
- Response 1h
-
Students1
Number of students Aaron has accompanied since arriving at Superprof
Number of students Aaron has accompanied since arriving at Superprof

$5/hr
This teacher is currently unavailable
- Microsoft Excel
Excel for Work: Practical Skills Every Malaysian Office Needs From Zero to Dashboard Hero
- Microsoft Excel
Lesson location
About Aaron
A mission-driven Data and Business Analyst with proven experience in both the non-profit and private sectors, including a key analytics role at Cancer Research UK, one of the world’s leading NGOs. Skilled in performance reporting, budgeting, stakeholder coordination, and campaign optimization. Passionate about using data and operations to drive social impact — particularly in sustainability, public health, and systemic change.
About the lesson
- All Levels
- English
All languages in which the lesson is available :
English
Lesson 1: Excel Basics Refresher
Understanding the interface (ribbons, columns, rows)
Basic formulas: SUM, AVERAGE, COUNT
Formatting tips for clean reports
Lesson 2: Data Management Essentials
Filtering and sorting
Freeze panes, wrap text, and conditional formatting
Data validation for dropdown menus
Lesson 3: Intermediate Formulas
IF, AND, OR logic
VLOOKUP and XLOOKUP (with real HR/sales use case)
TEXT functions (LEFT, RIGHT, MID, CONCAT)
Lesson 4: Time-Saving Features
Flash fill and auto-fill
Named ranges
Quick Analysis Tool
Lesson 5: Pivot Tables & Charts
Building pivot tables with filters
Creating dashboards using pivot charts
Monthly report template for management
Lesson 6: Automation with Excel
Basic Excel Macros (recording and running)
Introduction to Power Query
Sample task: Automatically clean and combine staff attendance files
Rates
Rate
- $5
Pack prices
- 5h: $25
- 10h: $50
online
- $5/h
Similar Microsoft Excel tutors in Kuala Lumpur
David
Cambridge & online
- $50/h
- 1st lesson free
Timothy
Christchurch & online
- $200/h
Garry
New Plymouth & online
- $40/h
- 1st lesson free
Ankita
Dunedin & online
- $30/h
- 1st lesson free
Yatender
Auckland & online
- $25/h
- 1st lesson free
Fortunate
Wellington & online
- $15/h
- 1st lesson free
Aarav
Lower Hutt & online
- $20/h
- 1st lesson free
Karyn
Pukekohe & online
- $70/h
- 1st lesson free
Abdul
Christchurch & online
- $35/h
- 1st lesson free
Hajera
Auckland
- $30/h
- 1st lesson free
Aneh
Auckland & online
- $35/h
- 1st lesson free
Sonja
Dunedin & online
- $60/h
- 1st lesson free
Johnson
Auckland & online
- $15/h
- 1st lesson free
Sarnesh
Auckland & online
- $50/h
- 1st lesson free
Narita
Levin & online
- $44/h
- 1st lesson free
Ladonna
Auckland & online
- $40/h
- 1st lesson free
Alex
Wellington & online
- $30/h
- 1st lesson free
Emily
Cambridge & online
- $43/h
- 1st lesson free
Iunisi
Auckland & online
- $28/h
- 1st lesson free
Juliano
Christchurch & online
- $30/h
- 1st lesson free
-
See Microsoft Excel tutors
