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 ...

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

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” … ...

The name must begin with a letter or underscore, contain no spaces and not use other Excel functions or reference names. Click the cell on another sheet where you want the total to reappear.

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.