Lesson 1 - Working With Data Series
Using the Series Command
Creating a Linear Series
Creating a Date Series
Using a Stop Value
Creating a Growth Trend Series
Lesson 2 - Using Advanced Functions
Using Lookup Functions
Using the VLOOKUP Function
Using the HLOOKUP Function
Using the IF Function
Using the Nested IF Functions
Using the ISERROR Function
Using an AND Condition with IF
Using an OR Condition with IF
Using the ROUND Function
Limiting the Precision of Numbers
Workshop Information Page |
Lesson 3 - Using Scenarios and Goal Seeking
Using the Scenario Manager
Creating a Scenario
Displaying a Scenario
Editing a Scenario
Creating a Scenario Summary Report
Using Goal Seek
Lesson 4 - Using Data Tables
Using Data Tables
Placing Formulas in Data Tables
Creating a One-Variable Table
Creating a Two-Variable Table
Lesson 5 - Using Auditing Tools
Displaying the Formula Auditing Toolbar
Displaying/Removing Dependent Arrows
Displaying/Removing Precedent Arrows
Removing All Tracer Arrows
Using the Trace Error Button
Tracing Cells Causing Errors
Using the Error Checking Button
Using the Evaluate Formula Button
Using the Watch Window |
