Bagmugaliya, Bhopal, India - 462026
Super Tutor Certified 293
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 432 reviews
Gaurav Gupta
"I have learnt Excel from Sanjay Singh Sir and I can say with confidence that his teaching style is very good and I understand easily all the tools in Excel explained by him. This helps me in my day to day excel operations. "
Reply by Sanjay Singh
Thanks Gaurav....interacting with you added lot of value and your inputs from real corporate projects have helped me make the course more in line with the todays business requirement
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
Harsh
Microsoft Excel Training
I liked
Audio/Video Quality
Class Content
Teaching Method
Teacher's Knowledge
Shivakumar Maruthoor
Microsoft Excel Training
I loved
Audio/Video Quality
Class Content
Teacher's Knowledge
Teaching Method
Vishal
Microsoft Excel Training
I loved
Audio/Video Quality
Teaching Method
Class Content
Teacher's Knowledge
Varun B
Microsoft Power BI
I loved
Teacher's Knowledge
Prasad Manga Konidala
Microsoft Excel Training
I loved
Teacher's Knowledge
Swaraj Chintamani jambhale
Microsoft Excel Training
I loved
Audio/Video Quality
Class Content
Teaching Method
Teacher's Knowledge
Chandan Kumar
Microsoft Excel Training
I loved
Class Content
Teacher's Knowledge
Teaching Method
Audio/Video Quality
Omair Khan
Microsoft Excel Training
I loved
Teacher's Knowledge
Teaching Method
Sumeet Lakhvir
Microsoft Excel Training
I loved
Audio/Video Quality
Class Content
Teaching Method
Teacher's Knowledge
Aanvi Adhikary
Microsoft Excel Training
I liked
Class Content
Teaching Method
Teacher's Knowledge
Audio/Video Quality
Jessica Liew
Microsoft Excel Training
I loved
Class Content
Vicky Kaushal
Microsoft Excel Training
I loved
Audio/Video Quality
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.