Microsoft Excel is a spreadsheet program — a grid of cells that hold numbers, text and formulas. It is used for budgets, invoices, stock lists, schedules, data analysis and charts. It is probably the most widely used business tool in the world, and also the most widely misused.
What is Excel?
Excel arranges data in a grid of rows and columns, where each cell can contain a value, text, a date, or a formula that calculates from other cells.
The idea that makes a spreadsheet powerful is the live reference. A cell containing =B2*C2 does not store a number — it stores an instruction. Change B2, and the result updates instantly, along with everything that depends on it. That chain of recalculation is what separates a spreadsheet from a table in a document.
Excel comes in several forms, and they are not identical:
- Desktop Excel (Windows and Mac) — the full version, part of Microsoft 365 or a one-off Office purchase.
- Excel for the web — free with a Microsoft account, browser-based, fewer features.
- Excel mobile — free on phones and tablets, best for viewing and light edits.
The main alternatives are Google Sheets (free, browser-based, far better for real-time collaboration) and LibreOffice Calc (free, open source, works offline). For most everyday tasks these are genuinely interchangeable with Excel, and files move between them reasonably well.
A South African note: Excel handles the rand, local date formats and VAT calculations without difficulty, but check your regional settings — a spreadsheet built with US date formats (month/day/year) misreads South African dates, and this quietly corrupts data more often than people realise.
What is Excel used for?
- Budgets and personal finance — income, expenses, savings targets.
- Business accounts — invoicing, cash flow, expense claims, VAT records.
- Stock and inventory lists.
- Schedules and rosters, including shift planning and project timelines.
- Data analysis — sorting, filtering, summarising, and finding patterns.
- Charts and graphs, for reports and presentations.
- Contact and customer lists, and quotes and pricing calculators.
- Marks, grades and attendance registers, very widely in schools.
- Timesheets, payroll working and loan calculations.
- Cleaning and reformatting data before moving it somewhere else.
What Excel is not good at, despite being used for all of it: it is not a database, and it is not accounting software. Once a spreadsheet has thousands of rows, several people editing it, or genuine accounting requirements, it becomes fragile — and spreadsheet errors have caused real losses in real organisations. If more than one person needs to edit at once, use Google Sheets or a shared cloud file; if you are running a business, use proper accounting software.
Common tasks you can do with Excel
Basic formulas. =SUM(A1:A10) adds a range; =AVERAGE(), =COUNT(), =MIN() and =MAX() do what they say. These four cover most everyday needs.
Lookups. =VLOOKUP() finds a value in a table — the classic. =XLOOKUP() replaces it in modern Excel and is simpler and less error-prone; use it if you have it.
Conditional logic. =IF(A1>100,"Over","Under") branches on a condition. =SUMIF() and =COUNTIF() total or count only rows meeting a criterion.
Pivot tables. The single most useful feature most people never learn. A pivot table summarises thousands of rows into a readable table in about four clicks — sales by month, spend by category, hours by employee. If you learn one advanced thing in Excel, learn this.
Sorting and filtering. Turn a range into a table (Ctrl+T), and you get sortable, filterable columns.
Conditional formatting. Colour cells by value — overdue in red, targets met in green.
Charts. Select the data, press F11 or use Insert. Column charts for comparison, line charts for change over time, and generally avoid pie charts, which are hard to read accurately.
Freezing panes and printing. View → Freeze Panes keeps headers visible. Set the print area and “fit to one page wide” before wondering why it printed across nine sheets.
Data validation. Restrict a cell to a dropdown or a number range, which prevents most data entry errors at source.
Who Excel is useful for
Small business owners, for invoicing, quoting, stock and cash flow — often the first and sometimes only business system.
Bookkeepers and accountants, for working papers, reconciliations and analysis alongside proper accounting software.
Teachers, for marks, attendance and reports.
Anyone managing a budget — household, project, department or event.
Administrators and office staff, where Excel is frequently a job requirement and listed explicitly in job adverts.
Analysts and researchers, for cleaning, exploring and charting data before deeper analysis.
Students, for lab data, assignments and, in commerce degrees, extensively.
Job seekers. Excel skills are among the most commonly requested in South African office job listings, and pivot tables and VLOOKUP/XLOOKUP are what “intermediate Excel” usually means in practice.
When to choose Excel instead of a related tool
| Use | Better choice |
|---|---|
| Calculations, analysis, charts | Excel |
| Real-time collaboration | Google Sheets — considerably better |
| Free, offline, no subscription | LibreOffice Calc |
| Running a business’s accounts | Accounting software — Sage, Xero, QuickBooks |
| Thousands of records, multiple users | A database — Access, or a proper system |
| Writing a document | Microsoft Word |
| Presenting to an audience | PowerPoint |
| Project scheduling with dependencies | Project management software |
Choose Excel when you need calculation, analysis or charting, work mostly alone or hand files back and forth, and want the deepest feature set.
Choose Google Sheets when several people edit at once, you want it free, or you work across devices. The collaboration difference is genuinely large — Sheets was built for it and Excel was retrofitted.
See the office tools hub.
Related software and productivity guides
Frequently asked questions
What is Excel used for? Budgets, invoicing, stock lists, schedules, data analysis and charts — anything involving numbers arranged in rows and columns with calculations between them.
Is Excel free? Excel for the web is free with a Microsoft account, with fewer features. The desktop version needs Microsoft 365 or an Office purchase. Google Sheets and LibreOffice Calc are free alternatives.
What is the most useful thing to learn? Pivot tables. They summarise thousands of rows into a readable table in a few clicks, and most people never learn them.
VLOOKUP or XLOOKUP? XLOOKUP if your version has it — simpler, more flexible and less error-prone. VLOOKUP still works and is what older spreadsheets use.
Can I use Excel for my business accounts? For a very small operation, yes. Once you have VAT, multiple people, or real volume, proper accounting software is safer — spreadsheet errors have caused serious losses in real organisations.
Excel or Google Sheets? Excel for depth of features and heavy analysis; Sheets for real-time collaboration and working free across devices.
Why do my dates look wrong? Almost always a regional settings mismatch. A file built with US month/day/year formats misreads South African dates, and it corrupts data quietly.
How do I stop it printing across nine pages? Set the print area, then use Page Layout → Scale to Fit → one page wide.