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.