Aaron

Rate $4
Response 1h
Students
Number of students Aaron has accompanied since arriving at Superprof
1
Number of students Aaron has accompanied since arriving at Superprof

$4/h

Excel for Work: Practical Skills Every Malaysian Office Needs From Zero to Dashboard Hero

Microsoft Excel

Lesson location

- online

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

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

Excel for Work: Practical Skills Every Malaysian Office Needs From Zero to Dashboard Hero

Lesson location

About Aaron

About the lesson

Rates

Rate

Pack rates

online

Other tutors in Microsoft Excel

Microsoft office specialist certified expert tutor (excel, access, word, powerpoint & outlook) - virtual / remote only

Excel and ms office help for work tasks, reports, and productivity | certified tutor with 20+ years of experience!

Become a master in project management with personalized, hands-on mentoring from an expert with over 8 years of industry experience

Microsoft office trainer: master excel, word, powerpoint and outlook for work with a certified corporate instructor

Basic to expert excel mastery for all ages - personalized online tutoring by an excel pro with over a decade of multi-industry expertise! problem solver pro for your projects and/or jobs.

Build or refine your skills in data and analytics tools like microsoft excel, and tableau through coaching and support from an experienced data analyst.

Master excel and access: boost productivity with essential skills, advanced functions, and time-saving tips for beginners and intermediates

Ms excel enthusiast with corporate training and online 1 -1 training experience with ms excel and related software. i am available for 1 - 1 remote training in vancouver and everywhere else

Ms excel & word expertise unleashed: master excel & word to elevate your skills and conquer complex tasks. (online only)

Basic and intermediate ms excel lessons. can also teach basic and intermediate ms word. alsoquickbooks and sage50.

Microsoft office specialist master and excel expert with 15+ years training and data analysis experience, providing advanced excel solutions, automation, and sharepoint services for small businesses.

Complete microsoft excel tutoring with easy approach from high school to professionals. all excel related assignments & project help available for university, college students and working professional

Master microsoft office suite with a seasoned expert: excel, word, powerpoint, project, typing, and office automation | 6+ years of teaching & industry experience | elevate your productivity skills

Learn excel from beginner to advanced: formulas, pivot tables, data analysis, charts & reporting & more

Microsoft excel, basic and advanced excel functions - vlookup, pivot, modeling. statistics using excel.

Microsoft excel foundations program with live guidance and hands-on professional training sessions

Unlock your potential with online private classes in microsoft excel, word, and powerpoint designed for beginners and professionals alike.

Boost your digital skills with personalized online private classes in microsoft excel, word, and powerpoint!

From corporate boardrooms to your desk: master microsoft project, excel, powerpoint for effective project management

Graduate teaching assistant with 12 years of experience teaching excel and analytics.

Excel for Work: Practical Skills Every Malaysian Office Needs From Zero to Dashboard Hero

Lesson location

About Aaron

About the lesson

Rates

Rate

Pack rates

online

Other tutors in Microsoft Excel

Microsoft office specialist certified expert tutor (excel, access, word, powerpoint & outlook) - virtual / remote only

Excel and ms office help for work tasks, reports, and productivity | certified tutor with 20+ years of experience!

Become a master in project management with personalized, hands-on mentoring from an expert with over 8 years of industry experience

Microsoft office trainer: master excel, word, powerpoint and outlook for work with a certified corporate instructor

Basic to expert excel mastery for all ages - personalized online tutoring by an excel pro with over a decade of multi-industry expertise! problem solver pro for your projects and/or jobs.

Build or refine your skills in data and analytics tools like microsoft excel, and tableau through coaching and support from an experienced data analyst.

Master excel and access: boost productivity with essential skills, advanced functions, and time-saving tips for beginners and intermediates

Ms excel enthusiast with corporate training and online 1 -1 training experience with ms excel and related software. i am available for 1 - 1 remote training in vancouver and everywhere else

Ms excel & word expertise unleashed: master excel & word to elevate your skills and conquer complex tasks. (online only)

Basic and intermediate ms excel lessons. can also teach basic and intermediate ms word. alsoquickbooks and sage50.

Microsoft office specialist master and excel expert with 15+ years training and data analysis experience, providing advanced excel solutions, automation, and sharepoint services for small businesses.

Complete microsoft excel tutoring with easy approach from high school to professionals. all excel related assignments & project help available for university, college students and working professional

Master microsoft office suite with a seasoned expert: excel, word, powerpoint, project, typing, and office automation | 6+ years of teaching & industry experience | elevate your productivity skills

Learn excel from beginner to advanced: formulas, pivot tables, data analysis, charts & reporting & more

Microsoft excel, basic and advanced excel functions - vlookup, pivot, modeling. statistics using excel.

Microsoft excel foundations program with live guidance and hands-on professional training sessions

Unlock your potential with online private classes in microsoft excel, word, and powerpoint designed for beginners and professionals alike.

Boost your digital skills with personalized online private classes in microsoft excel, word, and powerpoint!

From corporate boardrooms to your desk: master microsoft project, excel, powerpoint for effective project management

Graduate teaching assistant with 12 years of experience teaching excel and analytics.

Share

Verified tutor profile

levels

All languages in which the lesson is available

Review

Reviews

Recommendations

free lessons

Report this ad