Before You Begin

This lesson requires some preparation. Here is a summary of the requirements:

 

1. Enable the Developers Toolbar

The steps to enable the Developers toolbar can be found in the Advanced Guide to Excel 2010 Page 184.

 

2. Enable the Macros

The steps to enable Macros can be found on Advanced Guide to Excel 2010 Page 270. This lesson includes a discussion on macro security levels.

 

3. Download a Sample Spreadsheet

The lesson has a sample workbook online which you can download if you wish. You can also create your own data from the lesson in the Intermediate Guide to Excel 2010, Page 11.

File ->Options->Customize Ribbon