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.

Excel functions can therefore aid the process of interpreting a data set in a way that suits the data itself and the organizational system in place.

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

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

Microsoft Excel has been John Weathington's secret weapon for decades. He lists the go-to Excel skills data scientists should master.

Excel 2016 and later include a powerful set of tools for sourcing and managing data called Get & Transform. (These tools are also available for Excel 2010 and 2013 as a downloadable add-in called ...

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.

Discover essential Excel functions to clean and organize messy data. Learn tips to streamline your workflow and save hours of manual edits.

You can set Excel to display dates in a variety of ways, no matter how you type in the data. Here's how to find and change date formats in Excel on a Mac or PC.