Learn how to use Excel to quickly calculate basic descriptive statistics for a dataset, including mean, standard deviation, minimums, and maximums.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

Get & Transform in Excel can help you search for data sources, make connections, and then shape that data in ways you deem fit.

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.

But before showing you the error, let me describe how—and why—names are used in Excel. Giving names to cells, or even groups of cells, makes Excel much easier to use. For example, it’s far easier to ...