Show Me Microsoft® Office Excel 2003

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

Introduction

If your worksheet or workbook needs to go beyond simple calculations, Microsoft Office Excel 2003 offers several tools to help you create more specialized projects. With Excel, you can perform “what if” analysis using several different methods to get the results you want.

You can customize ...