true

Learn Microsoft Excel Training from the Best Tutors

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

Search in

Top 30 formulas in Excel

28/01/2017 0 0

Generally, we are only use maximum "30 formulas" in our day to day routine. let's explore with below formulas and let me know which one is your favorite.

Vlookup
If
Iferror
Sum
Count
Sumif
Countif
CountA
Index
Match
Left
Right
Mid
Trim
Clear
Len
Iserror
Subtotal
Sumproduct
Search
Find
Proper
Upper
Lower
Sumifs
Countifs
Max
Min
Choose
Hlookup

Thanks

0 Like 0 Dislike

Follow 3

Abdulraffay | 24/03/2021

thanks

1 0

Other Lessons for You

VBA Function - RIGHT

RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

Karthik Dale

0 0

Functions in Advanced MS Excel

Introduction to Advanced Excel: Basic Understanding Menu and Toolbar, Introduction to a different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References,...

Sla Consultants India

0 0

How to create drop down function in Excel?

Many times while working you would require to create drop down values in excel. Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create...

Ayush Agarwal

1 0

How to add a diagonal line in a cell in MS EXCEL

Many a times we feel the need to use a cell to act as headers for data flowing in two directions -- Rows and columns and for this purpose we may want to add a diagonal line to accomodate the two headers...

Manoj Kumar

0 0

Use of Indirect Function

I would like to share my experience of how Indirect formula helped me in my recent project. I was working with some report which was connected to a large database in excel, so whatever changes I made to...

Kaustubh Chavan

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

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

11 Answers

Are there any VBA tutors around Secunderabad?

11 Answers

How can I create an organization chart in MS Excel?

5 Answers

What are the 5 most essential excel tools to master?

6 Answers

Is MS Excel very easy to learn?

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