Ziyad's profile and their contact details have been verified by our experts
Ziyad
- Price $14
- Answer 10h
-
Students3
Number of students Ziyad has accompanied since arriving at Superprof
Number of students Ziyad has accompanied since arriving at Superprof
$14/h
More Microsoft Excel teachers
This teacher is currently unavailable
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Office automation
Business College student fluent in Excel, Macros and VBA motivated to share my knowledge and expertise to all levels online.
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Office automation
Lesson location
Recommended
Ziyad is a respected tutor in our community. He is highly recommended for his commitment and the quality of his lessons. An excellent choice to progress with confidence.
About Ziyad
As a Grande École student deeply immersed in Excel and programming, I'm accustomed to daily hands-on experience. Guiding colleagues and superiors through Excel challenges has established my credibility. I'm highly motivated to maintain the highest standards, ensuring confidence in my professionalism.
see more
About the lesson
- Primary School
- High School
- Year 10
- +12
levels :
Primary School
High School
Year 10
Year 11-12
Year 12
TAFE
Adult
Diploma/Certificate
PhD
Early childhood education
Beginner
Intermediate
Advanced
Professional
Kids
- French
- English
All languages in which the lesson is available :
French
English
Mastering Excel is an essential skill to succeed in any career in the corporate world. I am here to thoroughly explain, in the most simple and practical way, the ins and outs of Excel's Functions, functionalities as well as introduce you to the world of Macros and VBA automation.
My lessons are customized and tailored to meet each individuals needs and grasping speed, and are based on continuous practice, since Excel is something that can be learned from books but can only be mastered through handson experience.
The topics we will cover are the following:
1. Introduction to Excel: Overview of the Excel interface
2. Data entry and formatting: Best practices for presentation
3. Excel Functions:
+ Mathematical and Statistical functions: Countifs, Sumifs, Sumproduct, Averageifs, COS, Round... etc
+ Logical functions: IF, AND, OR for logical operations and nested IF for complex logical conditions
+ Text handling functions: TRIM, CLEAN, UPPER/LOWER, CONCATENATE...
+ Date functions: DATE, DATEDIFF, DATEIF
+ Reference and Lookup functions: XLOOKUP, VLOOKUP, INDEX, MATCH, OFFSET
+ Financial functions: IRR, PMT, PPMT, IPMT...
4. Data cleaning, validation and preparation: Best practices
5. Pivot Tables for data summarization and analysis, MIS reporting and Dashboards
6. Automation using Macros and VBA
7. Creating VBA forms.
see more
Recommendations
Recommendations come from relatives, friends and acquaintances of the teacher
2
Ziyad was my colleague in college. I have worked with him on many group projects and he even agreed to tutor me in Excel since I was lacking some knowledge at the time. He seemed to be an expert on the software and was able to explain complex subjects in a very simple and intuitive way. I highly recommend him for his proficiency in Excel and for his proven professionalism.
I highly recommend Ziyad as a tutor!
ZIYAD is incredibly knowledgeable and versatile. He has a deep understanding of many subjects and is particularly gifted with numbers.View more recommendations
see more
Rates
Price
- $14
Pack prices
- 5h: $70
- 10h: $140
online
- $14/h
Similar Microsoft Excel tutors in New York
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
