The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

If you want to find and fix Circular References in Microsoft Excel, then this guide will help you get the job done with ease.

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.

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.

You'll need more than one trick up your sleeve to find duplicates in Microsoft Excel.

Learn how to Find and Remove hyperlinks in Excel easily, for all texts or for specific text only. Use the Format section of Microsoft Excel to do it.

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...