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.
Microsoft Excel Training classes 185 Students 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
8 Students 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
Gopal
Microsoft Excel Training
"I would like to thanks you about easy learning and all concepts are early to learn i love to training in advance Excel. "
Manish Kumar
Microsoft Excel Training
"Very good experience excel training problem And good training, good teaching, good behavior, all study. "
Akhilesh Pratap singh
Microsoft Excel Training
"Sir, the way you explained it was excellent. I impressed by your explanation of how humbly you explain with politeness. Definitely these learning will help me to develop my analysis and also reduce the time and efforts. "
Rameez Nazir dhar
Microsoft Excel Training
"Wonderful, fabulous. There are very few persons who teaches like sanjay ji. I simply love it and the most beautiful part was that sanjay ji took our class early morning and with smilling attitude he made my day happy. What I understood he loves teaching and so it makes him happy and when your teacher is in happy mode you learn things easily. "
Shuchi Shah
Microsoft Excel Training
"We have learnt a lot during training. He made the whole excel very easy to learn and also taught implementation part. "
Richa Raval
Microsoft Excel Training
"Good learning experience, analytical skills are upgraded and feel confident. We will definitely utilise. Thank you Sir. "
Hima Bindu
Microsoft Excel Training
"This training was so extremely valuable and useful to me. Thanks for the wonderful training session. "
Veronica
Microsoft Excel Training
"Wonderful experience in learning with excel. Learnt a lot of new features. Sir you're Super talented with excel. "
Dipika Pandya
"Teaching style very nice, sir teaches one by one topic, if we understood then he go to next topic. Very friendly nature of Teaching time. Thanks. "
Miteshbhai Mahendrabhai patel
Microsoft Excel Training
"I learned a lot. The most important part is that I enjoy every bit of the session and completed everything less than a month. "
Khushbu Narielwala
Microsoft Excel Training
"Thanks for giving us wonderful Excel Training. It will definitely help in our office work. It was good experience with Sanjay Sir. "
Jyoti A vanza
"It is so useful excel in real working in company. I have learned new formulas in this class. So easy way to work in short time. "
Simmi Maisuriya
Microsoft Excel Training
"Outstanding training. friendly teaching. Easy to learn. As well as training also excellent. Master mind academy. "
Biswajit Biswas
"It's really really amazing experience with Sanjay sir he is really amazing teacher who guide every student in his own style with some fantastic example. Thank you so much sir. "
Vaishnavi Patrikar
"Very patient, kind and friendly teacher. Always tried to listen what ever the doubts I had and always given a best solution for it. "
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
Want to learn from Sanjay Singh?
Share this Profile
Recommended Profiles
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.
View this Course
0
Azadpur Phase 3, Delhi 
