Dahisar West, Mumbai, India - 400103
Verified 
12
Details verified of Hemant Parmar✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
2 Students Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
20
Teaches following Excel features
Basic Excel, Excel Macro Training, Advanced Excel
Teaching Experience in detail in Microsoft Excel Training classes
I have been training company staff from 2004 onwards. I have taught how to use Excel in preparing professional documents like: Quotations, quotations with cost sheet, price lists, promotion price lists, sales incentive schemes, inventory report, receivables report, sales report, etc. You can use simple and complex formula to simplify your work and reduce manual calculations. I have also taught how to do data analysis using various Excel functions like conditional formatting, sorting, pivot tables and charts. If you want to learn all of the above, contact me.
5 out of 5 13 reviews
Mehul Desai
"It was great learning. The training was well planned & executed by Mr. Hemant & it gave us detail information of excel & vast applications of excel in all fields of business from maintaining Accounts to Marketing. "
Reply by Hemant
Thanks a lot Mehul ji for your review.
Mandar Karnik
"I had a wonderful experience being trained by Hemant. Also I learnt a lot of new things about excel. "
Reply by Hemant
Thanks Mandar for your review.
Ms . asharani shinde
"This course is really very helpful and easy to learn and understand. Every session is well organised and explained. I am really very much thankfull to Mr. Parmar sir and would like to suggest everyone to enjoy working with excel with such nice training. "
Reply by Hemant
Thank you Ms. Asharani for your review.
Pallavi Kajrolkar
"It was a great experience to learn excel. Really like table concept. It was good and i will use it as reference in the future. "
Reply by Hemant
Thank you Pallavi for your review.
Divya
"This training was really helpful in understanding of some of the cool things that excel can do and I could make use of everything I've learned. Clear & helpful presentation. "
Reply by Hemant
Thank you Divya for writing a review.
Harsh
"A very good and excellent training,I got to learn many things which I was not knowing,The main thing that was Hemant sir was teaching excel with live examples so it was very easy to learn and I suggest that the person to teach Excel in proper way is Hemant Sir. "
Reply by Hemant
Thank you Harsh for writing a review.
Rajeev Deshwaria
Getting Started with Excel Basics
"Great experience learning excel with live examples. Session was very interactive and well designed content on the course. "
Reply by Hemant
Thank you Rajeev for the review.
Sharanya Maitra
Getting Started with Excel Basics
"The training program was very informative. As a beginner I was able to grasp the concepts easily as it was explained very well. "
Sharanya Maitra
Getting Started with Excel Basics
"The training program was very informative. As a beginner I was able to grasp the concepts easily as it was explained very well. "
Dhaval B doshi
"I am into Financial Advisory business & was looking for some good learning to master my skill in excel . I was introduced to sir Hemant Parmar of Fair value academy through my close friend .The trainer is very much specialised in excel & the training / workshop was very informative & conducted in a lucid way . Also i got 1 year free support for my queries round the clock . The after sales service is prompt . I highly recommend Sir Hemantji's Excel training for anyone who wants to lay a hand on excel sheet from basic course to master course. "
Reply by Hemant
Thanks a lot Dhavalji for your words of appreciation.
Sharanya Maitra
"The training program was very helpful. As a beginner I was able to understand the simple concepts as well as the advance formulas. It was explained in an interactive way which helped to understand it better. "
Reply by Hemant
Thanks a lot for your review Sharanya.
Sejal Chawda
"Depth of knowledge was good. To the point approach was there. Kept the crowd engaged.Was crisp enough."
Reply by Hemant
Thank you Sejal for your review.
Miten Chawda
"Hemant conducted basic and advanced excel training session at our office for our staff. The training was well received by my team. The useful tools, use of formula were very explained and the team has implemented same in day to day use. "
Reply by Hemant
Thank you Miten for writing a review of my training.
Answered on 14/12/2018 Learn IT Courses/MS Office Software Training
Data validation restricts a user to enter values in a cell based on the rule applied by the owner of the sheet. This is used only for specific purposes for example,
in Forms,
in certain types of reports where you want standardised values to be entered in a range or a column
to restrict user to enter specific range of date, values, text and so on.
Due to above reasons the data validation function can not be enabled on the entire worksheet by default. It needs to be used for specific cells or range and each cell or range may have different rule of data validation.
hope this helps.
hemant parmar
Answered on 14/12/2018 Learn IT Courses/MS Office Software Training
It means the value you are looking for in the first column of the reference table is not available.
So for example: Lets say you are trying to search for "XYZ" in column B and pick some value against it in column F.
#N/A error will appear if the value XYZ does not exist in Column B
OR If it exists in Column B then in your VLOOKUP formula you haven't selected column B as the first column
Are you aware of Index and Match function combination methods. Try it out, you will be able to overcome some limitations of VLookup.
hope this helps
hemant
Answered on 10/12/2018 Learn IT Courses/MS Office Software Training
Answered on 10/12/2018 Learn IT Courses/MS Office Software Training
Answered on 10/12/2018 Learn IT Courses/MS Office Software Training
Download the required font. Typically you will get a zip file.
How to use:
1. Save the zip file in any folder of your choice.
2. Unzip the file (right click and click on “extract all” and click on OK)
3. Open the unzipped folder.
4. Copy and paste all .ttf file from here to the below folder on your PC.
c:/Windows/fonts/
Now you can use these fonts in all your office applications(word, excel, power point).
hope this helps
hemant parmar
Want to learn from Hemant?
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
Andheri West, Mumbai 
