Free preview
1. Set up data the right way
Most spreadsheet problems start with bad layout. Before any formula, organise your data as a table: one header row, one record per row, one type of information per column, no blank rows in the middle and no merged cells inside the data.
Good: columns Date, Invoice No., Customer, Item, Qty, Unit Price, Amount, Paid. Each sale is one row.
Bad: a separate sheet per month with totals typed in, customer names spelt three ways, and amounts stored as text with '₦' typed in.
Three habits fix most of this. First, convert your range into an Excel Table (Ctrl+T). Tables expand automatically, keep formatting consistent and let you use readable formulas like =SUM(Sales[Amount]). Second, use Data Validation drop-downs for repeated values such as branch, product or staff name, so spelling stays consistent. Third, format numbers with number formats, not by typing symbols: select the column and apply the currency or accounting format with ₦.
Practice: take any list you have (sales, stock, contacts) and restructure it into a single table with clear headers. Every chapter after this assumes your data looks like this.
+ 10 more chapters locked
Buy to unlock the full guide on this page.
$3.87