Most of Excel's functions and tools ignore the difference between capital and lowercase letters, which is fine until a case-sensitive ID breaks your workflow. The FIND function is a strict gatekeeper ...

If you've ever used Excel, you're probably familiar with the panicky feeling that comes with using Microsoft's spreadsheet app. It can feel a little overwhelming and tough to navigate, even if you are ...

Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data. Parsing data is a common task in Excel. For the most part, you’ll do so when you need to work with ...

If you check your desktop at work, you're likely to find Excel in there somewhere. Microsoft's original killer app, the spreadsheet tool just keeps getting more useful and the seven courses in the ...