Excel® 2013 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 Inquire Tools

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

Use Web Functions