Mastering Excel: Unleashing the Power of Forecasting

سرفصل های دوره

Excel's Forecasting: Techniques, Trends, and Insights

1. Introduction

1. Welcome Message

2. Exploring Time Series Data, Patterns, Trends, and Seasonality

1. Introducing Time Series Data

2. Exploring Data Visualization in Excel

3.1 S2 Exercise 1 Solution.xlsx

3.2 S2 Exercise 1.xlsx

3. Exercise 1 Plotting Data in Excel

4.1 S2 Exercise 2 Solution.xlsx

4. Exercise 2 Exploring Excel Chart Options

5. Understanding Trends

6.1 S2 Exercise 3 Solution.xlsx

6.2 S2 Exercise 3.xlsx

6. Exercise 3 Adding Trendlines to Time Series Plots

7. Section 2 Quiz.html

3. Understanding Seasonality, Noise, and Irregular Functions

1. Understanding Seasonality

2.1 S3 Exercise 4 Solution.xlsx

2.2 S3 Exercise 4.xlsx

2. Exercise 4 Applying Moving Average Trendline for Time Series Analysis

3. Understanding Noise and Irregular Fluctuations

4. Section 3 Quiz.html

4. Techniques and Tools for Forecasting

1. Forecasting with Equations

2.1 S4 Exercise 5 Solution.xlsx

2.2 S4 Exercise 5.xlsx

2. Exercise 5 Forecasting with Equations in Excel

3.1 S4 Forecast Sheet Demo.xlsx

3. Utilizing the Excel Forecasting Tool

4. Advanced Forecasting with the Excel ETS Function

5. Exercise 6 Implementing Forecast.ETS

6. Section 4 Quiz.html

5. Forecasting Accuracy Measures in Excel

1. Evaluating Forecasting Errors and Accuracy

2.1 S5 Exercise 7 Solution.xlsx

2.2 S5 Exercise 7.xlsx

2. Exercise 7 Calculating Error in Excel

3. Assessing Forecast Accuracy with MAE

4.1 S5 Exercise 8 Solution.xlsx

4. Exercise 8 Calculating MAE in Excel

5. Analyzing Forecast Error with MSE

6.1 S5 Exercise 9 Solution.xlsx

6. Exercise 9 Calculating MSE in Excel

7. A Comprehensive Accuracy Measure RMSE

8.1 S5 Exercise 10 Solution.xlsx

8. Exercise 10 Calculating RMSE in Excel

9. Evaluating Forecast Performance with MAPE

10. Exercise 11 Calculating MAPE in Excel

11. CD Purchase Forecast Recap

12. Section 5 Quiz.html

6. Additional Forecasting Measures

1. Understanding R-Squared

2. Handling Outliers

3. Section 6 Quiz.html

7. Bonus

1.1 LinkedIn Profile.html

1.2 Referral Links.html

1. Bonus Lecture

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training