Key Points ANOVA is a handy way of seeing differences between data sets. You can conduct your own ANOVA with software like ...

How to Chart the Frequency of a Data Set on Excel. Plotting the frequency of data falling within numeric ranges illustrates the diversity of your data. As an example, a teacher might wish to ...

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.

While the other formulas can do some magical things, the FORECAST function feels the closest to actual magic because it's as ...

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

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.

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’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

This article compares the data visualization program Tableau to Excel, examines their relative strengths, and provides a simple walk-through on how to use Tableau.

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