UsefulLinks
Business and Management
Finance and Accounting
Accounting
Spreadsheets for Finance and Accounting
1. Spreadsheet Environment and Setup
2. Data Entry and Basic Formatting
3. Formula Fundamentals
4. Essential Financial Functions
5. Data Organization and Management
6. Financial Model Design Principles
7. Three-Statement Financial Modeling
8. Valuation Modeling Techniques
9. Budgeting and Forecasting Models
10. Advanced Analysis Tools
11. Data Analysis and Visualization
12. Professional Reporting
10.
Advanced Analysis Tools
10.1.
What-If Analysis
10.1.1.
Scenario Manager Usage
10.1.2.
Goal Seek Applications
10.1.3.
Data Table Construction
10.1.4.
Sensitivity Testing
10.2.
Solver Optimization
10.2.1.
Solver Installation
10.2.2.
Problem Setup
10.2.3.
Constraint Definition
10.2.4.
Solution Interpretation
10.2.5.
Portfolio Optimization
10.2.6.
Resource Allocation
10.3.
Macro Automation
10.3.1.
Macro Recording
10.3.2.
Basic VBA Programming
10.3.3.
User-Defined Functions
10.3.4.
Automation Applications
10.3.5.
Error Handling
Previous
9. Budgeting and Forecasting Models
Go to top
Next
11. Data Analysis and Visualization