How to Change Series Data in Excel. To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your ...

Data forms add records into a row directly after your last record. If you have blank rows in the middle of your data set, Excel recognizes those gaps as available rows and inserts records from there.

Reversing and transposing an Excel data set doesn't have to be a complicated process. Susan Harkins explains how to cut to the chase.

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

Learn how to dynamically insert blank rows in Excel to improve data readability, organization, and clarity with advanced techniques.

Part Two of this three-part article covers how to import your Outlook contact list—the CSV file—into Excel, then how to refine, maintain, and manage that database so, in Part Three, you can ...