Build confidence working with rows, columns and simple summaries using a fictional community shop dataset. Learn to spot missing values, choose consistent units and separate raw data from calculations. Spreadsheet examples focus on transferable habits rather than a particular software interface.
Book ID
book-013
Reading level
Beginner
Currency
GBP
Category
technology
dataspreadsheetscleaningno code
This is a fictional book in a demonstration store. It is not available to buy.
Reader reviews
6 fictional reviews · 3.8 / 5
★★★★★5 out of 5
Finally understood messy columns
The shop dataset made inconsistent units and missing values easy to spot. I especially liked keeping the untouched data separate from the calculations.
★★★★☆4 out of 5
Useful across spreadsheet apps
The explanations concentrate on what a table means rather than where to click. A few more finished examples would have helped me check my own layout.
★★☆☆☆2 out of 5
Too basic after the opening
I already use spreadsheets at work and hoped to learn more advanced analysis. Most of the book covers naming, cleaning and simple summaries.
★★★☆☆3 out of 5
Clear text, small screenshots
The advice about mixing text and numbers solved a problem for me. Some illustrated tables were small enough that I needed to read the surrounding explanation twice.
★★★★★5 out of 5
Made an intimidating topic manageable
I had avoided working with data because mistakes seemed invisible. The book gives practical checks I can use before trusting a total or comparison.
★★★★☆4 out of 5
Good habits before clever formulas
I appreciated the focus on consistent units and clear headers. Readers looking for a catalogue of spreadsheet functions will need a different book afterwards.