Excel cheat sheet
Practice formulas, conditional aggregation, lookups, and quality checks using sales examples.
- Read rumus.txt and check the separators used by your spreadsheet locale.
- Test formulas on a few rows with manually calculated expected results.
- Check blanks, duplicates, number types, lookup misses, and division by zero.