Beyond a list of numbers.
WHAT TO LEARN FIRST
Structuring data properly: one row per record, one column per attribute
Sums and averages Sorting and filtering
WHAT TO LEARN NEXT
Conditional totals, adding only what meets a condition Lookups, bringing a value from one table into another Pivot summaries, grouping and totalling without formulas
THOSE THREE
Cover the majority of business spreadsheet work.
WHAT MAKES SPREADSHEETS BREAK
Merged cells Totals inside the data Blank rows Formatting used to convey meaning Several values in one cell
WHAT TO DO INSTEAD OF COLOURING ROWS
Add a column stating what the colour means.
Then it can be filtered and counted.
WHAT TO CHECK ALWAYS
That a total matches a figure you already know.
WHAT TO NEVER DO
Sort one column without the others.
WHY
It destroys the relationship between columns, irreversibly.
WHAT TO USE
A table, so sorting and formulas behave correctly.
