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.
Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.
Excel remains an essential tool for data management, analysis, and visualization. In 2025, its evolving features and refined techniques make it more powerful than ever. But have you ever found ...
Discover 15 practical Copilot tricks and tips for Outlook, Excel, Word, Teams & PowerPoint to save time and reduce daily ...
Andrew Ngai is a 37-year-old Australian actuary with an unexpected side gig: Microsoft Excel world champion. Ngai has competed against fellow Excel enthusiasts since 2018, and won his third straight ...
How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac. If you have Excel 2019 or Excel 365, you can use the function TEXTJOIN to quickly join text in ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback