Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

Automated Data Entry in Excel. One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data.

Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection ...

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

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 ...

Here's a quick method, and the equivalent keyboard shortcut, for selecting an entire data range. Working with a complete data set is a common task in Excel. You might want to move the data, apply ...

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.