Microsoft Office Excel 2007 On Demand

11. Building More Powerful Worksheets

What You'll Do

Use Data Analysis Tools

Create Conditional Sums

Look at Alternatives with Data Tables

Ask “What If” with Goal Seek

Create Scenarios

Use Solver

Use Lookup and Reference Functions

Use Text Functions

Summarize Data Using Subtotals

Summarize Data Using Functions

Determine Specific Dates

Introduction

Excel also includes a variety of add-ins—programs that provide added functionality—to increase your efficiency. Some of these supplemental programs—including Conditional Sum Wizard, Lookup Wizard, and Solver—are useful to almost anyone using Excel. Others, such as the Analysis ToolPak, add customized features, functions, or commands specific to use in financial, statistical, and other highly specialized ...