true

LIVE
13 reviews
8 Hours

Course offered by Hemant Parmar

13 reviews

Required Skills:Â You MUST have the basic knowledge of excel, e.g. Basic formula writing for simple calculations like addition, subtraction, multiplication, division, percentage & sum. You should know various types of formatting methods and page layouts.Â

Â

Course Content:

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

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

Â

Notes for Student
Excel will be taught using real life Excel files.
These Excel files will be provided to students.
It would be good if student can get own laptop with Excel, otherwise student can learn using Instructor's laptop.

Gallery (22)

Intro Video

+15 more

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

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

Thanks a lot Mehul ji for your review.

Hemant Parmar
M

"I had a wonderful experience being trained by Hemant. Also I learnt a lot of new things about excel. "

Hemant Parmar
M

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

Thank you Ms. Asharani for your review.

Hemant Parmar
P

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

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

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

Thanks a lot Mehul ji for your review.

Hemant Parmar
M

"I had a wonderful experience being trained by Hemant. Also I learnt a lot of new things about excel. "

Hemant Parmar
M

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

Thank you Ms. Asharani for your review.

Hemant Parmar
P

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

Thank you Pallavi for your review.

Hemant Parmar
D

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

Thank you Divya for writing a review.

Hemant Parmar
H

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

Thank you Harsh for writing a review.

Hemant Parmar
R

"Great experience learning excel with live examples. Session was very interactive and well designed content on the course. "

Thank you Rajeev for the review.

Hemant Parmar
S

"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

"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

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

Thanks a lot Dhavalji for your words of appreciation.

Hemant Parmar
S

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

Thanks a lot for your review Sharanya.

Hemant Parmar
S

"Depth of knowledge was good. To the point approach was there. Kept the crowd engaged.Was crisp enough."

Thank you Sejal for your review.

Hemant Parmar
M

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

Thank you Miten for writing a review of my training.

Have you attended any class with Compufield?

1500/1500

Certified

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

Different batches available for this Course

You have successfully registered

Master Advanced Excel Skills by Hemant Parmar

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 Advanced Excel Skills by Hemant Parmar

LIVE
(13 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Update

Please enter 10 digit phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend