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

See how try and otherwise protect custom column math from type errors in Power Query, saving time and keeping your refresh ...

Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I’ve accepted a job ...