Data Analysis with Spreadsheets

  1. What-If Analysis and Scenario Planning
    1. Goal Seek Analysis
      1. Goal Seek Fundamentals
        1. Target Value Setting
          1. Variable Cell Selection
            1. Formula Cell Identification
            2. Goal Seek Applications
              1. Break-Even Analysis
                1. Target Achievement
                  1. Reverse Calculations
                  2. Goal Seek Limitations
                    1. Single Variable Constraint
                      1. Linear Relationship Assumptions
                    2. Scenario Manager
                      1. Scenario Creation
                        1. Defining Input Variables
                          1. Creating Multiple Scenarios
                            1. Scenario Naming Conventions
                            2. Scenario Management
                              1. Editing Scenarios
                                1. Deleting Scenarios
                                  1. Scenario Protection
                                  2. Scenario Reporting
                                    1. Scenario Summary Reports
                                      1. Scenario PivotTable Reports
                                        1. Report Formatting Options
                                      2. Data Tables for Sensitivity Analysis
                                        1. One-Variable Data Tables
                                          1. Input Cell Configuration
                                            1. Formula Cell Setup
                                              1. Table Generation Process
                                              2. Two-Variable Data Tables
                                                1. Row Input Configuration
                                                  1. Column Input Configuration
                                                    1. Result Matrix Interpretation
                                                    2. Data Table Applications
                                                      1. Sensitivity Analysis
                                                        1. Parameter Testing
                                                          1. Optimization Scenarios
                                                        2. Solver Add-In
                                                          1. Solver Installation and Setup
                                                            1. Add-In Activation
                                                              1. Solver Interface
                                                              2. Optimization Problems
                                                                1. Objective Function Definition
                                                                  1. Constraint Specification
                                                                    1. Variable Cell Selection
                                                                    2. Solver Methods
                                                                      1. Linear Programming
                                                                        1. Nonlinear Optimization
                                                                          1. Evolutionary Algorithms
                                                                          2. Solver Reports
                                                                            1. Answer Reports
                                                                              1. Sensitivity Reports
                                                                                1. Limits Reports

                                                                            Previous

                                                                            7. Data Visualization and Chart Creation

                                                                            Go to top

                                                                            Next

                                                                            9. Advanced Analysis Techniques