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

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

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Learn how to find and replace Text Color in Excel. The classic Find and Replace feature can be used to change the color of text in Excel.