Time Series Forecasting in Excel

By the end of this course, learners will be able to apply forecasting concepts, analyze real-world datasets, detect seasonal trends, construct regression models, and predict future outcomes with Microsoft Excel. They will practice using weighted and exponential averages to capture data trends, explore correlations and regression analysis for deeper insights, and forecast scenarios such as climate projections and workforce attrition. Unlike generic Excel training, this course uniquely blends statistical forecasting techniques with practical applications across two high-impact domains: climate analysis and human resources (HR) analytics. Learners will work hands-on with authentic datasets, from climate emission scenarios to employee attrition records, ensuring they gain transferable, industry-relevant skills. Completing this course empowers participants to confidently visualize, interpret, and forecast time series data, enabling stronger decision-making for academic, professional, and research purposes. With Excel as the primary tool, learners gain accessible yet powerful forecasting expertise—no programming or advanced statistical software required

• Define forecasting concepts and analyze low, medium, and high emission scenarios
• Apply weighted and exponential averages for climate data forecasting
• Perform correlation and regression modeling to predict outcomes in Excel

• Basic computer and internet skills
• Ability to read course instructions in English and complete short practice activities