Chapter 11. Building More Powerful Worksheets

What You'll Do

Load and Unload Add-Ins

Use Data Analysis Tools

Look at Alternatives with Data Tables

Ask "What If" with Goal Seek

Create Scenarios

Use Solver

Use Lookup and Reference Functions

Understand How Macros Automate Your Work

Record a Macro

Run a Macro

Understand Macro Code

Debug a Macro Using Step Mode

Edit a Macro

Restrict Workbook Access

Protect Your Data

Use Digital Signatures

Apply Security Settings