Excel Data Analysis: Forecasting

Discover how to use Microsoft Excel to quickly create financial forecasts with analytics and big data.

Introduction

• The role that analytics plays in financial forecasting

1. The Basics

• What is analytics?
• Business intelligence and company financials
• Conventional financial forecasting
• Basics of financial regression analysis
• Predict values with regression analysis
• Doing a forecast in Excel

2. Financial Metrics

• Financial forecasting applications
• Using data in Excel
• Decision-making with data

3. Forecasting in Finance

• Decide on a finance question
• Gather financial data
• Clean financial data

4. Performing Forecasting

• Applied forecasting with data
• Regressions for forecasting
• Using Excel for regressions

5. Interpret Forecast Results

• What do the results mean?
• Confidence intervals around the result
• Stress testing the results

Conclusion

• Continuing your financial forecasting learning path