Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Learn how Power Pivot transforms Excel into a powerful tool for managing complex datasets, advanced calculations, and data integration.

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

How to Create Macros Downloading Real Time Data to Excel. Many companies depend on up-to-date data to make informed decisions regarding their businesses.

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