Bagmugaliya, Bhopal, India - 462026
Super Tutor Certified 296
Details verified of Sanjay Singh✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
Excellence Award Winner 2022
Microsoft Excel Training
Excellence Award Winner 2023
1st Jan - 30th Jun
Microsoft Excel Training
UrbanPro Certified Tutor
For Microsoft Excel Training
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
20
Teaches following Excel features
Excel Macro Training, Advanced Excel, Basic Excel
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in Microsoft Power BI classes
5
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in Microsoft PowerPoint Training classes
5
Teaching Experience in detail in Microsoft PowerPoint Training classes
I am teaching MS Office including PowerPoint presentations to university students studying business, commerce and management.
4.8 out of 5 436 reviews
Avinav Sinha
Microsoft Excel Training
"I attended Sir's classes this 4 weeks. Sir makes us learn every step and clears doubt of each and every student. "
Vishal Mayer
Microsoft Excel Training
"Sanjay sir is one of the best teacher i ever seen. Sanjay sir teaching skills are very good. From my side i give 5 stars. "
Anand Sanodiya
"Sanjay sir explains very easily and explains in very unique style, I enjoy very much sir's class. & I understand everything. "
Shubham
Microsoft Excel Training
"It's great to learn from you sir. My experience is getting better after learning from you I think I understand excel. "
Kanishka Salvi
Microsoft Excel Training
"The way he delivered his knowledge is incredible. You will understand each and every concept clearly. "
Aditya Mawar
Microsoft Excel Training
"Great teacher with awesome knowledge and kind. Have great knowledge of ms excel. Friendly and explain really well with calmness. "
Harshit Goyal
Microsoft Excel Training
"Sanjay sir is one of the finest Excel teacher in the nation. Being his student is a privilege and would love to keep learning from him. "
Ritik taran
"He teaches ms excel so well in depth and also provides various easy-to-use techniques that helps much. "
Rounak Singh
Microsoft Excel Training
"I must say his teaching style is really distinctive and appreciable, and i enjoyed every minute of his lecture as well as his marvellous sense of humor. "
Ishita Das
"I really enjoyed your class and was actually excited to come to class every day. I am very thankful for passionate professors like you! Thank you for a wonderful work. I appreciated your caring disposition and teaching style. "
Vaishnavi Patrikar
"You're a great teacher sir. I would love to be taught from you. Whenever I feel trouble you try to help and that's really grateful. "
Aman Soni
Microsoft Excel Training
"He was good teacher and he have good knowledge and also known how to teach with good behaviour with best way. "
Ansab Ali
Microsoft Power BI
"The Manner of teaching is so wonderful and refreshing!! He’s patient and supportive, he really knows how to motivate her/his students. He’s great at building confidence and keeping lessons fun and engaging through a variety of activities that improve conversation. "
Aniket Thakur
Microsoft Excel Training
"Unique teaching style, support all students Nice teacher. Good knowledge of Microsoft excel and power. "
Nitin Patidar
"According to me i got excellent learning experience on Microsoft excel and it will be helpful in future. "
Answered on 16 Jul Learn IT Courses/MS Office Software Training/Microsoft Excel Training/PowerPivot in Excel
Power Query is best tool for ETL. ETL is extraction, transformation and loading of data. Basically here we cleaning the extracted data and making it ready for analysis.
Power Pivot is a tool for modelling, writing customized functions and making it ready for final visualisation using Pivot tables, Pivot charts.
Answered on 03 Jan Learn IT Courses/MS Office Software Training/Microsoft Excel Training/HLOOKUP in Excel
Both these functions in Excel have exactly the same syntax. Only difference is in VLOOKUP we have third argument as Column Index number and in HLookup it is row index number.
So let's understand how do these two formulas differ in terms of application.
While VLOOKUP is used whenever table has got column headers and table has vertical orientation while HLookup is used when data in a table is arranged in rows and table has horizontal Orientation.
You can book a free demo class with me to understand this concept with practical examples.
https://vz-3ad30922-ba4.b-cdn.net/f773e4aa-5f17-41f9-8b79-6acd58c81307/play_480p.mp4
Share this Profile
Also have a look at
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.