If you've ever had a list of first and last names that you wanted to separate Excel and Google Sheets make it easy. Here's how to do it in each application.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.