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

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.

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

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

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

How to Find Cells With Strikethrough in Excel. For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of ...

Microsoft Excel allows you to assign names to any cell range using its "Define Name" utility, assessable via the right-click menu.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

Irene Galente asked if she can combine the name data in a number of Excel columns into a single cell. In Irene’s spreadsheet the first column displays each person’s “title” … ...

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