MS Office Software Training Fees

Estimated Fees in India

₹ 2,500 to ₹ 5,000 per month

Find MS Office Software Training Fees in your locality

Please select a locality

or Get Free Quotes*

* Tutors will contact you with custom quotes as per your need

Estimated fees for MS Office Software Training in

  • LOCALITIES FEE RANGE

Find Tutors in

Map View

Estimated fees in

Find Tutors in

Estimated fees for MS Office Software Training in top cities

Click for more

₹ 3,000 to ₹ 5,000

Click for more

₹ 5,000

Click for more

₹ 100 to ₹ 5,000

Click for more

₹ 3,700 to ₹ 5,000

Click for more

₹ 3,000 to ₹ 3,300

Click for more

₹ 2,500 to ₹ 6,000

How UrbanPro works

Post your requirements or browse our professional network

Get customized quotes and responses for your learning requirement

Choose & Connect with the expert of your choice

Best MS Office Software Training experts to choose from

Post your requirements now

Lokesh

Umasankar Natarajan

Badatya Manjeet

iTech Analytic Solutions

SPC Computer Classes - ISO Certified Institute Jaipur

TLEAD COMPUTER EDUCATION

Best MS Office Software Training experts to choose from

Post your requirements now

Trending discussions on MS Office Software Training

Lesson Posted on 11 Sep IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

How Lookup function to replace Nested If statement

Kaustubh Chavan

-Experience of teaching. -Experience of handling multiple students at time. -Working in a MIS profile...

Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable level. Let's take an example of a lookup function's approach to solve the problem of Nested If... read more

Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable level.

Let's take an example of a lookup function's approach to solve the problem of Nested If statement.

Suppose I want to calculate commission on sales for a salesman.The % of the commission is tabulated in ascending order of the sales amount, that means. The % of the commission will increase as the sales amount rises.

For the demonstration purpose. I have designed the following commission table.

From To %
0 79999 0
80000 100000 0.5
100001 149999 0.6
150000 199999 0.65
200000 249999 0.7
250000 299999 0.75
300000 349999 0.8
350000 399999 0.9
400000 999999999999 0.95

 

According to the above table. If sales figure is from 80000 to 100000, the salesperson will get 0.5% of commission on the sales amount, and the person who has credited a whopping sales amount of 400000 and above will get the commission of 0.95%

This table has multiple conditions so naturally Nested if formula comes in mind where we need to test various states using various if statement. Let us study the use of Nested If statement

 

 

As you can see the nested if statement becomes pretty lengthy and cumbersome to write.

 

So let solve the above issue using Lookup function.

As you can see in the above image, we have used the lookup function. The sales person Tom has credited a sales amount of Rs.272840/-.In our table, the amount falls in the range of 250000 to 299999 and % against this range is 0.75.

So here is the syntax of LOOKUP function.

1)LOOKUP( value, lookup_range, [result_range] )
2)LOOKUP( value, array )


We will take the second formula.

Our Lookup table that is the array part of the formula will be taken by commission table ranging from F2 TO H10 and will be locked by $ Dollar Sign, you can see in the above image.


While the value part of the formula will be taken by the sales achieved by the salesperson that is cell B2

After inserting the formula, we get the outcome.

Just drag the formula down.

This way we can replace Nested If statement with Lookup function.

 

read less
Comments
Dislike Bookmark

Lesson Posted on 11 Sep IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

How Lookup function to replace Nested If statement

Kaustubh Chavan

-Experience of teaching. -Experience of handling multiple students at time. -Working in a MIS profile...

Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable level. Let's take an example of a lookup function's approach to solve the problem of Nested If... read more

Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable level.

Let's take an example of a lookup function's approach to solve the problem of Nested If statement.

Suppose I want to calculate commission on sales for a salesman.The % of the commission is tabulated in ascending order of the sales amount, that means. The % of the commission will increase as the sales amount rises.

For the demonstration purpose. I have designed the following commission table.

From To %
0 79999 0
80000 100000 0.5
100001 149999 0.6
150000 199999 0.65
200000 249999 0.7
250000 299999 0.75
300000 349999 0.8
350000 399999 0.9
400000 999999999999 0.95

 

According to the above table. If sales figure is from 80000 to 100000, the salesperson will get 0.5% of commission on the sales amount, and the person who has credited a whopping sales amount of 400000 and above will get the commission of 0.95%

This table has multiple conditions so naturally Nested if formula comes in mind where we need to test various states using various if statement. Let us study the use of Nested If statement

 

 

As you can see the nested if statement becomes pretty lengthy and cumbersome to write.

 

So let solve the above issue using Lookup function.

As you can see in the above image, we have used the lookup function. The sales person Tom has credited a sales amount of Rs.272840/-.In our table, the amount falls in the range of 250000 to 299999 and % against this range is 0.75.

So here is the syntax of LOOKUP function.

1)LOOKUP( value, lookup_range, [result_range] )
2)LOOKUP( value, array )


We will take the second formula.

Our Lookup table that is the array part of the formula will be taken by commission table ranging from F2 TO H10 and will be locked by $ Dollar Sign, you can see in the above image.


While the value part of the formula will be taken by the sales achieved by the salesperson that is cell B2

After inserting the formula, we get the outcome.

Just drag the formula down.

This way we can replace Nested If statement with Lookup function.

 

read less
Comments
Dislike Bookmark

Answered on 30 Aug IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Which is the best Excel course training provider in India?

S M Ejaz

Tutor

You can contact me on my mobile or whatsapp seven four zero six six eight three three zero six . I am MS-Excel trainer. i provide on-line and home tuition by reaching students home for MS-Excel course.
Answers 2 Comments
Dislike Bookmark

Join Discussions

Post your Requirement

Connect with the best tutors or institutes

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Please enter the Pin Code.

Which location would you prefer for MS Office Software Training?

Please select at least one option from Class Location.

By signing up, you agree to our Terms of Use and Privacy Policy.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

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