A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet. The Consolidate Data wizard ...

Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...

Struggling with unwieldy Excel spreadsheets that seem impossible to manage? You’re not alone. Many of us face the challenge of organizing large datasets in a way that makes sense and is easy to ...

Last year, it emerged that Health New Zealand used an Excel spreadsheet as its "primary data file" for managing and analysing ...

Usually, if you share an Excel spreadsheet with someone, that person is able to freely edit the spreadsheet. In some cases, you may want to send someone a spreadsheet with data but you also want to ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

Investor reporting still relies on spreadsheets and manual processes, but modern automation and AI can transform data quality ...