Ziyad's profile and their contact details have been verified by our experts
Ziyad
- Rate $17
- Response 10h
-
Students3
Number of students Ziyad has accompanied since arriving at Superprof
Number of students Ziyad has accompanied since arriving at Superprof
$17/hr
See Microsoft Excel tutors
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
- High School
- NCEA Level 1
- +10
levels :
Primary
High School
NCEA Level 1
NCEA Level 2
NCEA Level 3
Adult education
Masters
Doctorate
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
Rate
- $17
Pack prices
- 5h: $85
- 10h: $170
online
- $17/h
Similar Microsoft Excel tutors in New York
Garry
New Plymouth & online
- $40/h
- 1st lesson free
David
Cambridge & online
- $50/h
- 1st lesson free
Timothy
Christchurch & online
- $200/h
Yatender
Auckland & online
- $25/h
- 1st lesson free
Fortunate
Wellington & online
- $15/h
- 1st lesson free
Aarav
Lower Hutt & online
- $20/h
- 1st lesson free
Karyn
Pukekohe & online
- $70/h
- 1st lesson free
Abdul
Christchurch & online
- $35/h
- 1st lesson free
Aneh
Auckland & online
- $35/h
- 1st lesson free
Sonja
Dunedin & online
- $60/h
- 1st lesson free
Johnson
Auckland & online
- $15/h
- 1st lesson free
Sarnesh
Auckland & online
- $50/h
- 1st lesson free
Narita
Levin & online
- $44/h
- 1st lesson free
Ladonna
Auckland & online
- $40/h
- 1st lesson free
Alex
Wellington & online
- $30/h
- 1st lesson free
Hajera
Auckland
- $30/h
- 1st lesson free
Emily
Cambridge & online
- $43/h
- 1st lesson free
Iunisi
Auckland & online
- $28/h
- 1st lesson free
Juliano
Christchurch & online
- $30/h
- 1st lesson free
Mourad
Paris 12e, France & online
- $75/h
- 1st lesson free
-
See Microsoft Excel tutors
