true

Learn Microsoft Excel Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Basic EXCEL Tips

Kshitij Agrawal

08/11/2016 0 0

Learn Use of MAX function in EXCEL:

Penalty of Rs. 2% or Minimum Rs. 100

Amount	Penalty	Formula
Rs 1000	200	+MAX(1000*2%,100)
Rs 400	100	+MAX(400*2%,100)

0 Like 0 Dislike

Follow 0

Other Lessons for You

Conditional formatting with formulas

Conditional formatting quickly formats information in a spreadsheet. But sometimes the biult in rules are not enough. Adding your own formula to a conditional formatting rule gives it a power to help you do custom things.

Sharad Singh

0 0

How to Remove Duplicates from your data

Larger data sets tend to have duplicate content. You may have a list of multiple contacts in a organization and only want to see the number of organization you have or you have multiple rows of same type...

Kavita V.

0 0

How to add bullets Point in MS-EXCEL

There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps: 1. Select the range where you want to apply the bullets.2. go to formate cell ==> Custom Formate.3....

Pradeep Agrawal

0 0

Learning Tip

1. The foundation: a productivity systemLet’s face it, without a solid foundation there is no way you can expect to build new skills and form new habits. My first tip therefore is to adopt a productivity...

Pankaj Kumar Jha

0 0

Pivot Tables

Pivot table and a very powerrfull feature in Ms-Excel . it is used to reorganize data in a spreadsheet. They won't change the data that you have, but they can sum up values and compare different information...

Kavita V.

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

What are the benefits of using Excel in business?

8 Answers

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything...

11 Answers

What is Microsoft Excel?

5 Answers

How to write square in excel?

9 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.