Top Tutor Top Tutor 
20 yrs of Exp 
337 students 
2801 hrs of classes 
Bagmugaliya, Bhopal 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.
Microsoft Excel Training classes 
214 Students Excellence Award Winner 2022
Microsoft Excel Training
Excellence Award Winner 2023
1st Jan - 30th Jun
Microsoft Excel Training
Top 10 in Microsoft Excel Training 2024
Microsoft Excel Training
Top 100 tutors of 2024
Microsoft Excel Training
Top 10 in Microsoft Excel Training 2025
Microsoft Excel Training
Top 100 tutors of 2025
Microsoft Excel Training
UrbanPro Certified Tutor
For Microsoft Excel Training
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
20+
Teaches following Excel features
Advanced Excel, Excel Macro Training, Basic Excel
Microsoft Power BI classes 11 Students Top 10 in Microsoft Power BI 2024
Microsoft Power BI
Top 10 in Microsoft Power BI 2025
Microsoft Power BI
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Microsoft Power BI classes
20+
Teaching Experience in detail in Microsoft Power BI classes
You will Learn Power Bi with me by working on real corporate data sets. I will teach you Data Cleaning with Power Query, Data Modelling, DAX and Data Visualizations. I have corporate experience and experience teaching MBA students and professionals. I have trained 10000 plus students and professionals in Advanced Excel, Power BI and Data Analytics.
4.8 out of 5 480 reviews
Vrinda Khare
"These classes are so helpful i am able to work on Excel sheets and data. Sir always clear our doubts,thanks to sir. "
Reply by Sanjay Singh
Thanks Vrinda...you are keen, confident learner and willing to participate in all activities...you have a bright future...all the best
Harmeet Singh khalsa
"Easy to understand and interactive learning experience in one place with loads of opportunities & growth. "
Reply by Sanjay Singh
Thanks Harmeet, you are dedicated and hard working student...all the best
Sunil Rana
Excel Job-Ready Accelerator: Practical Excel, Power Query & Dashboards
I loved
Teacher's Knowledge
Teaching Method
Class Content
Audio/Video Quality
Mutiat Bamidele Arike
Excel Job-Ready Accelerator: Practical Excel, Power Query & Dashboards
I liked
Teaching Method
Nikita Rao
Excel Job-Ready Accelerator: Practical Excel, Power Query & Dashboards
I loved
Teacher's Knowledge
Teaching Method
Class Content
Audio/Video Quality
Chaitanya Varma
Microsoft PowerPoint Training
I loved
Teacher's Knowledge
Yeshi Choden bhutia
431304_431304_Microsoft Excel Training
I loved
Teaching Method
Teacher's Knowledge
Sirshendu Bikash mondal
431304_431304_Microsoft Excel Training
I loved
Audio/Video Quality
Class Content
Teaching Method
Teacher's Knowledge
Soumya Vellanki
431304_431304_Microsoft Excel Training
I loved
Teaching Method
Reply by Sanjay Singh
Thanks Soumya
L Charan sai
431304_431304_Microsoft Excel Training
I didn't like
Audio/Video Quality
Class Content
Teaching Method
Teacher's Knowledge
Harshita T
431304_431304_Microsoft Excel Training
I loved
Teacher's Knowledge
Teaching Method
Class Content
Audio/Video Quality
Abhay Kumar
431304_431304_Microsoft Excel Training
I liked
Teaching Method
Teacher's Knowledge
Kiran Krishnanath gangavane
431304_431304_Microsoft Excel Training
I loved
Class Content
Teacher's Knowledge
Teaching Method
Seena C r
431304_431304_Microsoft Excel Training
I loved
Teaching Method
Ashok Singh
431304_431304_Microsoft Excel Training
I loved
Class Content
Audio/Video Quality
Teaching Method
Teacher's Knowledge
Have you attended any class with Sanjay Singh?
Answered on 16/07/2024 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/PowerPivot in Excel
Ask a Question
Post a Lesson
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.
Like 1 
Answers 3 
Comments Answered on 03/01/2024 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/HLOOKUP in Excel
Ask a Question
Post a Lesson
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.
Like 1 Answers 3 Comments Ask a Question
Want to learn from Sanjay Singh?
Share this profile 
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.
0
