Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Excel Data Analysis: Forecasting

via LinkedIn Learning

Go to class Write review

Overview

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

Syllabus

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

Taught by

Wayne Winston

Reviews

4.7 rating at LinkedIn Learning based on 1762 ratings

Start your review of Excel Data Analysis: Forecasting