Top Excel Formulas Every Beginner Should Learn (With Examples)

Friends, if you have just started using Excel for your office work, college project, or even for managing your shop accounts, you must have felt this — so many rows, so many columns, and so many buttons, but you don’t know where to start. Don’t worry, this is normal for every beginner.

The good news is, you don’t need to learn 100 formulas to work confidently in Excel. Just by knowing the top Excel formulas, you can handle almost 90% of your daily work — whether it is calculating totals, checking pass/fail results, or finding data from a big list.

In this article, we will go through the top 10 Excel formulas that every beginner should know, with simple syntax and easy examples. By the end of this post, you will be able to open any Excel sheet given by your boss or teacher, and actually understand what to do with it.

top excel formulas

Why Should You Learn Top Excel Formulas?

In India, Excel is used everywhere — in offices, schools, small businesses, and even at home for budget planning. If you know the right formulas, your work becomes faster, and chances of mistakes also become very low.

Whether you are a student preparing for your first job, a working professional, or running your own small business, these formulas will save you a lot of time and effort. Once you practice them 2-3 times, you will not forget them.

Let’s explore the Top Excel Formulas every beginner should know.

Also Read: Computer Shortcut Keys — Powerful Shortcuts Every Beginner Must Know

Top 10 Excel Formulas With Examples

1. SUM — Add Numbers in One Shot

The SUM formula is the first formula every beginner learns. It simply adds all the numbers in a given range.

Syntax: =SUM(number1, [number2], ...)

Example: Suppose cell A1 to A10 has numbers like 10, 20, 30 and so on up to 100. If you type =SUM(A1:A10), Excel will immediately give you the total — 550 — without you adding it manually.

2. AVERAGE — Find the Average Value

AVERAGE formula calculates the mean value of a set of numbers. Very useful for finding average marks, average sales, or average expenses in a month.

Syntax: =AVERAGE(number1, [number2], ...)

Example: Using the same numbers from B1 to B10, =AVERAGE(B1:B10) will give you 55, which is the average of that range.

3. COUNT — Count How Many Numbers Are There

COUNT tells you how many cells in a range actually have numbers in them. It will simply ignore empty cells or cells with text.

Syntax: =COUNT(value1, [value2], ...)

Example: =COUNT(C1:C10) will check the range and give 7, if only 7 out of 10 cells have numbers.

4. MAX — Find the Highest Number

MAX formula picks out the biggest number from a range. Good for finding the highest sale, highest marks, or top performer in a list.

Syntax: =MAX(number1, [number2], ...)

Example: =MAX(D1:D10) will go through the range and give you 42, if that is the largest value present.

5. MIN — Find the Lowest Number

MIN works exactly opposite to MAX. It finds the smallest value from a range. Useful for finding the lowest price, lowest stock, or minimum marks.

Syntax: =MIN(number1, [number2], ...)

Example: =MIN(E1:E10) will return 9, if that’s the smallest number in that column.

6. IF — Excel’s Decision-Making Formula

The IF formula is one of the most powerful and most used formulas. It checks one condition, and based on whether it is true or false, gives different results.

Syntax: =IF(logical_test, value_if_true, value_if_false)

Example: =IF(A1>=50, "Pass", "Fail") checks the value in A1. If A1 has 75, since 75 is greater than or equal to 50, the formula will show “Pass”.

7. VLOOKUP — Search and Fetch Data

VLOOKUP is used to search for a value in the first column of a table, and bring back matching data from another column in the same row. This is very commonly used to fetch price, name, or any detail from a big data sheet.

Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Example: Suppose F1 has “ID001”, and your table has IDs in column A, names in column B, and price in column C. The formula =VLOOKUP(F1, A2:C10, 3, FALSE) will search for “ID001” and bring back the price — ₹5000 — from the third column.

8. CONCATENATE — Join Text Together

CONCATENATE (or simply using the & symbol) joins text from two or more cells into one single cell. Very useful for combining first name and last name, or building full address from separate columns.

Syntax: =CONCATENATE(text1, [text2], ...) or simply =text1 & " " & text2

Example: If A1 has “Rajesh” and B1 has “Kumar”, then =A1 & " " & B1 will give the result “Rajesh Kumar” in one cell.

9. SUMIF — Add Numbers Based on a Condition

SUMIF adds numbers, but only those which match a particular condition you set. Useful for calculating total sales above a certain amount, or total expense in one category.

Syntax: =SUMIF(range, criteria, [sum_range])

Example: =SUMIF(C2:C10, ">50", D2:D10) checks column C for values greater than 50, and adds up the matching rows from column D, giving a result like ₹250.

10. COUNTIF — Count Cells That Match a Condition

COUNTIF counts only the cells which match a specific condition, instead of counting everything. Good for checking how many times a particular item or name appears in your list.

Syntax: =COUNTIF(range, criteria)

Example: =COUNTIF(E2:E10, "Apples") will check the range and return 2, if “Apples” appears exactly two times.

One Important Tip Before You Start

When you copy a formula to other cells, Excel automatically changes the cell reference. But sometimes you want one particular cell to stay fixed, even after copying. For this, use the dollar sign — like $A$1. This is called absolute reference, and once you understand this trick, half of your formula confusion will go away.

Common Mistakes Beginners Make

  • Forgetting the “=” sign at the start — without this, Excel treats your formula as plain text.
  • Mixing up comma and semicolon — depending on your Excel language setting, you may need to use semicolon (;) instead of comma (,).
  • Not using absolute reference when copying formula, which gives wrong result in other cells.
  • Selecting wrong range — always double-check the cells you are referring to before pressing Enter.

Once you keep these small points in mind, working with the top Excel formulas becomes very easy.

Final Words

You don’t have to memorise every single function Excel offers. Just these 10 formulas — SUM, AVERAGE, COUNT, MAX, MIN, IF, VLOOKUP, CONCATENATE, SUMIF, and COUNTIF — are enough to handle most of your daily Excel work as a beginner. Practice each one on a small sheet first, and slowly it will become second nature to you.

Save this article, bookmark it if needed, and next time someone gives you a messy Excel sheet, you will exactly know where to start from. Learning these Top Excel Formulas will improve your productivity.


Frequently Asked Questions (FAQs)

1. What are the Top Excel Formulas for beginners? SUM, AVERAGE, COUNT, IF, and VLOOKUP are the five most important ones. Just these five can handle a large part of your daily Excel work.

2. Do I need to remember the exact syntax of each formula? Not really. As soon as you start typing a formula, Excel shows a small tooltip with the syntax, so you can refer to it while working.

3. What is the difference between COUNT and COUNTIF? COUNT simply counts how many cells have numbers in them. COUNTIF counts only the cells that match a particular condition, like a specific name or value range.

4. Why is my VLOOKUP formula showing an error? This usually happens when the value you are searching for is not present in the table, the column index number is wrong, or your range does not include the column you are trying to fetch data from.

5. Will these formulas work in Google Sheets also? Yes, all 10 formulas mentioned in this article work the same way in Google Sheets, with little to no change in syntax.

6. What is absolute reference and when should I use it? Absolute reference (written with $ sign, like $A$1) keeps a cell reference fixed when you copy the formula to other cells. Use it whenever you don’t want a particular cell or range to change while copying. These Top Excel Formulas will help you work faster and more efficiently.

Related guides

Share this post:
WhatsAppFacebookXLinkedInTelegram
Scroll to Top