Ziyad's email address and phone number have been validated.
Ziyad
- Rate R168
- Response 10h
-
Students3
Number of students Ziyad has accompanied since joining Superprof
Number of students Ziyad has accompanied since joining Superprof
R168/h
See Microsoft Excel tutors
Unfortunately, this tutor is not available
- 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. A trusted partner on your learning journey.
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
- Secondary
- Matric/GCSE
- +12
levels :
Primary
Secondary
Matric/GCSE
AS Level
A Level
BTech
Adult education
Masters
Doctorate
MBA
Beginner
Intermediate
Advanced
Professional
Kids
- French
- English
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 are written by the tutor's friends, family, and acquaintances.
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.See more recommendations
See more
Rates
Rate
- R168
Package rates
- 5h: R840
- 10h: R1680
online
- R168/h
Similar Microsoft Excel tutor profiles
Christopher
Cape Town & online
- R170/h
- 1st lesson free
Oleksandr
Randburg & online
- R349/h
- 1st lesson free
Tapiwa
Sandton & online
- R450/h
- 1st lesson free
Don Quintin
Johannesburg & online
- R100/h
- 1st lesson free
SEMENYA
Polokwane & online
- R262/h
- 1st lesson free
Antionette
Randfontein & online
- R250/h
- 1st lesson free
Mpho
Burgersfort & online
- R140/h
- 1st lesson free
Dylan
Randfontein & online
- R350/h
- 1st lesson free
Valentino
Pretoria & online
- R250/h
- 1st lesson free
Irfan
Berea & online
- R145/h
- 1st lesson free
Siyanda
Middelburg & online
- R150/h
- 1st lesson free
Newman Blessing
Durban & online
- R200/h
- 1st lesson free
Sally
Cape Town & online
- R200/h
- 1st lesson free
Tamryn
KuGompo City & online
- R200/h
- 1st lesson free
Louise
Cape Town & online
- R250/h
- 1st lesson free
Kagiso victor
Rustenburg & online
- R120/h
- 1st lesson free
EL-ROHY
Randburg & online
- R250/h
- 1st lesson free
Nomthandazo
Bloemfontein & online
- R200/h
- 1st lesson free
Virgilio Mbotjhwa
Phuthaditjhaba & online
- R200/h
- 1st lesson free
Tahriq
Cape Town & online
- R150/h
- 1st lesson free
-
See Microsoft Excel tutors
