How-To Geek on MSN

How to pick a random name from a list in Excel

To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...
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.

Excel tip: Define cell names to cut errors and speed up your formulas

Using the example in our spreadsheet or a similar spreadsheet, highlight all the revenue numbers in the sheet and then in the ...

Excel not recognizing functions after reboot

If Excel is not recognizing functions after reboot, change calculation settings, disable Show Formula, run Excel ...

I won the Microsoft Excel World Championship. Here's what every office worker should know about Excel.

Diarmuid Early won first place in the 2025 Microsoft Excel World Championship. He has some pointers for using Excel at work.