Complete Guide to Excel Formulas with Examples in 2025

Discover the essential Excel formulas and functions, learn how to calculate data efficiently with examples, and download the Excel formulas list PDF for 2025.

Excel Formulas List: Excel formulas are essential tools for calculating values in a spreadsheet. They allow users to add, subtract, multiply, and perform various calculations on a group of numbers. In Microsoft Excel, the 'mean' or average can be calculated using predefined functions, such as AVERAGE, which computes the average of the provided numbers.

In Excel, there are two primary methods for performing calculations: formulas and functions.

Formulas: A formula is an expression that computes a value based on cell references. For example, =A1+A2+A3 adds the values in cells A1 through A3.

Functions: Functions are predefined calculations in Excel, designed to simplify complex calculations. For instance, you can use =SUM(A1:A3) to quickly add the values between those cells.

MS Excel Formulas List

SUM Excel Formula:SUM(number1, [number2])
AVERAGE Excel Formula:AVERAGE(number1, [number2], …)
MAX & MIN Excel Formula:=MAX(A2:A5)
=MIN(A2:A5)
COUNT & COUNTA Excel Formula:COUNT(value1, [value2], …)
IF Excel Formula:IF(logical_test, [value_if_true], [value_if_false])
TRIM Excel Formula:=TRIM(A1)
LEN Excel Formula:=LEN(text)
CONCATENATE Excel Formula:CONCATENATE(text1, [text2], …)
List of Excel Formulas

Common Excel Formulas

  1. SUM
  2. COUNT
  3. COUNTA
  4. COUNTBLANK
  5. AVERAGE
  6. MIN
  7. MAX
  8. LEN
  9. TRIM
  10. IF

To learn more about Microsoft software updates, visit the official Microsoft website: https://www.microsoft.com/en-in

Download Excel Formulas List PDF

You can download the Excel formulas list with examples from the link below:

Download Excel Formulas List PDF

For more updates on courses, check out eSkillindia's offerings for 2025.

Leave a Comment