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

Messy Excel data can be a huge time-waster and a major roadblock to getting real insights. When you deal with an Excel workbook that’s packed with inconsistent entries, missing values, and ...

How to Turn an Excel Spreadsheet Into a Standalone Application. If you create spreadsheets in Microsoft Excel that you need to distribute to colleagues or coworkers who don't use the software, you ...

I’m not referring to fancy formulas, just simple spreadsheets, so I’m going to share with you how to set up a spreadsheet, the common errors I see and how to fix them.

Create a Master Spreadsheet You'll often want to have Excel consolidate data from multiple spreadsheets with similar data.

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.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

In this guide, we'll show you the different ways to reduce the size of a Microsoft Excel spreadsheet to make it easier to share and store.

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...