Aslam's profile and their contact details have been verified by our experts
Aslam
- Price $15
- Answer 1h
$15/h
More Microsoft Excel teachers
This teacher is currently unavailable
- Microsoft Excel
I’m a working professional based in Dubai with over 15 years of experience in accounting and data analysis Excel for Accounting and Data Analytics, along with Business English, Grammar, Accounting Sof
- Microsoft Excel
Lesson location
About Aslam
I am Aslam, 15 years of experience in business management, accounting, and data analysis. Alongside my professional career, I teach students Business English, Grammar, Accounting Software (Tally Prime), and Data Analysis using Excel and Power BI. My approach focuses on practical learning and real-world application to help students gain confidence and job-ready skills.
see more
About the lesson
- Primary School
- High School
- Year 10
- +10
levels :
Primary School
High School
Year 10
TAFE
Adult
Undergraduate
Diploma/Certificate
PhD
Early childhood education
Beginner
Intermediate
Advanced
Kids
- English
All languages in which the lesson is available :
English
Module 1: Introduction to Excel (Session 1–2)
Overview of Excel interface, ribbons, and navigation
Formatting cells, rows, and columns
Data entry best practices for accounting & analysis
Basic formulas: SUM, AVERAGE, COUNT, MIN, MAX
Practical: Create a simple sales ledger or expense sheet
---
Module 2: Formulas & Functions (Session 3–4)
Relative & absolute references
Common accounting functions:
ROUND, IF, SUMIF, COUNTIF, VLOOKUP, HLOOKUP
TEXT, LEFT, RIGHT, CONCATENATE
Date and time functions for reports
Practical: Build an automated profit & loss statement
---
Module 3: Data Management & Cleaning (Session 5)
Sorting and filtering data
Remove duplicates, text-to-columns, data validation
Using conditional formatting for highlighting trends
Practical: Clean raw data from an accounting system
---
Module 4: Data Analysis Tools (Session 6–8)
PivotTables & PivotCharts
Data summarization and grouping
Using slicers and timelines
Basic data visualization with charts (Bar, Pie, Line)
Practical: Analyze monthly sales or expense data
---
Module 5: Advanced Excel Techniques (Session 9–10)
Lookup alternatives: INDEX & MATCH
Introduction to XLOOKUP and dynamic arrays (Office 365)
Scenario Manager, Goal Seek, and What-If Analysis
Practical: Build an interactive financial dashboard
---
Module 6: Integration & Automation (Optional Advanced Sessions)
Linking Excel with Tally / Accounting systems
Introduction to Power Query
Automating repetitive tasks using Macros / VBA (basic)
Exporting reports for Power BI visualization
see more
Rates
Price
- $15
Pack prices
- 5h: $31
- 10h: $39
online
- $15/h
Similar Microsoft Excel tutors in Dubai
Erica
Fairfield & online
- $60/h
Neha
Sydney & online
- $65/h
Ahsan
Woodville North & online
- $80/h
- 1st lesson free
Amanda Yukari
Manunda & online
- $35/h
- 1st lesson free
Tina
& online
- $55/h
- 1st lesson free
Jabran
Hornsby & online
- $30/h
Humberto
Ravensdale & online
- $40/h
- 1st lesson free
Andrea
Sydney & online
- $200/h
Madhawa
Parklea & online
- $100/h
Tran
Sydney & online
- $35/h
- 1st lesson free
Gabrin
Sydney & online
- $45/h
- 1st lesson free
Sami
Sydney & online
- $40/h
Vaibhav
Adelaide & online
- $26/h
- 1st lesson free
M Fouze
Tarneit & online
- $75/h
Johnson
Sydney & online
- $22/h
- 1st lesson free
Mal
Brisbane & online
- $35/h
- 1st lesson free
Dr Vijay Reena
Kensington & online
- $79/h
Upeksha
Holden Hill & online
- $30/h
Vishwajeet
Blacktown & online
- $45/h
- 1st lesson free
Pallavi
Sydney & online
- $40/h
- 1st lesson free
-
More Microsoft Excel teachers
