Lesson 6 - Consolidating Worksheets
Consolidating Worksheets
Consolidating by Category
Consolidating by Position
Lesson 7 - Solving Problems
Using Solver
Saving a Solution as a Scenario
Restoring the Original Values
Changing a Constraint
Creating a Solver Report
Viewing Solutions using Scenarios
Lesson 8 - Working With Views
Using Views
Creating a Normal View
Creating a Custom View
Displaying a View
Deleting a Custom View
Workshop Information Page |
Lesson 9 - Using Macros
Defining Macros
Opening a Workbook Containing Macros
Running a Macro
Using a Shortcut Key
Using the Visual Basic Toolbar
Opening the Visual Basic Editor Window
Using the Visual Basic Editor Window
Lesson 10 - Recording Macros
Recording a Macro
Assigning a Shortcut Key
Using Relative References
Assigning a Macro to a Menu
Removing a Custom Menu Item
Deleting a Macro |
