1 CPE This course is a premium course it can be accessed either by individual purchase or through a premium subscription
Purchase this course | $36
This 'hands on' course takes the theory from the course, "Using Regressions for Forecasting", and puts it into practice. The goal is to allow participants to follow along with the instructor and run regressions for forecasting in Excel.
***Please download and open all supporting materials before starting the course videos.***
Learning Objectives
- Explore how to apply a regression to create a forecast
- Recognize how to interpret output from a regression
- Identify the limitations on regression-based forecasts
- Identify margin of error on regression-based forecasts
Last updated/reviewed: March 14, 2024
Included In Certifications
This course is included in the following Certification Programs:
15 CoursesData Analytics Professional (DAP) Certification
- The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
- How is Industry Using Big Data? – A Case Study Reading
- Business Intelligence - Data Collection and Cleaning
- Business Intelligence - Structuring Data for Analysis
- Business Intelligence - Fundamentals of Data Analysis
- Business Intelligence - Using Big Data Analytics
- Doing Data Analytics In Excel (Hands-on module)
- Regressions in Excel (Hands-on module)
- Financial Forecasting
- Advanced Analytics – Omitted Variables
- Advanced Analytics – Fixed Effects
- Case Study in Data Analytics
- Using Regressions for Forecasting
- Financial Forecasting in Excel (Hands-on module)
- Blockchain for Business
28 Reviews (224 ratings)
Reviews
Lawrence DeParis
(Founder & CEO at C-Level Solutions LLC)
Another excellent course from Mr. McDonald. One suggestion for improvement...
In the final segment a "discount rate" variable was included. This variable was not clearly explained, yet had by far the greatest impact on the projected sales figure. It increased the sales projection almost three-fold, an impact of $971M on a base of $371M of sales.
It would be helpful to either exclude this variable or spend a bit of time explaining why it can be valid given its overwhelming influence on the sales projection.
Devery Adair
(CFO at PLI Industries LLC)
Really like going through the hands on exercises. The in-depth explanations were helpful in understanding the different types of methods and the reasoning for preferring regression to other more simplified methods. Needed understanding of some of the use of terminology, but overall a great hands on treatment of the subject matter.
Quentin Johns
(Financial Consultant at DLC Group)
The course was great. It gives me another avenue to use for forecasting. I usually us CAGRs but this is good insights into regression that could be used to forecast different financial variables. Eventhough the variables are a catch all, give light to different types of analysis that could be performed.
Sheilla Rukundo
(Student at Lehigh University)
The material was straight forward, and well explained. super helpful for anyone trying to build a forecasting model. I was not sure about where to start, but from watching the sales example, I am confident building a revenue forecast model for my internship
Anonymous
(Associate)
This course builds on prior materials and shows an example in excel. The second example was a little slow in delivery, but the first to analyze the thief was interesting and effective to show the power of regressions.
Anonymous
(Consultant)
Once again a knowledge of the exam questions is dependent on the participants enrollment in other programs within this certification program. Useful information but not connection to final exam questions.
Anonymous
(Director of Accounting)
Good hands-on course to put into practice the teaching from other training in the program. Make sure to take the explanatory course before taking this hands-on course.
Anonymous
(Senior Internal Auditor)
The course was very challenging, however, the instructor was very effective in presenting course materials. The time allotted for the course was sufficient as well.
Anonymous
(Senior Auditor)
The hands on examples were helpful in clarifying the steps needed to conduct a regression analysis with better results and more confidence in decisions.
Anonymous
(Director)
It has been awhile since I took this type of course in college. Instructed suggested that you take other course first - it would be helpful.
Dan Bianculli
(Senior Associate at Grant Thornton Public Sector)
great course. it was very helpful in learning the theory behind financial forecasting. would prefer a few more hands on exercises.
Rose Gingrich
(State Report at GCCS)
Thank you instructor for the grate material and topics explanations, it makes the course easy and motivate to continue study.
Anonymous
(Tax Associate)
I really loved the employee embezzlement example. I never thought of using regression for that particular purpose.
Tyler Hooks
(Derivatives Intern at Novelis)
Good introduction to regressions in excel. Clean explanations of each field generated by the excel regression tool.
Anonymous
(Tax Associate)
Michael was able to deliver the financial forecasting material in a way that was easy to understand and enjoyable.
Robert Storrick
(Senior Associate at Grant Thornton)
Really loved this course. Much thanks to Grant Thornton for making the video and the instructor available.
Anonymous
(Consultant)
Excel examples were useful and I can see the relevance that can be used by lessons taught in this course.
Anonymous
(Senior Associate)
This course was useful in allowing us to work alongside the instructor and see the steps in excel.
Anonymous
(International Tax Sr. Associate)
Course was informative and easy to navigate. I would recommend to a colleague.
Anonymous
(Associate)
Course was informative and easy to navigate. I would recommend to a colleague.
Perry Byrd
( at Perry Byrd CPA)
Good course. Each step was well explained. I wood recommend this course.
Anonymous
(Data Scientist)
needs much better supporting documentation and not just the glossary
Anonymous
(Internal Audit Manager)
Enjoyed the examples given - easy to follow and understand.
Anonymous
(Staff Accountant)
This was a great course. I will recommend it to coworkers.
Anonymous
(Audit Services Manager)
Very good class, informative materials and well presented
Anonymous
(Tax associate)
Very good module and hands on learning video and slides
Paul Gallagher
(Tax Associate at Grant Thornton)
Everything about this course was absolutely fantastic.
Anonymous
(Sr. Associate)
The real life examples were helpful to walk through
Prerequisites
Course Complexity: Intermediate
Viewers should be familiar with basic financial and accounting concepts. In addition, viewers should be familiar with Big Data and Business Intelligence, or review my existing courses on the topic. Familiarity with and access to Excel will be helpful.
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA
95113
Contact:
For more information regarding this course, including complaint and
cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to
.
Michael McDonaldPresident
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 1608 W Campbell
- Av #221, Campbell, CA 95008
© 2024 Illumeo, Inc.