Adding a search field to your spreadsheet can greatly improve data navigation and usability. In this guide, you’ll learn how ...

How to Create a Check Box in Excel 2007. Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes.

Now, in the Insert Chart dialog box, select a chart type in the left-hand menu and a chart in the right-hand selector area. In my case, I've selected a simple clustered column chart. Then, click "OK." ...

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.

How to Make Box & Whisker Plots in Excel 2007. Microsoft Excel, ... Select the "Series 1" through "Series 4" values for your first data set; do not select the "Series 5" value at this time.

The pivot table is a collection of tools that Excel uses to create reports from complex, ... Click the down arrow beside the second Input box, and select $200.00 from the dropdown list.