Bagmugaliya, Bhopal, India - 462026
Super Tutor
Certified
311
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
Top 10 in Microsoft Excel Training 2024
Microsoft Excel Training
Top 100 tutors of 2024
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
Advanced Excel, Excel Macro Training, Basic Excel
Top 10 in Microsoft Power BI 2024
Microsoft Power BI
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 440 reviews
Manjunath Veerayya javali
Microsoft Excel Training
"Sanjay sir is very dedicated, sincere and has immense knowledge in microsoft excel. I had great learning experience under him. His way of teaching is very immersive and innovative. After this learning I am able to implement many features like pivot , graphs vlookup, nested ifs and many other features in my day to day to work. I would really recommend sanjay sir for trainings. Thank you very much for all your support and time. "
Ritesh Baxria
Microsoft Excel Training
"Very nice experience with sir. Very easy to understand all topic cover by sir. Thank you sir. "
Ruchi Patel
Microsoft Excel Training
"First of all thank you very much for our Trainer Mr. Sanjay Singhji who have taught us which were clearly understandable and I have thoroughly enjoyed this training it's very useful. "
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. "
Answered on 16/07/2024 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/01/2024 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.