Shubham's profile and their contact details have been verified by our experts
Shubham
- Rate ₱259
- Response 1h
₱259/h
See Microsoft Excel tutors
Unfortunately, this tutor is unavailable
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Office automation
- Microsoft Outlook
Microsoft Excel Masterclass: NIT Raipur graduate with 2+ years of extensive working experience with MNC as a data and business analyst to teach you from zero to zenith with real-life data sets and Ind
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Office automation
- Microsoft Outlook
Lesson location
About Shubham
A Microsoft Excel expert with a passion for helping learners succeed. I'm here to share my knowledge and expertise with you so you can master Excel and take your career to the next level.
Brief about Excel
1. Introduction to Excel:
• Basic Excel navigation and operations
• Basic functions such as SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, ROUND, SUBTOTAL, etc.
• Absolute, mixed, and relative referencing in formulas.
2. Working with Data
• String functions (LEFT, RIGHT, MID, CONCATENATE, etc.)
• Logical functions (IF, AND, OR, NOT, etc.)
• Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH, etc.)
• Data validation to control the type and value of data
• Sorting and filtering techniques to organize and analyze your data
• Pivot tables/Power Pivot Table and pivot charts to summarize and analyze large amounts of data
• Data analytics dashboards using slicers, timelines, sparklines, etc.
3. Advanced Excel Features
• Mathematical functions such as SUMIF SUMIFS COUNTIF COUNTIFS AVERAGEIF AVERAGEIFS SUMPRODUCT etc.
• Statistical functions such as AVERAGE MEDIAN MODE STDEV VAR CORREL RANK PERCENTILE QUARTILE etc.
• What-if analysis tools such as Goal Seek, Data Table, and Scenario Manager.
• Data Modelling, Power Pivots, and Power Query
& much more ………………………………………………………..
Join me today and discover the power of Excel. You won’t regret it. Because with Excel, the possibilities are endless.
See more
About the lesson
- Elementary School
- Junior High School
- Senior High School
- +14
levels :
Elementary School
Junior High School
Senior High School
Technical Vocational Education And Training
Professional
Adult Education
Bachelor
Master
Doctoral
Other
MBA
Early Childhood Education
Beginner
Intermediate
Advanced
others
Children
- English
All languages in which the lesson is available :
English
Master Excel and Advance Your Career
I am a highly skilled and experienced Microsoft Excel instructor with a passion for helping people succeed. My classes are focused on hands-on experience, real-world examples, and practical applications, and I am committed to providing individuals with the skills they need to thrive in the workplace. I believe that everyone can learn Excel, and I am here to help them every step of the way.
Become an Excel wizard and Unlock Your Potential !!
See more
Rates
Rate
- ₱259
Pack rates
- 5h: ₱972
- 10h: ₱1,945
online
- ₱259/h
Other tutors in Microsoft Excel
Jo-Ann
Masbate City & online
- ₱1,000/h
- 1st lesson free
Mourad
Paris 12e, France & online
- ₱3,139/h
- 1st lesson free
Erica
Fairfield, Australia & online
- ₱2,533/h
Ireneusz
Gdańsk, Poland & online
- ₱1,953/h
- 1st lesson free
Billy
Bullhead City, United States & online
- ₱3,060/h
- 1st lesson free
Arbaz
New York, United States & online
- ₱2,448/h
- 1st lesson free
Matthieu
Tigery, France & online
- ₱2,092/h
- 1st lesson free
Adi
Toronto, Canada & online
- ₱2,158/h
- 1st lesson free
Ben
Southampton, United Kingdom & online
- ₱3,639/h
- 1st lesson free
Zammad
New York, United States & online
- ₱3,060/h
- 1st lesson free
Ilian
Paris 8e, France & online
- ₱1,744/h
- 1st lesson free
Marc
New York, United States & online
- ₱7,651/h
Patricia
Madrid, Spain & online
- ₱1,744/h
Inès
Paris 1er, France & online
- ₱3,139/h
Abhishek
Noida, India & online
- ₱584/h
- 1st lesson free
Doğukan
Küçükçekmece, Turkey & online
- ₱1,050/h
Moreno
Monza, Italy & online
- ₱3,487/h
- 1st lesson free
Matthew
London, United Kingdom & online
- ₱3,154/h
- 1st lesson free
Cassandre
Lehigh Acres, United States & online
- ₱3,611/h
Massimiliano
Ancona, Italy & online
- ₱2,092/h
- 1st lesson free
-
See Microsoft Excel tutors
