Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...

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

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...

With Endex, you can build a full DCF in Excel, including history, projections, and valuation outputs, producing audit ready ...

Microsoft Project is a software application that allows you to manage the entire life cycle of a project. You can use it to manage project tasks, create and manage milestones, determine critical paths ...

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

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 ...

Microsoft recently added a new optical character recognition feature to Excel that lets users import data from a photograph taken from a smartphone. Here's how to use it. I first started using ...

A few months ago, I speculated on what a then-rumored Office 365 "Life Edition" might end up looking like. Ultimately, Microsoft chose to abandon the "Life Edition" moniker in favor of much more ...

Microsoft Excel is a spreadsheet program for businesses, learning institutions, individuals, data analysts, etc. However, some users have reported issues with Excel that need fixing. For instance, ...

In this tutorial, we will show you how to convert an Excel spreadsheet to a PowerPoint slide. The Excel spreadsheet is often used along with PowerPoint presentations to produce budget reports, ...