Its funny how it seems only Apple has a spreadsheet the offers free floating "sheets", but there it seems to be treated more like a presentation/layout refinement (meaning that even the "humble" spreadsheet is basically a tool for desktop publishing).
I do believe Excel and others have the ability to reference cells from other sheets, but that still means having to flip between them to keep things in sync.
- Any cell that contains a numerical value (as opposed to a formula) is highlighted. All such cells are at the top of the first sheet.
- Never ever use VLOOKUP or HLOOKUP, as inserting columns or rows will break them. Use INDEX and MATCH instead.
- Never use OFFSET, as it's a 'volatile' function, meaning Excel will recalculate the value for any cell which contains it, if any value in the sheet changes. Use INDEX instead.
- When you're tempted to enter a value directly in a formula (e.g. when you divide by 12 for the number of months in a year), just don't do it. Move the value to an input cell. This goes also for parameters in an OFFSET formula.