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
Sweta Pandey
"Best trainer I have ever met. I got this training very useful. He made excel very easy to learn. Thank you sir. "
Hardeep Singh
Microsoft Excel Training
"Training was fruitful nd we have learn many formulas of Excel which is very useful to our routine work. "
Surender
Microsoft Excel Training
"Very well and toughly explained by you . Earlier we were not able to use excel properly but now we fully trained. Thanks again Sir. "
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. "
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.