Basic Excel Functions in Microsoft Excel
- Feb 20
- 2 min read
1. Introduction to Excel Functions
An Excel function is a built-in formula that performs a specific calculation.
Instead of writing long formulas manually, Excel provides ready-made functions that save time and reduce errors.
Functions are widely used in:
✔ Finance
✔ Bookkeeping
✔ Data Analysis
✔ Budgeting
✔ Business Reporting
2. Structure of a Function
All functions:
Start with =
Include the function name
Use brackets ()
Example:
=SUM(A1:A5)
Structure:
=FUNCTION(CellRange)
3. The SUM Function
Purpose:
Adds numbers together.
Example:
=SUM(A1:A10)
Used for:
Sales totals
Expense totals
Payroll totals
Financial summaries
Finance Application: Used in Profit & Loss statements to calculate total revenue or total expenses.
4. The AVERAGE Function
Purpose:
Calculates the average (mean) value.
Example:
=AVERAGE(A1:A10)
Used for:
Average monthly sales
Performance reviews
Budget forecasting
5. The COUNT Function
Purpose:
Counts cells containing numbers only.
Example:
=COUNT(A1:A10)
Used for:
Counting invoices
Counting transactions
Checking number of entries
Important: COUNT only counts numbers, not text.
6. The COUNTA Function
Purpose:
Counts all non-empty cells (numbers and text).
Example:
=COUNTA(A1:A10)
Used for:
Counting employee names
Counting client records
Checking data completeness
7. The MIN Function
Purpose:
Finds the smallest value.
Example:
=MIN(A1:A10)
Used for:
Lowest sales month
Cheapest supplier
Smallest expense
8. The MAX Function
Purpose:
Finds the largest value.
Example:
=MAX(A1:A10)
Used for:
Highest sales month
Largest invoice
Maximum expense
9. The IF Function (Basic Introduction)
Purpose:
Performs a logical test.
Structure:
=IF(condition, value_if_true, value_if_false)
Example:
=IF(A1>1000,"High","Low")
Meaning: If value in A1 is greater than 1000 → Show "High" Otherwise → Show "Low"
Used in:
Credit control decisions
Budget alerts
Performance indicators
10. The ROUND Function
Purpose:
Rounds numbers to a specific number of decimal places.
Example:
=ROUND(A1,2)
Meaning: Round the number in A1 to 2 decimal places.
Used for:
Financial reports
Currency formatting
VAT calculations
11. AutoSum Shortcut
Instead of typing SUM manually:
Click below your numbers.
Click the AutoSum (Σ) button.
Press Enter.
Excel automatically selects the range.
✔ Quick
✔ Accurate
✔ Used daily in finance
12. Example Business Scenario
Monthly Sales Data:
Month | Sales |
Jan | 5,000 |
Feb | 7,500 |
Mar | 6,200 |
Functions to apply:
Total Sales → =SUM(B2:B4)
Average Sales → =AVERAGE(B2:B4)
Highest Month → =MAX(B2:B4)
Lowest Month → =MIN(B2:B4)
Number of Months → =COUNT(B2:B4)
This demonstrates real-world finance application.
13. Common Errors
14. Best Practices
✔Always check cell ranges
✔ Avoid typing numbers directly into formulas
✔ Use consistent formatting
✔ Double-check brackets
✔ Use meaningful worksheet names
15. Practice Exercise
Create a simple expense table:
Item | Amount |
Rent | 2,000 |
Utilities | 500 |
Supplies | 300 |
Travel | 450 |
Tasks:
Calculate Total Expenses
Calculate Average Expense
Identify Highest Expense
Identify Lowest Expense
Count number of expenses
16. Knowledge Check Questions
What is the difference between COUNT and COUNTA?
Why must every function start with = ?
What does the IF function do?
When would you use ROUND in finance?
Why is SUM one of the most important functions?
17. Key Takeaways
✔ Functions are built-in formulas
✔ SUM is essential in finance
✔ IF introduces logical thinking
✔ Functions improve efficiency and reduce errors
✔ These skills are essential for finance job interviews
Comments