Hemant Parmar

Dahisar West, Mumbai, India - 400103

Hemant Parmar photo

Platinum

Hemant Parmar

Corporate Excel Trainer - 20Years

Dahisar West, Mumbai, India - 400103.

11 Students taught

5.0

UrbanPro Rating

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.

Overview

I have used Excel since 1998 while working in multi-national companies - TechData, Westcon Group & Logicom. I have been using Excel for simplifying and automating work, reporting and data analysis.

Since 2004 I have trained many-
>> new employees in Excel so that they are ready to work smart.
>> existing employees to automate work and analyse data using excel.

My training will help you:
1. Learn from BASICS TO ADVANCED LEVEL using real excel files used by companies.
3. Learn how to use Excel to make better decisions, which can help you grow in your job.

I also offer ONE YEAR ONLINE SUPPORT so that all your doubts or problems in Excel can be solved.

Languages Spoken

Gujarati Mother Tongue (Native)

English Proficient

Hindi Proficient

Marathi Proficient

Education

VJTI 1990

Bachelor of Engineering (B.E.)

Address

Dahisar West, Mumbai, India - 400103

Verified Info

ID Verified

Education Verified

Phone Verified

Email Verified

Facebook Verified

Demo Class

Yes, not charged

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Microsoft Excel Training classes Overview

Microsoft Excel Training classes

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Microsoft Excel Training classes

20

Teaches following Excel features

Advanced Excel, Excel Macro Training, Basic 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.

Gallery (21)

Introduction to my Excel Cours...

Some Charts in Excel

Sales Forecast in Excel

Analyzing School Grade Sheet in...

Analyzing Inventory Report in ...

Creating impressive pie chart in...

Managing Product Sales Report in...

Creating Professional Quote in...

Managing Receivables Report in...

Creating complex Sales Incentive...

Creating and Analyzing Territory...

Creating complex charts and graphs...

Presenting to Analyze sales report...

+12 Photos

Documents (3)

Productivity with Excel Course...

Brochure - Excel Basics Course

Brochure - Advanced Excel Cour...

Reviews (11)

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

5.0 out of 5.0 11 reviews

5.0/511
M
25 Aug, 2019

Ms . asharani shinde attended Microsoft Excel Training

"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.

P
01 Aug, 2019

Pallavi Kajrolkar attended Microsoft Excel Training

"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.

D
01 Aug, 2019

"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.

H
01 Aug, 2019

"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.

Have you attended any class with Hemant? Write a Review

FAQs

1. Which classes do you teach?

I teach Microsoft Excel Training Class.

2. Do you provide a demo class?

Yes, I provide a paid demo class.

3. How many years of experience do you have?

I have been teaching for 20 years.

Answers by Hemant (18)

Answered on 14/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

Why is data validation disabled in Excel?

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... ...more

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

Answers 1 Comments
Dislike Bookmark

Answered on 14/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel 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... ...more

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

Answers 3 Comments
Dislike Bookmark

Answered on 10/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How can I convert a PDF to Word?

Save the PDF file in a folder. Then right click on it in the folder view and select "Open with" and click on MS Word. rgds hemant parmar
Answers 1 Comments
Dislike Bookmark

Answered on 10/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How do I change the dates from month to month when typing out a graph report etc on Microsoft Excel without... ...more
How do I change the dates from month to month when typing out a graph report etc on Microsoft Excel without having to type every day in individual..I know there's a way but can't for the life of me figure it out?

Hi, Your question is not very clear. If you give an example then may be I can help. However, you may try to use =Today() function which inserts todays date in the set format, in a cell and then you can have formula in rest of the date cells. rgds hemant parmar
Answers 1 Comments
Dislike Bookmark

Answered on 10/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How do you add fonts to Microsoft Word?

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... ...more

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

Answers 1 Comments
Dislike Bookmark

HemantDirections

x
Microsoft Excel Training classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Microsoft Excel Training classes

20

Teaches following Excel features

Advanced Excel, Excel Macro Training, Basic 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.

Answers by Hemant (18)

Answered on 14/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

Why is data validation disabled in Excel?

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... ...more

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

Answers 1 Comments
Dislike Bookmark

Answered on 14/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel 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... ...more

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

Answers 3 Comments
Dislike Bookmark

Answered on 10/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How can I convert a PDF to Word?

Save the PDF file in a folder. Then right click on it in the folder view and select "Open with" and click on MS Word. rgds hemant parmar
Answers 1 Comments
Dislike Bookmark

Answered on 10/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How do I change the dates from month to month when typing out a graph report etc on Microsoft Excel without... ...more
How do I change the dates from month to month when typing out a graph report etc on Microsoft Excel without having to type every day in individual..I know there's a way but can't for the life of me figure it out?

Hi, Your question is not very clear. If you give an example then may be I can help. However, you may try to use =Today() function which inserts todays date in the set format, in a cell and then you can have formula in rest of the date cells. rgds hemant parmar
Answers 1 Comments
Dislike Bookmark

Answered on 10/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How do you add fonts to Microsoft Word?

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... ...more

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

Answers 1 Comments
Dislike Bookmark

Enquire

Load More

Hemant Parmar describes himself as Corporate Excel Trainer - 20years. He conducts classes in Microsoft Excel Training. Hemant is located in Dahisar West, Mumbai. Hemant takes at students Home and Regular Classes- at his Home. He has 20 years of teaching experience . Hemant has completed Bachelor of Engineering (B.E.) from VJTI in 1990. HeĀ is well versed in English, Hindi, Gujarati and Marathi. Hemant has got 11 reviews till now with 100% positive feedback.

Share this Profile

Recommended Profiles

Vinay R. Shirodkar

Vinay R. Shirodkar photo Malad East, Mumbai

Roshana G.

Roshana G. photo Nerul, Mumbai

Jay Prakash Bajaj

Jay Prakash Bajaj photo Kandivali East, Mumbai

Jignesh Parmar

Jignesh Parmar photo Andheri West, Mumbai

Aakash Jasani

Aakash Jasani photo Dahisar West, Mumbai

Manu Singhal

Manu Singhal photo Sarjapur Road, Bangalore

X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Hemant

Let Hemant know you are interested in their class

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more