Excel will present a few options for you to consider. In our example, Excel offers to create 10 different pivot tables that take a look at a number of different angles on our sales data.

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

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

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

To create a heatmap chart in Excel, you need to use the Color Scales option. For that, select the list of numbers and choose the Color Scales option from the Conditional Formatting menu.

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.

Autocorrect Options Excel’s Autocorrect settings can be used to create text shortcuts, allowing you to replace short codes with full text automatically.

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.

You can create a pull-down menu in Microsoft Excel 2010 by configuring a list of values in the Data Validation menu. This function provides viewers of your spreadsheet with the option to select a ...

How to Create a Yearly Calendar in Excel. Whether the calendars available in retail shops are too cutesy for your office or you missed the end-of-the-year calendar sale blitz, you're never too far ...