How-To Geek on MSN
Microsoft Excel's selection pane: The best tool you didn't know you had
Instead of losing your mind, use the Selection Pane, the hidden sidebar that reveals every object on your sheet so you can ...
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.
Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...
AI Copilot in Excel helps clean dates, split columns, and add currency formats, so you save time and make faster, clearer decisions.
Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...
While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...
Last year, it emerged that Health New Zealand used an Excel spreadsheet as its "primary data file" for managing and analysing ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback