MUO on MSN

Old Excel functions you should stop using (and what to replace them with)

VLOOKUP has been the go-to function for looking up data in Excel for years, but it comes with limitations. You can only search in the leftmost column and return values to the right. If your lookup ...

How to search for terms or values in an Excel spreadsheet, and use Find and Replace

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.
MUO on MSN

Excel’s INFO and CELL functions tell you what’s happening under the hood

While INFO tells you about your Excel environment, CELL digs into individual cells and returns details about their formatting ...