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

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

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

How to Convert Excel Data to a Mailing List. Capturing and organizing customer or prospect email addresses is the first basic step toward compiling a mailing list. If you've used Microsoft Excel ...

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Excel displays the error message "Cannot extend list or database" if your new data record has to delete existing data. Data forms add records into a row directly after your last record.

Prevent duplicates before they happen by combining a simple function with data validation.

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.