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

Excel Tip: Fill the blank cells using Formula

Naga Satyanarayana Anantapalli

0 0

VLOOKUP and LIST Creation Explained

.) This table is in the range A1:D4. You want to find the salary of employee with ID 102. Excel =VLOOKUP(102, A1:D4, 4, FALSE) 102: The Employee ID (your lookup_value). A1:D4: The table containing...

Ganesh S.

0 0

Create a Grading in Excel using Formulas (All versions)

Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

Bhavna Philipose

0 0

Some Excel Functions

You need to know about these following functions which are based on Microsoft Excel 2010.1. Speedily Move and Copy Data in Cells:-If you want to move one column of data in a spreadsheet, the fast way...

Icreative Solution

0 0

Difference between Find and Search Function in excel

In excel there are two functions which are taking same arguments and return type. SEARCH() --> Search a text within text, Case insensitive Example: Search("t","Management Team") and Search("T","Management...

Umasankar Natarajan

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

I am looking to learn immediately Advanced Excel & VBA Macros. Please provide the Institute contact details...

36 Answers

How do I perform the basic functions of Microsoft Excel, such as Open, Save, and Print?

5 Answers

What are some cool Microsoft Excel tricks?

8 Answers

Is Excel online coaching much costlier than excel coaching classes?

10 Answers

Excel formulas in advance level?

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