Level 6 · In practice

6.4Toolbox

Goal: have operational checklists and the essential Excel shortcuts.

Estimated time: 10 min · If you only have 5 min: read “The essentials in 30s” + the diagram.

The essentials in 30 seconds

Build clean: one row = one record, named Ctrl+T table, correct types, never hard-coded formulas, 3 sheets Data/Calculations/Output.
Draw fast: Ctrl+T, Alt+=, F4 for the $, Ctrl+Enter, Ctrl+Shift+arrow, Ctrl+; to date — shortcuts multiply your speed.
Rule: a checklist ticked each time beats a method known by heart — on a shared workbook, you execute.

Wassim thread — the cards near the desk

After a quarter, the two cards below stay near Wassim's desk: the clean-table one taped next to the screen, the shortcuts one in his notebook. « What saved me, he says in essence, isn't knowing the points, it's ticking them each time — especially the days before a closing. »

Adapt the wording to your context, keep the structure: it's what prevents omissions and errors.

Ready-to-use pointers

A good checklist makes a task fast and complete; the right shortcuts multiply your speed. Adapt them to your context.

Build a clean table

One row = one record; unique headers
No empty rows/columns or mixed-in totals
Convert to a structured table (Ctrl+T) and name it
Correct types (numbers right, real dates)
Formulas rather than hard-coded values
Shared constants as absolute ($)
Separate sheets: Data / Calculations / Output
Check sort/filters act on the whole row

Essential keyboard shortcuts

Ctrl+T: convert to a table
Ctrl+Shift+↓: select to the bottom of the data
Alt+=: AutoSum
Ctrl+;: today's date
F4: lock the $ (in a formula)
Ctrl+Enter: confirm across the whole selection
Ctrl+T or Ctrl+Shift+L: filters
Ctrl+Z / Ctrl+Y: undo / redo

Common misinterpretation: « collect checklists ». No. A checklist is only useful if ticked and used: take the one for your next table, the others will wait.

Text version of the diagram (SEO / screen readers / translation): Two moments, two cards: 1) Build clean — one row = one record, named Ctrl+T table, correct types, formulas everywhere, constants in $, 3 sheets, sort on the whole row. 2) Go fast — Ctrl+T, Alt+=, F4, Ctrl+Enter, Ctrl+Shift+arrow, Ctrl+;, filters, undo/redo. Lesson: you no longer think under pressure, you execute the card near your desk.

Ready-to-say script — set up a clean table (30 s)

« One row = one fact? Unique headers? Named Ctrl+T table? Types right? Formulas everywhere? Constants in $? 3 sheets? Sort on the whole row? If any no, I fix it before analyzing. »

Copy-paste template — healthy base and totals

=SUM(B2:B13)
=AVERAGE(C2:C13)
=SUMIFS(Sales[Amount],Sales[Month],"2026-01")
=IFERROR(A2/B2,"")

SME / small budget

Cards on one page taped to the wall: the essentials (named table, types, Alt+=, F4) are enough.

SME Algiers

Provide for local realities in the card: accountant's exports, French dates, known owner.

Remote / hybrid

Add a written validation line to the tracking: at a distance, a dated and ticked table avoids misunderstandings.

Intercultural

Make the labels explicit in writing: what seems obvious (who enters, which format) isn't for everyone.

Caution: Generic reminder: speed and sharing commit your reliability — point « sort on the whole row, named table, copy before sending » ticked every time; this guide gives no legal advice.

48h challenge — apply tomorrow

Take 1 real table, run the « Build a clean table » checklist and tick where it stands. Use 3 shortcuts from the card.

Section exit checklist

I ticked a checklist on a real table.
I know how to draw the clean card and the shortcuts at the right moment.
I did the 48h challenge or planned its date.

Self-assessment 1-5: tooling of my workbooks?dated use of the checklists?

← Previous : Best practices & pitfalls (V3)Next : Field feedback (V3) →

Check your understanding

Wassim is setting up his sales table. What must he tick first?

💡

Tip: keep these checklists next to the guide's running project (the sales dashboard).