Aslam's email address and phone number have been validated.
Aslam
- Rate ₱668
- Response 1h
₱668/h
See Microsoft Excel tutors
Unfortunately, this tutor is 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
- Elementary School
- Junior High School
- Senior High School
- +10
levels :
Elementary School
Junior High School
Senior High School
Technical Vocational Education And Training
Adult Education
Bachelor
Master
Doctoral
Early Childhood Education
Beginner
Intermediate
Advanced
Children
- 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
Rate
- ₱668
Pack rates
- 5h: ₱1,370
- 10h: ₱1,712
online
- ₱668/h
Other tutors in Microsoft Excel
Jo-Ann
Masbate City & online
- ₱1,000/h
- 1st lesson free
Mourad
Paris 12e, France & online
- ₱2,744/h
- 1st lesson free
Billy
Bullhead City, United States & online
- ₱3,145/h
- 1st lesson free
Erica
Fairfield, Australia & online
- ₱2,688/h
Ireneusz
Gdańsk, Poland & online
- ₱1,986/h
- 1st lesson free
Zammad
New York, United States & online
- ₱3,145/h
- 1st lesson free
Arbaz
New York, United States & online
- ₱2,516/h
- 1st lesson free
Matthieu
Tigery, France & online
- ₱2,166/h
- 1st lesson free
Adi
Toronto, Canada & online
- ₱2,247/h
- 1st lesson free
Moreno
Monza, Italy & online
- ₱3,610/h
- 1st lesson free
Ben
Bristol, United Kingdom & online
- ₱3,790/h
- 1st lesson free
Ilian
Paris 8e, France & online
- ₱1,805/h
- 1st lesson free
Patricia
Madrid, Spain & online
- ₱1,805/h
Inès
Paris 1er, France & online
- ₱3,249/h
Doğukan
Küçükçekmece, Turkey & online
- ₱1,289/h
Matthew
London, United Kingdom & online
- ₱3,284/h
- 1st lesson free
Cassandre
Lehigh Acres, United States & online
- ₱3,711/h
Massimiliano
Ancona, Italy & online
- ₱2,166/h
- 1st lesson free
Gabriel
São Paulo, Brazil & online
- ₱1,429/h
- 1st lesson free
Leonardo
Itaim Bibi, Brazil & online
- ₱1,099/h
- 1st lesson free
-
See Microsoft Excel tutors
