O'Reilly logo

Microsoft Office Excel 2007 On Demand by Steve Johnson - Perspection, Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required