When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...

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.

Microsoft Excel is designed to alert users whenever a circular reference is causing problems. Folks who are unable to spot the error can take full advantage of the ...

This is my simple way to use the VLOOKUP function in Excel to find data fast. I walk through how I use VLOOKUP to look up ...

Before we can move forward, you must first ensure Microsoft Excel is up and running on your computer. If you’re not sure how to get this done, well, let us explain. From the Workbook where you want to ...

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you. If you regularly work with Excel spreadsheets, you probably find yourself repeating ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...