Common Excel Functions
Common Excel Functions
Using Built-in Logic for Fast Results
A Function is a pre-defined formula already built into Excel. Instead of typing =A1+A2+A3..., you can simply use a function like SUM to handle the work for you.
The Anatomy of a Function
=FUNCTION_NAME(arguments)
The arguments are the pieces of information (like a range of cells) that the function needs to do its job.
The "Essential Six" Functions
| Function | What it does | Example |
|---|---|---|
| SUM | Adds all numbers in a range. | =SUM(A1:A10) |
| AVERAGE | Calculates the mathematical mean. | =AVERAGE(B1:B20) |
| COUNT | Counts cells that contain numbers. | =COUNT(C1:C50) |
| MIN / MAX | Finds the lowest or highest value. | =MAX(D1:D100) |
| IF | Checks a condition (e.g., Is score > 50?). | =IF(A1>50, "Pass", "Fail") |
The "AutoSum" Shortcut
Highlight a column of numbers and press Alt + = on your keyboard. Excel will automatically write the SUM function for you at the bottom!
💡 Skill Eco Pro-Tip: Formula Autocomplete
You don't need to memorize every function name. As soon as you type = and the first few letters (like =AV...), Excel will show a list of functions. Just press the TAB key to select the one you want!
🏋️ Test Yourself With Exercises
Take our quiz on Common Excel Functions to test your knowledge.
Exercise »