Skip to main content
Power BI & Excel

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

Learn basic Excel formulas with clear examples — arithmetic operations, SUM, AVERAGE, MAX, MIN, COUNT and SQRT. Practical beginner guide from ABC Trainings for students and working professionals.

AB
ABC Trainings Team
August 21, 2026 — 6 min read

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.

TL;DR
  • Every Excel formula begins with = — without it, Excel treats the entry as plain text.
  • Arithmetic: =A1+B1 adds two cells; use -, *, / for subtraction, multiplication and division.
  • SUM: =SUM(A1:A10) adds all values in the range A1 to A10 instantly.
  • AVERAGE: =AVERAGE(A1:A10) calculates the mean of the range.
  • MAX and MIN: =MAX(A1:A10) returns the highest value; =MIN returns the lowest.
  • COUNT: =COUNT(A1:A10) counts numeric entries in the range.
  • SQRT: =SQRT(25) returns the square root — useful in engineering calculations.
  • Functions are reusable pre-defined formulas; writing your own arithmetic expression is a custom formula.

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.

Basic Excel Formulas Every Student Should Know: SUM, AVERAGE, MAX, MIN and COUNT Explained
Real student workshop at ABC Trainings

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 / FunctionSyntax ExampleWhat It Returns
Addition=A1+B1Sum of two cells
Subtraction=A1-B1Difference of two cells
Multiplication=A1*B1Product of two cells
Division=A1/B1Quotient 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.

Basic Excel Formulas Every Student Should Know: SUM, AVERAGE, MAX, MIN and COUNT Explained
Real student workshop at ABC Trainings

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.

Get the IT Skills Brochure + Fees + Batch Dates on WhatsApp

Free 1:1 counselling. Placement track record. CMYKPY/PMKVY eligibility check.

💬 Get Brochure on WhatsApp📞 Call 7039169629

About the author: ABC Trainings Faculty.

Visit Our Centers

  • Wagholi (Pune): 1st Floor, Laxmi Datta Arcade, Pune-Ahilyanagar Highway. Call 7039169629
  • Hadapsar (Pune HQ): 1st Floor, Shree Tower, opp. Vaibhav Theater, Magarpatta. Call 7039169629
  • Cidco (Chh. Sambhajinagar): Kalpana Plaza, opp. Eiffel Tower, N-1 Cidco. Call 7039169629
  • Osmanpura (Chh. Sambhajinagar): S.S.C Board to Peer Bazar Road, near Jama Masjid. Call 7039169629
  • Sangli: Shubham Emphoria, 1st Floor, Above US Polo Assn., Sangli-Miraj Rd, Vishrambag. Weekend batches available. Call 7039169629

💬 WhatsApp 7774002496

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.

Free counselling

Talk to an ABC Trainings counsellor

Leave your details and our team will call you about the course, fees and the next batch at your nearest centre in Pune, Chhatrapati Sambhajinagar, Sangli or online.

Prefer to talk now? Call +91 70391 69629 or WhatsApp us.

A

ABC Trainings Editorial Team

Course and career information from ABC Trainings. Exact trainer, batch, timetable, delivery mode and complete written fee should be confirmed before enrolment.

Founder & public accountability →