Generate Insights with Business Forecasting

4.8

stars

155 ratings

Dr Prashan S. M. Karunaratne

4,758 already enrolled

Offered By

Excel Skills for Business Forecasting SpecializationMacquarie University

Skills you will gain

About this Specialization

4,436 recent views

The current state of the world makes business forecasting even more fundamental to the operation of institutions. In this Specialization we focus on Excel Skills for Business Forecasting in three courses — Time Series Models, Regression Models, and Judgmental Forecasting. In the first course on Time Series Models, we will be looking at how your business can utilise time series data sets to understand the different components underlying this data, and then apply the relevant model depending on these components to forecast for your business' needs. We then continue in our second course in this specialisation which looks at Regression Models, building causal models for both time series data as well as cross-sectional data. Causal models allow us to develop further business insights and strategy by controlling the inputs to generate the output we desire. In the third and final course, we explore the role of Judgmental Forecasting, when more quantitative forecasting methods have limitations, and we need to generate further business insights. We will be exploring some structured methodologies to create judgmental business forecasts and explore how Excel can assist us in these judgments. We will bring all these forecasting methods together in a final case study, giving you the opportunity to generate forecasts, which are the inputs to any organisation's planning.

Applied Learning Project

Working with datasets similar to those typically found in a business, you will use quantitative and qualitative forecasting techniques to generate business forecasts. Create charts to visualise data and forecasts. Calculate model errors and use optimisation techniques to minimise these errors and choose the best model parameters. Combine different models and expert judgment to incorporate uncertainty.

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Flexible Schedule

Set and maintain flexible deadlines.

Intermediate Level

Approximately 4 months to complete

Suggested pace of 2 hours/week

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Flexible Schedule

Set and maintain flexible deadlines.

Intermediate Level

Approximately 4 months to complete

Suggested pace of 2 hours/week

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

How the Specialization Works

Take Courses

A Coursera Specialization is a series of courses that helps you master a skill. To begin, enroll in the Specialization directly, or review its courses and choose the one you'd like to start with. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. It’s okay to complete just one course — you can pause your learning or end your subscription at any time. Visit your learner dashboard to track your course enrollments and your progress.

Hands-on Project

Every Specialization includes a hands-on project. You'll need to successfully finish the project(s) to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you'll need to finish each of the other courses before you can start it.

Earn a Certificate

When you finish every course and complete the hands-on project, you'll earn a Certificate that you can share with prospective employers and your professional network.

There are 3 Courses in this Specialization

Course1

Course 1

Excel Time Series Models for Business Forecasting

4.9

stars

148 ratings

This course explores different time series business forecasting methods. The course covers a variety of business forecasting methods for different types of components present in time series data — level, trending, and seasonal. We will learn about the theoretical methods and apply these methods to business data using Microsoft Excel. These forecasting methods will be programmed into Microsoft Excel, displayed graphically, and we will optimise these models to produce accurate forecasts. We will compare different models and their forecasts to decide which model best suits our business' needs.

Course2

Course 2

Excel Regression Models for Business Forecasting

4.9

stars

64 ratings

This course allows learners to explore Regression Models in order to utilise these models for business forecasting. Unlike Time Series Models, Regression Models are causal models, where we identify certain variables in our business that influence other variables. Regressions model this causality, and then we can use these models in order to forecast, and then plan for our business' needs. We will explore simple regression models, multiple regression models, dummy variable regressions, seasonal variable regressions, as well as autoregressions. Each of these are different forms of regression models, tailored to unique business scenarios, in order to forecast and generate business intelligence for organisations.

Course3

Course 3

Judgmental Business Forecasting in Excel

4.4

stars

32 ratings

In this course, we extend your business forecasting expertise from the first two courses of our Business Forecasting Specialisation on Time Series Models and Regression Models. We will explore the role of judgmental forecasting, when more quantitative forecasting methods have limitations, and we need to generate further business insights. We will be exploring some structured methodologies to create judgmental business forecasts using Business Indicators, Subjective Assessment Methods, and Exploratory Methods. For each of these methods, we will look at how we can use Excel to help us in achieving these judgmental forecasts and how Excel can help us visualising our forecast findings. Being judgmental forecasting methods, we will also look at the role of biases in Business Forecasting,

Instructor

Dr Prashan S. M. Karunaratne

Senior Lecturer - Teaching & Leadership | FHEA

Department of Actuarial Studies and Business Analytics, Macquarie Business School

1,073,568 Learners

23 Courses

Offered by

Macquarie University

Frequently Asked Questions

What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Can I just enroll in a single course?
Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate, or you can audit it to view the course materials for free. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. Visit your learner dashboard to track your progress.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
Can I take the course for free?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. If you only want to read and view the course content, you can audit the course for free. If you cannot afford the fee, you can apply for financial aid.
Is this course really 100% online? Do I need to attend any classes in person?
This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.
Will I earn university credit for completing the Specialization?
This Specialization doesn't carry university credit, but some universities may choose to accept Specialization Certificates for credit. Check with your institution to learn more.
How long does it take to complete the Specialization?
Over the 3 courses there are 13 modules of content in total. Each module should take 2-5 hours to complete, including watching the videos, doing the quizzes, and working through the assessment.
What background knowledge is necessary?
You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas. If you need a refresher, you could do our course Excel Fundamentals for Data Analysis.
Do I need to take the courses in a specific order?
Time Series Models and Regression Models can be taken in any order, but you should do both before attempting Judgmental Forecasting as it uses techniques from these courses.
What will I be able to do upon completing the Specialization?
You will be able to transform Time Series and Cross-Sectional data sets into components that produce business insights and forecasts. You will understand how Time Series and Regression Models work and how to create these models to produce robust forecasts. You will learn how to critically analyse the data and the business context to apply structured Judgmental Forecasting methodologies to augment these forecasts.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Excel Skills for Business Forecasting Specialization

Skills you will gain

About this Specialization

Applied Learning Project