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.

How to Put Two Sets of Data on One Graph in Excel. One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as ...

Figure F After converting a data set to a Table, update the dependent references. When you create a Table object, Excel names it — use that name or give it a more meaningful name yourself.

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

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.

You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.