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

Learning Microsoft Excel

All Excel courses that are currently being offered online as well as classroom sessions have a lot in common – In fact they are all the same thing. Beginner, Intermediate, Advanced, VBA etc. The...

Anindya Kumar G.

30 0

VBA Function -

Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

Naga Satyanarayana Anantapalli

0 0

Avoid VLookup function in excel, instead use index and match combination

Avoid VLookup function in excel, instead use index and match combination. Reason: 1) Index and Match combination will be faster than Vlookup function. In order to proof this you can create 1000 rows...

Umasankar Natarajan

0 1

How to install Analysis ToolPak in Excel

The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. To load the Analysis ToolPak add-in, execute the following steps. 1....

Dheeraj Kushwaha

1 0

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 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

which is the best college or institute for Data analysis course certificate with Fresher placement support in pune?

5 Answers

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. ...

9 Answers

Is Advanced Excel Training necessary?

7 Answers

What is use of VBA? Can you explain it?

5 Answers

How do I type new line inside a single cell? I don't want to go to another cell but there should be a new line inside 1 cell. Please help.

36 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

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.