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.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

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.

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.

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

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.

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

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.

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