Excel for Data Analytics · Lesson 4
Excel Functions for Data Analytics
Use SUM, AVERAGE, MIN, MAX and COUNT to summarize datasets and understand business performance.
SUMAVERAGEMINMAXCOUNT
Your analyst toolkit
SUM
Total
AVERAGE
Mean
MIN
Lowest
MAX
Highest
COUNT
Numeric entries
Goal
Summarize data
Practice dataset
Sample Sales Performance
Use these sample records to think about totals, typical sales, extremes, and numeric observations.
| Product | Region | Sales | Units |
|---|---|---|---|
| Laptop | North | ₹60,000 | 6 |
| Mouse | South | ₹18,000 | 18 |
| Monitor | East | ₹42,000 | 7 |
| Keyboard | West | ₹15,000 | 10 |
Educational demonstration dataset.
Concept 1 of 80% complete
Concept 1 · TOTALS
SUM: Add Values
SUM adds numeric values across cells or ranges. Analysts use it to calculate revenue, expenses, units sold, and other totals.
Formula pattern
=SUM(C2:C5)
Business application
Calculate total sales across a product dataset.
Interactive activity · Step 1 of 2
Apply the function
A store records sales of ₹12,000, ₹8,000, and ₹5,000. Which function should calculate total sales?