Spreadsheets for Finance and Accounting

  1. Advanced Analysis Tools
    1. What-If Analysis
      1. Scenario Manager Usage
        1. Goal Seek Applications
          1. Data Table Construction
            1. Sensitivity Testing
            2. Solver Optimization
              1. Solver Installation
                1. Problem Setup
                  1. Constraint Definition
                    1. Solution Interpretation
                      1. Portfolio Optimization
                        1. Resource Allocation
                        2. Macro Automation
                          1. Macro Recording
                            1. Basic VBA Programming
                              1. User-Defined Functions
                                1. Automation Applications
                                  1. Error Handling

                                Previous

                                9. Budgeting and Forecasting Models

                                Go to top

                                Next

                                11. Data Analysis and Visualization