Excel still runs offices across Ghana — payroll sheets, sales trackers, student results, and shop inventories.
This beginner guide covers core Excel skills that unlock most everyday tasks. Menu names are similar in Microsoft Excel and close cousins like Google Sheets.
What Excel Is For
- Add and analyse numbers
- Build simple budgets
- Track inventory and attendance
- Clean lists (names, phones, payments)
- Create basic charts for reports
Excel Beginner Skills Checklist
1. Workbook vs Worksheet
A workbook is the file. Worksheets are the tabs at the bottom.
2. Cells, Rows, Columns
Click a cell to type. Use Tab to move right, Enter to move down.
3. Basic Formulas
Start every formula with =.
| Formula | What it does |
|---|---|
=A1+B1 | Adds two cells |
=SUM(A1:A10) | Adds a range |
=AVERAGE(B1:B10) | Average |
=COUNT(C1:C10) | Counts numbers |
=IF(D1>=50,"Pass","Fail") | Simple logic |
4. Freeze Header Rows
View → Freeze Panes so titles stay visible while scrolling.
5. Sort & Filter
Select headers → Data → Filter. Click dropdowns to filter paid/unpaid, cities, dates.
6. Format as Table / Currency
Format money columns as currency. Bold headers. Adjust column widths.
7. Simple Charts
Highlight data → Insert → Column/Pie chart for quick presentations.
Practice Mini-Project (30 Minutes)
Build a weekly sales sheet:
- Columns: Date, Item, Qty, Unit Price, Total
- Total formula:
=C2*D2 - Bottom sum:
=SUM(E2:E50) - Filter by item
- Chart top products
That’s freelancing-ready for small shops.
Excel for Beginners — Quick Shortcuts
| Shortcut | Action |
|---|---|
Ctrl + C / V | Copy / Paste |
Ctrl + S | Save |
Ctrl + Z | Undo |
Alt + = | AutoSum (Windows Excel) |
Ctrl + Arrow | Jump to data edge |
Common Beginner Mistakes
- Typing numbers as text (left-aligned with apostrophes)
- Deleting formulas and hard-coding totals
- No backups of important workbooks
- Merging cells everywhere (breaks sorting)
FAQ
Is Google Sheets better than Excel?
Sheets wins for collaboration links. Excel is still standard in many offices. Learn concepts once — switch easily.
Do I need a paid Microsoft 365 licence?
Schools/offices often provide one. Free alternatives exist, but Excel remains the workplace default.
Can Excel skills make money?
Yes — data cleaning, bookkeeping support, and report dashboards for SMEs.
Sources / Practice On
- Microsoft Excel Help / training templates
- Google Sheets function list (if you practice there)
This article is original editorial for Sen Gideons News Studio. Ribbon labels vary slightly by Excel version.