Microsoft® Excel 2010 On Demand

11 Building More Powerful Worksheets

What You’ll Do

Use Data Analysis Tools

Use the Euro Conversion

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

Use Date & Time Functions

Use Logical Functions

Use Financial Functions

Use Math Functions

Use Statistical Functions

Use Information Functions

Use Compatibility Functions

Introduction

Excel also includes a variety of add-ins—programs that provide added functionality—to increase your efficiency. Some of these supplemental programs—including Analysis ToolPak, Analysis ToolPak VBA, Euro Currency, and Solver—are useful to almost anyone using ...