UrbanPro
true

Master Excel - Basics to Advanced

LIVE
13 reviews
16 Hours

Course offered by Hemant Parmar

13 reviews
Required Skills : No previous knowledge of Excel is required. This course is good for beginners. Course Content: Fundamentals of Excel Basic Calculations in Excel Various Formatting methods Fetching data from within or outside the file Using combination of VLOOKUP & IF functions Alternative to VLOOKUP function â?? INDEX & MATCH Combo Writing complex formula with multiple conditions Using a combination of IF, AND & OR functions Using nested IF functions Using IFS function VLOOKUP v/s Nested IF v/s IFS Correct sequencing of logic in Nested IF / IFS Using COUNTIF, COUNTIFS, SUMIF & SUMIFS function & more depending on student's profile Data Handling & Analysis Using Sorting function Using Filters in different ways Using Filters with logical conditions Using Conditional Formatting methods Using Conditional formatting along with formula Reporting & Data Analysis Creating various types of Charts Deciding the type of Chart to be used Data management prior to preparing the chart Creating complex combination charts Analyzing Data using Charts Creating Pivot Tables Managing data for pivot table Different layouts of a pivot table Analyzing Pivot tables from different perspective Securing your data, format and the entire file With the advanced excel techniques you will learn in this course, you will be able to prepare any other complex excel file.

Gallery (22)

Intro Video

+15 more

About the Trainer

Hemant Parmar picture

5 Avg Rating

13 Reviews

12 Students

4 Courses

Hemant Parmar

Bachelor of Engineering

20 Years of Experience

I have used Excel for last 22 years in automating the work, reporting and data analysis, in multinational companies.
I have trained since 2004 new employees for the above so that they are ready to perform at their job.
I have taught existing employees to work in a smarter way to analyse data such that they reduce the manual work and automate the same using excel. This way they get the necessary information and more time towards achieving their targets.

Students also enrolled in these courses

LIVE
7 reviews

Course offered by Hitesh Chauhan

4 reviews
LIVE
53 reviews
12 Hours

Course offered by Mr. Awesh Bhornya

63 reviews
LIVE
3 reviews

Course offered by Sankalp Korde

29 reviews
LIVE

Course offered by Salman M Khairaz

781 reviews

Reviews (13)

5 out of 5 13 reviews

Hemant Parmar https://p.urbanpro.com/tv-prod/member/photo/5696874-small.png Dahisar West
5.00513
Hemant Parmar
M

Microsoft Excel Training

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

Hemant Parmar
M

Microsoft Excel Training

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

Hemant Parmar
M

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.

Hemant Parmar
P

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.

View All
Have you attended any class with Compufield?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

5 out of 5 13 reviews

Hemant Parmar https://p.urbanpro.com/tv-prod/member/photo/5696874-small.png Dahisar West
5.00513
Hemant Parmar
M

Microsoft Excel Training

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

Hemant Parmar
M

Microsoft Excel Training

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

Hemant Parmar
M

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.

Hemant Parmar
P

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.

Hemant Parmar
D

Microsoft Excel Training

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

Hemant Parmar
H

Microsoft Excel Training

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

Hemant Parmar
R

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.

Hemant Parmar
S

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

Hemant Parmar
S

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

Hemant Parmar
D

Master Advanced Excel Skills

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

Hemant Parmar
S

Microsoft Excel Training

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

Hemant Parmar
S

Microsoft Excel Training

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

Hemant Parmar
M

Microsoft Excel Training

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

Have you attended any class with Compufield?

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.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Master Excel - Basics to Advanced by Hemant Parmar

Hemant Parmar picture
LIVE
(13 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Master Excel - Basics to Advanced by Hemant Parmar

Hemant Parmar picture
LIVE
(13 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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