Excel Formulas for Office Work: Beginner Examples
Learn practical Excel formulas beginners can use for office work, admin tasks, data entry, budgets, and simple reports.
Jadox is a web developer and digital skills educator who creates beginner-friendly guides for students, job seekers, and workers learning practical computer skills.
Excel is one of the most useful Microsoft Office skills for office work, admin jobs, data entry, school tasks, and small business tracking.
You do not need to learn every formula at once. A beginner can become useful by learning a small group of formulas and practicing them with real examples.
1. SUM
Use SUM when you want to add numbers.
Example:
=SUM(B2:B10)
This adds all numbers from cell B2 to B10.
Use it for:
- Adding sales
- Adding expenses
- Adding hours
- Adding marks
- Adding stock totals
2. AVERAGE
Use AVERAGE when you want the usual or middle value from a group of numbers.
Example:
=AVERAGE(C2:C10)
This adds the values and divides by how many numbers are in the range.
Use it for:
- Average test marks
- Average weekly sales
- Average customer ratings
- Average working hours
3. MAX
Use MAX when you want the highest number.
Example:
=MAX(D2:D20)
Use it for:
- Highest sale
- Highest score
- Highest expense
- Most hours worked
4. MIN
Use MIN when you want the lowest number.
Example:
=MIN(D2:D20)
Use it for:
- Lowest sale
- Lowest score
- Smallest payment
- Fewest hours worked
5. COUNT
Use COUNT when you want to count how many cells contain numbers.
Example:
=COUNT(A2:A50)
This is useful when you want to know how many numeric entries are in a list.
6. COUNTA
Use COUNTA when you want to count cells that are not empty.
Example:
=COUNTA(A2:A50)
This can help with attendance lists, customer records, or task trackers.
7. IF
Use IF when Excel needs to make a decision.
Example:
=IF(B2>=50,"Pass","Fail")
This says: if B2 is 50 or more, show Pass. Otherwise, show Fail.
Use it for:
- Pass or fail
- Paid or unpaid
- Complete or incomplete
- Approved or not approved
8. COUNTIF
Use COUNTIF when you want to count only matching cells.
Example:
=COUNTIF(C2:C100,"Paid")
This counts how many cells say Paid.
9. SUMIF
Use SUMIF when you want to add only numbers that match a condition.
Example:
=SUMIF(A2:A50,"Online",B2:B50)
This checks column A for Online and adds the matching numbers in column B.
10. XLOOKUP
Use XLOOKUP when you want to search for something and return a matching result.
Example:
=XLOOKUP(E2,A2:A100,C2:C100)
This looks for the value in E2 inside A2:A100 and returns the matching value from C2:C100.
Practice task
Create a small table with these columns:
- Name
- Department
- Sales
- Status
Then practice:
- Total sales with
SUM - Average sales with
AVERAGE - Highest sale with
MAX - Count paid records with
COUNTIF - Add sales from one department with
SUMIF
Final tip
Do not only memorize formulas. Practice with small real tables. If you want guided practice, use the free Excel Formula Practice Quiz.
Keep learning
Practice task
- Create a folder named Work Practice.
- Create three subfolders: Documents, Images, Downloads.
- Open Google Docs or Microsoft Word.
- Write a short paragraph about yourself.
- Save the file inside Documents.
Topics
Frequently Asked Questions
What are basic computer skills?
Basic computer skills include typing, using a mouse and keyboard, managing files and folders, browsing the web, using email, and working with simple documents or spreadsheets.
What computer skills should I put on my resume?
Add skills that match the job, such as Microsoft Word, Excel, Outlook, file management, data entry, online research, video meetings, and cloud storage.
Can I learn computer skills without a course?
Yes. You can learn computer skills with free guides and steady practice, especially when you use real tasks like creating folders, writing documents, and sending emails.
How long does it take to learn basic computer skills?
Many beginners can learn the basics in a few weeks with regular practice, then improve through daily use at school, work, or home.
Are Microsoft Office skills still important?
Yes. Microsoft Word, Excel, PowerPoint, and Outlook are still useful for office work, admin roles, teaching, sales, data entry, and many entry-level jobs.