The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is ...
How-To Geek on MSN
Excel's UNIQUE function can't skip columns—unless you use this trick
Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
Wouldn’t it be great if you could be an Excel wizard without putting in all the time and effort needed to learn how to get around Excel and make it do what you want it to do? Formulas are one of the ...
Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...
Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...
A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...
As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.
If you've been working with Excel for quite some time now, you've probably scratched your head many times trying to come up with the correct formulas. Sure, you can take one of the dozens of Excel ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results