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

Excel spreadsheets are a daunting affair for many. And indeed, when you are confronting dozens of rows and columns comprising hundreds if not thousands of cells filled with all sorts of data, it's ...

Q. I am trying to create a formula in our accounting system, but I keep getting errors. What can I do to get the formula to work? A. All Excel users know how powerful formulas are, but sometimes it ...

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.

Excel offers many filtering and sorting options, including color, specific text and alphabetical. So, if you have a "Last Name" column, you can alphabetize it in ascending or descending order ...

Why You Should Always Name Ranges in Excel You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to whenever ...