0.1What is Excel & overview
The essentials in 30 seconds
- Excel is a spreadsheet: a grid of rows and columns where each cell holds a number, text or a formula — to calculate, analyze and present.
- Its strength is automatic recalculation: a cell can depend on other cells, and when data changes, all totals update by themselves.
- It stops at very large volumes and multi-user transactional work: there, you switch to a database or Power BI.
Running mini-case — Wassim has had enough of his calculator in Algiers
Wassim, an accountant in Algiers, tracks his small company's monthly budget with a calculator and a notebook: each time rent or purchases change, he recalculates every total by hand and makes mistakes. He applies the section's grid: the need (calculate, analyze, present linked figures) belongs to the spreadsheet, not the calculator → he builds a mini-budget where the total depends on the items via =SUM(B2:B3). When an amount changes, the total recalculates by itself. He also notes the limit: for millions of rows or simultaneous entries, a database will be needed, not Excel.
Standalone case for this section: it returns in the course, the diagram, the script and the 48h challenge of section 0.1.
1. Excel, the universal spreadsheet
Excel is a spreadsheet: a grid of rows and columns where each box, the cell, holds a number, text or a formula. It is used to calculate, analyze and present data: budgets, lists, trackers, dashboards. It is the most widespread tool in business for handling numbers. Wassim stores his expense items there instead of scattering them in a notebook.
2. Its real strength: automatic recalculation
Unlike a calculator, a cell can depend on other cells through a formula. When data changes, Excel recalculates everything automatically. You thus build a living model: change an assumption and all totals update. Wassim keeps the image: he no longer types the total, he has it computed by =SUM(B2:B3).
3. Where Excel stops
Excel is excellent for analysis and medium-sized tables. For very large volumes, multi-user transactional work or large-scale shared reports, you switch to a database or Power BI. Knowing this limit avoids forcing Excel where it no longer fits. Wassim frames his scope: budget and trackers in Excel, heavy multi-user accounting elsewhere.
Did you know? The amnesiac calculator
Same data everywhere, totals always up to date.
🔎 Concrete example — 🔎 Concrete example — A mini-budget that recalculates
Wassim tracks two items with a formulated total: the total depends on the amounts, it is never typed.
A B
1 Item Amount
2 Rent 800
3 Groceries 400
4 Total =SUM(B2:B3) → 1200Reading: cell B4 does not hold 1200, but the formula =SUM(B2:B3).
Lesson: change rent to 900 and B4 shows 1300 by itself — that is automatic recalculation.
Section vocabulary
- Spreadsheet
- Grid software (rows and columns) to calculate and analyze data.
Simple example: Wassim stores his budget there instead of computing it in a notebook.
What it is not: a calculator that forgets everything after each operation.
Reflex: linked data + repeated calculations → spreadsheet.
- Cell
- A box in the grid, identified by its column and row (e.g. B4).
Simple example: Wassim reads the total in B4.
What it is not: the whole column or the whole sheet.
Reflex: always think in addresses (B4), not « bottom box ».
- Formula
- An expression starting with = that computes from other cells.
Simple example: Wassim writes =SUM(B2:B3) instead of typing 1200.
What it is not: a hard-coded number that never updates.
Reflex: a total is formulated, not typed.
- Workbook
- The Excel file (.xlsx), containing one or more sheets.
Simple example: Wassim saves his budget in Budget-2026.xlsx.
What it is not: an isolated sheet without a file.
Reflex: one workbook = one topic (budget, sales, tracker).
- Automatic recalculation
- The instant update of formulas when data changes.
Simple example: Wassim changes the rent: the total recalculates by itself.
What it is not: a manual recalculation on a calculator.
Reflex: change an assumption, then check the totals.
In practice — In practice — Place Excel in your daily life
- List five tasks in your job (or daily life) that handle numbers or lists, like Wassim with his budget.
- For each, say whether Excel would fit better than a calculator or a text document.
- Spot a task where automatic recalculation would save time.
- Identify a task too large for Excel (→ database / Power BI).
Step-by-step script — frame your first case like Wassim (3 min)
1) Write down Wassim's numeric task: track two items (rent 800, groceries 400) whose total changes often. 2) Spot what changes (the amounts) and what must follow (the total): the total depends on the amounts → formula, not a typed number. 3) Write the target formula: =SUM(B2:B3) in B4. 4) Tick the limit: medium-sized table → Excel; millions of rows or simultaneous entries → database or Power BI.
Keep this sheet: sections 0.3 and 0.4 turn it into a workbook and real gestures.
Copy-paste template — my case, Excel or not?
Task: ___ (e.g. Wassim's monthly budget).
Data that changes: ___ (e.g. rent, groceries).
Results that must follow: ___ (e.g. total B4 =SUM(B2:B3)).
Decider: [ ] linked calculations + medium size → Excel / [ ] millions of rows or multi-user → DB / Power BI.
Rule: totals in FORMULAS, never typed hard-coded.Monthly budget
Wassim tracks rent and groceries: =SUM(B2:B3) recalculates the total on every change.
Stock list
Wassim lists his supplies: entered quantities, formulated totals, no more calculator mistakes.
Invoice tracking
Wassim tracks paid and due invoices: the amount left to pay recalculates when an invoice changes status.
Too big for Excel
Millions of multi-user rows: Wassim switches to a database or Power BI.
✓ Best practices
- Think model: raw data, then formulas that depend on it.
- Separate entered data and calculated cells.
- Know Excel's limit (huge volumes → DB/Power BI).
✗ Common pitfalls
- Typing a result « hard-coded » instead of a formula.
- Mixing data and calculations in the same column.
- Wanting to do everything in Excel, even the unmanageable.
Key takeaways
- Excel is a spreadsheet: cells, rows, columns.
- Excel's strength = formulas + automatic recalculation.
- It is used to calculate, analyze and present data.
- For very large volumes or transactional work, prefer a database / Power BI.
48h challenge — apply tomorrow
Fill in the Excel-case template for ONE real case (Wassim's or yours): data that changes, results that follow, target formula — and write in one sentence what automatic recalculation will save you.
- I can explain what a spreadsheet is and what a formula does.
- I can name Excel's strength (automatic recalculation) with an example.
- I know the limit: huge volumes and transactional → DB / Power BI.
Frequently asked questions
Excel or Google Sheets?
The concepts are identical (cells, formulas, pivot tables). Excel is more complete on advanced functions, Power Query and VBA; Sheets shines at real-time collaboration. This guide applies to both about 90%.
Do you need to be « good at maths » for Excel?
No: Excel does the calculations. What matters is logic (which data depends on which) and rigor, not mental arithmetic.
What is Excel's real strength over a calculator?