The profile of Ziyad and their contact details have been verified by our experts
Ziyad
- Rate L165
- Response 10h
-
Students3
Number of students Ziyad has accompanied since arriving at Superprof
Number of students Ziyad has accompanied since arriving at Superprof
L165/hr
See Microsoft Excel tutors
Unfortunately, this tutor is 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 member of our tutor 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
- Lower Secondary
- Senior Secondary
- +12
levels :
Primary
Lower Secondary
Senior Secondary
Post Secondary Education
Higher Education
Adult Education
Master's Degree
Doctorate
MBA
Early Childhood Care & Development
Beginner
Intermediate
Advanced
Professional
Children
- English
All languages in which the lesson is available :
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
Rate
- L165
Pack prices
- 5h: L825
- 10h: L1650
online
- L165/h
Similar Microsoft Excel teachers in New York
Mourad
Paris 12e, France & Online
- L857/hr
- 1st lesson free
Erica
Fairfield, Australia & Online
- L695/hr
Ireneusz
Gdańsk, Poland & Online
- L538/hr
- 1st lesson free
Billy
Bullhead City, United States & Online
- L823/hr
- 1st lesson free
Arbaz
New York, United States & Online
- L659/hr
- 1st lesson free
Matthieu
Tigery, France & Online
- L571/hr
- 1st lesson free
Adi
Toronto, Canada & Online
- L589/hr
- 1st lesson free
Ben
Southampton, United Kingdom & Online
- L993/hr
- 1st lesson free
Ilian
Paris 8e, France & Online
- L476/hr
- 1st lesson free
Marc
New York, United States & Online
- L2,058/hr
Patricia
Madrid, Spain & Online
- L476/hr
Zammad
New York, United States & Online
- L823/hr
- 1st lesson free
Inès
Paris 1er, France & Online
- L857/hr
Doğukan
Küçükçekmece, Turkey & Online
- L285/hr
Moreno
Monza, Italy & Online
- L952/hr
- 1st lesson free
Cassandre
Lehigh Acres, United States & Online
- L971/hr
Massimiliano
Ancona, Italy & Online
- L571/hr
- 1st lesson free
Matthew
London, United Kingdom & Online
- L861/hr
- 1st lesson free
Gabriel
, Brazil & Online
- L377/hr
- 1st lesson free
Leonardo
Lapa de Baixo, Brazil & Online
- L322/hr
- 1st lesson free
-
See Microsoft Excel tutors
