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

Vikas Chauhan
28/01/2017 0 1

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.

1. Vlookup
2. If
3. Iferror
4. Sum
5. Count
6. Sumif
7. Countif
8. CountA
9. Index
10. Match
11. Left
12. Right
13. Mid
14. Trim
15. Clear
16. Len
17. Iserror
18. Subtotal
19. Sumproduct
20. Search
21. Find
22. Proper
23. Upper
24. Lower
25. Sumifs
26. Countifs
27. Max
28. Min
29. Choose
30. Hlookup

Thanks

0 Dislike

A

Abdulraffay | 24/03/2021

thanks

## Other Lessons for You

What is a Dashboard?
Introduction There are many different ideas of what a dashboard is. This article will clearly define it along with other presentation tools. In article, What is BI? - A Business Intelligence Primer, it...

Learning excel complex function by using simple steps
Step 1: Understand and practice the individual excel functions thoroughly Step 2: Split the problem statement into N number of small pieces. Step 3: Use individual functions to solve the small piece...

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

Chart
A chart is a set of coordinates When you make a chart you start with an empty, two-dimensional space, a vertical dimension (y) and a horizontal dimension (x) . You also have a data source. Your job is...

Hide Duplicate Values & Apply Borders Using Conditional Formatting
Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

### 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

X

### 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