Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

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 you need to. Microsoft Excel's alternative to ...

Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

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

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.

How to combine values into a single cell in Microsoft Excel Power Query Your email has been sent My TechRepublic article How to combine values from a column into a single cell using Microsoft Excel’s ...