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

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

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

People often confuse Excel's LAMBDA and SCAN functions because they often appear together in formulas. However, they aren't ...

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

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

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

Microsoft has begun rolling out “Money in Excel,” a one-stop dashboard within Microsoft Excel for viewing your day-to-day finances, including bank and credit card transactions. Microsoft recommends ...

As two peas in the same Microsoft Office Suite pod, PowerPoint and Excel were built to work seamlessly with each other, including giving users the ability to cut from one and paste right into the ...

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

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