Last year, it emerged that Health New Zealand used an Excel spreadsheet as its "primary data file" for managing and analysing its financial performance. This made collection and consolidation of data ...

Excel files bloat from ghost used ranges, formatting, pivot caches, and images. These quick fixes massively cut the size of ...

Using the example in our spreadsheet or a similar spreadsheet, highlight all the revenue numbers in the sheet and then in the ...