Top 10 Formulas to Learn in MS Excel: A Guide to the Must-Know Excel Formulas for Students

Microsoft Excel is one of the most useful tools students can learn today. It helps you organize data, calculate numbers, track assignments, and complete projects faster. Knowing the right Excel formulas can save time and improve accuracy in both academics and future jobs. 

In this guide, you will learn the top 10 Excel formulas every student should know, including SUM, AVERAGE, IF, VLOOKUP, and more. These formulas are easy to use and helpful for daily tasks like managing marks, budgets, and reports. 

Whether you are a beginner or just want to improve your Excel skills, these formulas will make your work simpler and more efficient. 

To build more practical digital skills and explore career-focused online learning, check out the online courses available at YourDegree. 

Top 10 Excel Formulas at a Glance 

Excel formulas help students complete calculations, organize information, and manage data more easily. Learning a few important formulas can improve speed and accuracy while working on assignments, reports, and daily tasks. 

Below is a quick overview of the top 10 Excel formulas every student should know: 

If you want to build advanced business, leadership, and analytical skills, explore the top online MBA courses and find the right program for your career goals. 

Formula 1: SUM

The SUM formula is used to add numbers together. It helps you quickly calculate totals in Excel. You can use it for a range of cells or selected values. It is one of the most basic formulas. 

Advantages: 

• Fast calculation of totals 

• Reduces manual errors 

• Works with large data 

• Easy to use 

Example: Add values from A1 to A5 → =SUM(A1:A5) 

Also Read: High-Paying Skills to Learn Online 

Formula 2: AVERAGE 

The AVERAGE formula finds the mean value of numbers. It adds all values and divides them by the count. It is useful for analyzing scores or performance. 

Advantages:

• Quick average calculation 

• Helpful for analysis 

• Works on large datasets 

• Easy to understand 
  
  

Example: Find average of B1 to B10 → =AVERAGE(B1:B10) 

Must Read: Future Jobs in Demand 

Formula 3: IF 

The IF formula checks a condition and gives a result based on it. If the condition is true, it shows one value. If false, it shows another value. It is useful for decision-making. 

Advantages:

• Supports logic-based results 

• Automates decisions 

• Flexible usage 

• Works with other formulas 
  
  

Example: If A1 is greater than 50, show Pass → =IF(A1>50, "Pass", "Fail") 

Related Article: Career Shift into Marketing or Finance 

Formula 4: VLOOKUP 

VLOOKUP is used to find data in a table. It searches for a value in the first column and returns a related value. It is useful when working with large datasets. 

Advantages:

• Saves time in searching 

• Quick data lookup 

• Useful for reports 

• Easy to apply 
  
  

Example: Find value of A2 in table B1 to D10 → =VLOOKUP(A2, B1:D10, 2, FALSE) 

Formula 5: HLOOKUP 

HLOOKUP works like VLOOKUP but searches horizontally. It looks in the first row of a table. Then it returns a value from a given row. 

Advantages:

• Useful for horizontal data 

• Quick lookup 

• Easy to use 

• Saves time 
  
  

Example: Search A1 in first row → =HLOOKUP(A1, B1:E5, 2, FALSE) 

Formula 6: COUNT 

COUNT formula counts cells that have numbers. It ignores text and empty cells. It is useful for numeric data tracking. 

Advantages:

• Counts only numbers 

• Simple and fast 

• Helps with data analysis 

• Works on a large range 
  
  

Example: Count numbers from A1 to A20 → =COUNT(A1:A20) 

Formula 7: COUNTA 

COUNTA counts all non-empty cells. It includes text, numbers, and symbols. It is useful when you want to count filled cells. 

Advantages:

• Counts all data types 

• Quick identification of entries 

• Easy to use 

• Good for reports 
  
  

Example: Count non-empty cells → =COUNTA(A1:A20) 

Formula 8: MAX 

The MAX formula finds the highest value in a range. It is useful for identifying top scores or maximum values. 

Advantages:

• Quick maximum value 

• Useful in analysis 

• Works on large data 

• Easy to apply 
  
  

Example: Find highest value → =MAX(A1:A10) 

Formula 9: MIN 

The MIN formula finds the smallest value in a range. It helps in identifying the lowest number. Useful in many data comparisons. 

Advantages:

• Finds lowest value quickly 

• Helps analysis 

• Simple to use 

• Works on large data 
  
  

Example: Find lowest value → =MIN(A1:A10) 

Formula 10: CONCAT 

CONCAT is used to join text from different cells. It combines multiple values into one. Useful for names, addresses, etc. 

Advantages:

• Joins text easily 

• Saves manual effort 

• Works with multiple cells 

• Simple to understand 
  

Example: Join first and last name → =CONCAT(A1, " ", B1) 

Conclusion 

Learning Excel formulas can help students work faster, stay organized, and improve accuracy in daily tasks. Formulas like SUM, AVERAGE, IF, VLOOKUP, and CONCAT make it easier to manage marks, reports, budgets, and other data. 

Even basic Excel skills can be useful in academics, internships, and future careers. By practicing these formulas regularly, students can build strong spreadsheet and data management skills with confidence.

If you want guidance on building practical digital and career skills, schedule a free counseling session with the experts and explore the right learning path for your future. 

FAQ’s 

1. What is a formula in Excel?

A formula in Excel is used to perform calculations on data in cells. It helps you add, subtract, or analyze numbers easily. Every formula starts with an equal (=) sign. Using formulas makes your work faster and more accurate. 

2. Why is the SUM formula important?

The SUM formula is important because it quickly adds numbers in a range. You do not need to calculate totals manually, which saves time. It also reduces the chance of errors in calculation. This formula is widely used in reports and data sheets. 

3. When should I use the AVERAGE formula?

You should use the AVERAGE formula when you want to find the mean of values. It is useful for calculating scores, marks, or performance data. It helps you understand trends in your data. This makes it easier to analyze results. 

4. What does the IF formula do?

The IF formula checks a condition and returns a result based on it. If the condition is true, it shows one value, and if false, another. It is very useful for decision-making tasks in Excel. You can use it for grading or logical tests. 

5. What is the difference between VLOOKUP and HLOOKUP?

VLOOKUP searches for values vertically in a column, while HLOOKUP searches horizontally in a row. Both formulas are used to find data in tables. They return matching values from another column or row. The choice depends on your data layout. 

6. Why do we use the COUNT formula?

The COUNT formula is used to count cells that contain numbers only. It ignores text and empty cells in a range. This helps you track how many numeric entries are present. It is useful for data analysis and reports. 

7. What is the use of COUNTA in Excel?

COUNTA counts all non-empty cells, including text and numbers. It is helpful when you want to know how many cells have any type of data. It gives a quick overview of filled entries. This is useful for managing large datasets. 

8. How does the MAX formula work?

The MAX formula finds the highest value in a range of cells. It is useful when you want to identify top values, like highest sales or marks. It saves time compared to checking data manually. It works well even with large datasets. 

9. What is the purpose of the MIN formula?

The MIN formula finds the smallest value in a dataset. It helps you quickly identify the lowest number in a range. This is useful for comparisons and analysis. It is simple to use and works efficiently. 

10. Why should I use the CONCAT formula?

CONCAT is used to combine text from different cells into one cell. It is helpful for joining names, addresses, or other text values. It reduces the need for manual typing. This makes your data more organized and clean.