Ziyad's email address and phone number have been validated.
Ziyad
- Rate Ksh. 1,294
- Response 10h
-
Students3
Number of students Ziyad has accompanied since arriving at Superprof
Number of students Ziyad has accompanied since arriving at Superprof
Ksh. 1,294/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
- Lower Primary
- Upper Primary
- Lower Secondary
- +13
levels :
Lower Primary
Upper Primary
Lower Secondary
Senior School
Tertiary
University
Adult Education
Masters
Doctorate
MBA
Pre-Primary
Beginner
Intermediate
Advanced
Professional
Children
- 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
Rate
- Ksh. 1,294
Pack prices
- 5h: Ksh. 5
- 10h: Ksh. 10
online
- Ksh. 1,294/h
Similar Microsoft Excel teachers in New York
Victoria
Nairobi & Online
- Ksh. 1,000/h
- 1st lesson free
Melody
Nairobi & Online
- Ksh. 1,500/h
- 1st lesson free
Firstrate
Mombasa & Online
- Ksh. 2,000/h
- 1st lesson free
Mary
Nairobi & Online
- Ksh. 1,000/h
- 1st lesson free
Mourad
Paris 12e, France & Online
- Ksh. 5,641/h
- 1st lesson free
Erica
Fairfield, Australia & Online
- Ksh. 5,419/h
Ireneusz
Gdańsk, Poland & Online
- Ksh. 4,134/h
- 1st lesson free
Zammad
New York, United States & Online
- Ksh. 6,468/h
- 1st lesson free
Billy
Bullhead City, United States & Online
- Ksh. 6,468/h
- 1st lesson free
Arbaz
New York, United States & Online
- Ksh. 5,174/h
- 1st lesson free
Matthieu
Tigery, France & Online
- Ksh. 4,453/h
- 1st lesson free
Adi
Toronto, Canada & Online
- Ksh. 4,606/h
- 1st lesson free
Ben
Bristol, United Kingdom & Online
- Ksh. 7,793/h
- 1st lesson free
Ilian
Paris 8e, France & Online
- Ksh. 3,711/h
- 1st lesson free
Marc
New York, United States & Online
- Ksh. 16,170/h
Patricia
Madrid, Spain & Online
- Ksh. 3,711/h
Inès
Paris 1er, France & Online
- Ksh. 6,680/h
Abhishek
Noida, India & Online
- Ksh. 1,150/h
- 1st lesson free
Doğukan
Küçükçekmece, Turkey & Online
- Ksh. 2,183/h
Moreno
Monza, Italy & Online
- Ksh. 7,422/h
- 1st lesson free
-
See Microsoft Excel tutors
