Basic Excel Formulas Every Student Should Know: SUM, AVERAGE, MAX, MIN and COUNT Explained

Basic Excel Formulas Every Student Should Know: SUM, AVERAGE, MAX, MIN and COUNT Explained (Updated August 2026)

Every Excel formula starts with an equals sign and tells the spreadsheet exactly what to calculate. Once students understand the difference between a formula and a function, they can solve any calculation problem — from adding exam scores to finding the highest salary in a payroll sheet. This guide explains basic Excel formulas and functions in plain language, with examples drawn from the beginner Excel classes at ABC Trainings.

What Is an Excel Formula and How Is It Different from a Function?

An Excel formula is any calculation you write yourself using operators like +, -, * and /. A function is a pre-built calculation that Excel provides — SUM, AVERAGE, MAX and MIN are all functions. The practical difference: formulas are flexible and custom; functions are fast and handle large ranges automatically. Both always begin with = and both display their result in the cell rather than the expression you typed.

Arithmetic Formulas: Addition, Subtraction, Multiplication and Division

Type =A1+B1 in any cell and Excel adds the values of cells A1 and B1 and shows the result. Replace + with - for subtraction, * for multiplication and / for division. You can also combine operators in one formula: =((A1+B1)*C1)/D1 follows normal mathematical order of operations. For exponents — squaring a number, for example — use the ^ symbol: =A1^2 squares the value in A1.

Formula / Function	Syntax Example	What It Returns
Addition	=A1+B1	Sum of two cells
Subtraction	=A1-B1	Difference of two cells
Multiplication	=A1*B1	Product of two cells
Division	=A1/B1	Quotient of two cells
SUM	=SUM(A1:A10)	Total of range
AVERAGE	=AVERAGE(A1:A10)	Mean of range
MAX	=MAX(A1:A10)	Highest value in range
MIN	=MIN(A1:A10)	Lowest value in range
COUNT	=COUNT(A1:A10)	Count of numeric values
SQRT	=SQRT(A1)	Square root of value

SUM and AVERAGE: The Two Formulas Every Data User Needs First

=SUM(A1:A10) is the fastest way to total a column or row. Excel adds every numeric value in the range A1 through A10, ignoring text and blank cells automatically. =AVERAGE(A1:A10) divides the total by the count of numeric values and returns the mean. These two functions together handle 80% of the routine calculation work in engineering attendance sheets, cost summaries and academic result sheets.

MAX, MIN and COUNT: Finding Extremes and Counting Values

=MAX(A1:A10) returns the single highest numeric value in the range — useful for finding the peak salary, the maximum load in a structural table or the top score in a class list. =MIN returns the lowest value. =COUNT(A1:A10) counts how many cells in the range contain numbers, which is different from COUNTA (which counts non-empty cells including text). Use COUNT when you need to know how many valid numeric entries exist before computing an average.

SQRT and Exponents: Engineering Calculations in Excel

=SQRT(25) returns 5 — the square root of 25. This function is essential in engineering work: calculating the hypotenuse of a right triangle, the RMS value of an alternating current, or the standard deviation in quality control. For other roots, use the ^ operator: =A1^(1/3) gives the cube root of the value in A1. Exponential calculations use =A1^B1 where B1 holds the power.

How ABC Trainings Teaches Excel Formulas from Day One

ABC Trainings starts the Excel module with basic formulas on a live dataset — typically a class marks register or a materials list with quantities and rates. Students type every formula by hand in the first session so they understand why the = sign is required, and then progress to functions in session two. Training runs in Pune (Wagholi, Hadapsar), Osmanpura and Sangli with hands-on computer labs in every centre.

Students eligible for the CM Yuva Karya Prashikshan Yojana (CMYKPY) scheme can receive ₹6,000–₹10,000 subsidy toward Excel, Tally and complete MS Office courses at ABC Trainings. Ask at your nearest branch for the registration process.

FAQs

What is the difference between an Excel formula and an Excel function?

A formula is a custom calculation you write using operators like +, -, * and /; for example =A1+B1+C1. A function is a pre-built command that performs a standard operation on a range; for example =SUM(A1:C1) does the same addition automatically. Functions are faster for large ranges and less prone to typing errors.

How do I add an entire column of numbers in Excel without clicking each cell?

Click the cell below (or beside) the column, then type =SUM( and then select the entire column range by clicking the first cell and dragging to the last, or type the range directly: =SUM(A1:A50). Press Enter. Excel totals all numeric values in the range instantly — you do not need to click each cell individually.

ABC Trainings Excel course vs Coursera or Udemy — which is better for Pune students?

ABC Trainings is better for students in Pune who need hands-on practice with real datasets on institute computers, face-to-face doubt clearing and a certificate recognised by Skill India / NSDC. Coursera and Udemy offer flexible video courses but no live practice environment. If you want to complete Excel in 2–3 weeks with daily guidance and a placement-support network, classroom training at ABC Trainings is faster.

Which Excel function returns the highest value in a list?

=MAX(range) returns the highest numeric value in a list. For example, =MAX(B2:B100) scans 99 values and returns the largest number. If the largest value changes later, the MAX formula updates automatically when you refresh the sheet.