К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Apply and Predict: Time Series Forecasting in Excel · LearnSpace
Назад в каталог
courseraАнализ данных

Apply and Predict: Time Series Forecasting in Excel

Курс от EDUCBA
Уровень не указан≈ 11.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Build practical time series forecasting skills in Microsoft Excel through real-world climate data. In Master Time Series Forecasting with Excel, you’ll begin with core forecasting concepts and learn to interpret temperature projections under low, medium, and high emission scenarios across the 21st century. Using Excel visualizations and charts, you’ll analyze trends and evaluate how projected outcomes change across scenarios. You’ll then apply weighted averages to minimum and maximum temperatures, compare results across emission scenarios, and use exponential averages to give greater emphasis to recent changes. The course also guides you through correlation analysis and simple and multiple regression models, helping you examine relationships between temperature variables and predict climate outcomes. Designed for learners seeking practical forecasting skills for academic, professional, or research applications, this course combines statistical methods, Excel tools, and multi-scenario climate datasets. Its focused use of climate projections sets it apart from a general Excel course. By the end, you’ll be able to visualize and interpret complex data, apply time series analysis techniques, construct regression models, and forecast future temperature outcomes with greater confidence.

Навыки, которые вы освоите

Time Series Analysis and ForecastingTrend AnalysisMicrosoft ExcelForecastingPredictive AnalyticsCorrelation AnalysisAnalytical SkillsStatistical MethodsExcel FormulasRegression AnalysisData Analysis SoftwareProbability & StatisticsStatistical AnalysisStatistical ModelingGraphingClimate Change ProgramsData AnalysisAnalysisPredictive ModelingData Manipulation

Программа курса

5 модулей · 65 учебных материалов

01Foundations of Forecasting in Excel14 материалов

Getting Started with Forecasting

Introduction to ProjectВидеоForecasting with ExcelВидеоGetting Started with ForecastingЗадание

Exploring Future Climate Scenarios (Part 1)

21st Century in Low Emission ScenarioВидео

Учитесь у экспертов

EDUCBA

Преподаватель курса

Apply and Predict: Time Series Forecasting in Excel
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 11.1 ч

5 модулей

Язык: Английский

Субтитры: Венгерский

Часть программы вашего университета
21st Century in Low Emission Scenario ContinueВидео
21st Century in Medium Emission ScenarioВидео
Exploring Future Climate Scenarios (Part 1)Задание

Exploring Future Climate Scenarios (Part 2)

21st Century in Medium Emission Scenario ContinueВидео21st Century in High Emission ScenarioВидео21st Century in High Emission Scenario ContinueВидеоExploring Future Climate Scenarios (Part 2)ЗаданиеForecasting Climate Futures with Excel: Low, Medium, and High Emission ScenariosDIALOGUEGraded - Foundations of Forecasting in ExcelЗаданиеAnalyzing 21st Century Climate Scenarios Using Excel ForecastingDIALOGUE
02Advanced Temperature Forecasting Techniques14 материалов

Weighted Averages for Climate Insights

Calculating Annual Minimum Temperature Average LESВидеоWeighted Average Maximum Temperature LESВидеоWeighted Average Minimum TemperatureВидеоWeighted Averages for Climate InsightsЗадание

Weighted Averages Across Scenarios

Weighted Average Temperature 2A and 2BВидеоWeighted Average Max Temperature MESВидеоWeighted Average Minimum Temperature HESВидеоWeighted Average Max Temperature HESВидеоWeighted Averages Across ScenariosЗадание

Exponential Averages for Scenario Forecasting

Exponential Average Minimum Temperature Best ScenarioВидеоExponential Average Maximum Temperature Best Scenario ContinueВидеоExponential Average Minimum Temperature Normal ScenarioВидеоExponential Averages for Scenario ForecastingЗаданиеGraded - Advanced Temperature Forecasting TechniquesЗадание
03Correlations & Regression Models13 материалов

Exponential Forecasting in Challenging Scenarios

Exponential Average Maximum Temperature Normal Scenario ContinueВидеоExponential Average Minimum Temperature Worst ScenarioВидеоExponential Average Maximum Temperature Worst Scenario ContinueВидеоExponential Forecasting in Challenging ScenariosЗадание

Exploring Correlations Across Scenarios

Correlated MES Min and Max TemperatureВидеоCorrelated HES Min and Max TemperatureВидеоExploring Correlations Across ScenariosЗадание

Building Regression Models for Prediction

Simple Regression LES and HES Max TemperatureВидеоSimple Regression MES and Max TemperatureВидеоSimple Regression HES and Max TemperatureВидеоMultiple Regression Range PredictionВидеоBuilding Regression Models for PredictionЗаданиеGraded - Correlations & Regression ModelsЗадание
04Foundations of Time Series in Excel10 материалов

Project Setup and Data Preparation

Introduction to ProjectВидеоEmployee DataВидеоFormula Part 1ВидеоFormula Part 2ВидеоProject Setup and Data Preparation Задание

Formulas & Core Attrition Analysis

Formula Part 3ВидеоOverall AttritionВидео Quarter AttritionВидеоFormulas & Core Attrition Analysis ЗаданиеFoundations of Time Series in ExcelЗадание
05Trend Analysis, Seasonality & Forecasting14 материалов

Trend Lines & Moving Averages

Quarter Attrition Trend Line ChartВидеоMoving AverageВидеоMoving Average ContinueВидеоTrend Lines & Moving Averages Задание

Seasonality Deep Dive

Seasonality Part 1ВидеоSeasonality Part 2ВидеоSeasonality Part 3Видео Seasonality Deep Dive Задание

Forecasting & Level Modeling

ForecastingВидеоDepartmentВидеоLevel ModelВидеоForecasting & Level Modeling ЗаданиеTrend Analysis, Seasonality & ForecastingЗаданиеForecasting Climate and Workforce Trends Using ExcelDIALOGUE