2 CPE This course gives participants the tools to be able to run regressions Excel and make forecasts based on those regressions. Starting from scratch, participants get direct practice in gathering business data from publicly traded companies.
***Please download and open all supporting materials before starting the course videos.***
Learning Objectives
- Discover how to gather business data from online sources at no cost
- Discover how to combine datasets into an easy to use format
- Discover how to run regressions based on the data
- Recognize how to interpret the regressions
- Explore how to form forecasts forecasts based on regressions
- Discover how to determine the margin of error around any regression forecast
- Explore how to run scenario analysis and produce output statistics that indicate how confident users of a regression forecast should be.
Last updated/reviewed: August 21, 2023
- 1. Introduction to Power BI and Excel-based Alternatives
- 2. Excel Efficiency: Error Prompts Explained
- 3. Excel Training: Skills for Better Workbook Design
- 4. Master Google Sheets Basics in 60 Minutes or Less
- 5. Excel Efficiency: Internal Controls
- 6. Excel Efficiency: Intro to Macros Part 2
- 7. Excel Efficiency: Spreadsheet Auditing Part 2
- 8. Power Query 2: Building an Instant Consolidation
- 9. Excel Efficiency: Office 365
- 10. Financial Modeling Using Excel
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
39 Reviews (268 ratings)
Reviews
Devery Adair
(CFO at PLI Industries LLC)
Course had lots of great examples. Great pace. I am used to having notes with the course. This hands on approach was great. To obtain greater understanding of what the instructor wanted us to take away it would be great to have notes that would emphasize the key things he wanted us to note about using regression analysis. While taking the exam I encountered some things that were not apparent from hearing the lecture. I will have to do my research to further on those topics.
Jesse Hale
(Staff Auditor at CBP DHS GOV)
Mr McDonald moves at a fast pace; however, there are many individual skills apart from regressions I became more familiar with through this course. Specifically, I now understand IF statements and Is Number statements better.
Anonymous
(Senior Associate)
The questions in this module's test were bordering on incoherent. It would be preferable if the questions tested our knowledge instead of our ability to decipher cryptically worded questions with grammatical errors.
Anonymous
(Senior Associate)
Being able to work through regressions in excel was helpful, however I think it would have been beneficial to have an overview course on the different regression statistics and how they can be interpreted.
Anonymous
(Tax Associate)
Regression in excel is very helpful to analyze dummy data. I would like to recommend this course to anyone who is working on analyzing data. By learning this skill is helpful to increase work efficiency.
Alejandra Chacon
(Snr.Assistant Controller at Oracle + NetSuite)
Very good classes, the professor is excellent, and is neccesary to go deeper in the statistical knoledge and try several exercices, is a very interest campus the data analitics.
Anonymous
(Associate)
Material was helpful in showing how to use regressions in excel. Some of the step by step instructions on button clicks and formulas made understanding the material easier.
Anonymous
(Senior Auditor)
The hands on module for regression analysis was great in clarifying the regression analysis methodology and the different elements affecting the results of the analysis.
Anonymous
(senior tax associate)
Overall, the course was a little hefty with the amount of data examples going on. However, it was very nice to do a hands on module and follow along with the instructor.
Anonymous
(Data Scientist)
There is no supporting slide deck and the verbiage is clearly geared towards an economics background not necessarily a math or statistics background in general
Mary Pat Brady
(Manager at Grant Thornton)
Overall a good course but some of the examples were performed in excel too quickly to replicate. Also, the exam questions did not relate well to the content.
Anonymous
(Tax Associate)
The test questions were unclear and included spelling and grammatical errors. However, I thought it was nice to have hands-on lesson with multiple examples.
Anonymous
(Tax Associate)
The statistical knowledge included in this course is beneficial to increase personal knowledge of items that can increase business analytics
Anonymous
(Consultant)
this course was great to do hands on regression but there is no training on how to do the regression graph. However I still learnt a lot!
Josh Schmitt
(Tax Intern at Grant Thornton)
The hands-on part of this module was effective, but the final exam had some grammatical errors that made it more esoteric than necessary.
Anonymous
(Accountant)
I really like the hands on part of this course! You must take the previous course in order to really get the material.
Anonymous
(Senior Associate)
This course provided good insights and hands on experience for working with and understanding regression analysis.
Anonymous
(Tax Associate)
I appreciated how the instructor took his time in explaining definitions and how to manipulate the data.
Anonymous
(Tax Associate)
Michael was able to make a large volume of regression material easy to understand and enjoyable.
Anonymous
(Senior Tax Associate)
This course did a very good job of going in depth with its explanations of regression analysis.
Anonymous
(Senior Tax Associate)
Great course. Practical knowledge is contained in this course and is ready to put in use.
Paul Francom
( at N/A)
I learned a lot, but the test questions were out in left field and there are no slides.
Anonymous
(Tax Associate)
this one, although hands on, was dry and difficult to hold my attention the entire time
Anonymous
(CPA Controller CFO)
Concise review of the logic of statistical analysis. Practical insight on how to.
Perry Byrd
( at Perry Byrd CPA)
Excellent course. I learned a great deal. Thanks for explaining in such detail.
Anonymous
(International Tax Sr. Associate)
Great hands on experience and example of how to do regression statistics in Excel
Anonymous
(Associate)
The interaction of this course is what made it more interesting to learn about.
Anonymous
(Tax Associate)
Great course. wish there was more time to learn. had hard time following along.
Anonymous
(Associate)
Course was informative and easy to navigate. I would recommend to a colleague.
Anonymous
(Tax associate)
Great final course to take that sums up data and analytics. good examples
Anonymous
(Staff Accountant)
Great information available in this course, will recommend to others.
Paul Whatley
(Lead IT Auditor at Gulfport Energy)
Very good refresher. It has been years since I looked at statistics.
Mike Barhydt
(Consultant at Tatum)
Final exam didn't really address to points emphasized in the program.
Anonymous
(Tax Associate)
really good overview of regression and how excel can be used for it
Anonymous
(Finance and IT Consultant)
Great course providing wealth of information on regression.
Alisa Gay
(Audit Services Manager at Southwestern Energy)
Very good class, informative materials and well presented
Paul Gallagher
(Tax Associate at Grant Thornton)
Everything about this course was absolutely fantastic.
Anonymous
(Senior Associate)
Good course. Would recommend. Great content and info.
Anonymous
(Sr. Associate)
going through the excel example I find very helpful
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
.
Course Questions and Answers1 Question
There are no questions. Answers to Frequently Asked Questions (FAQs)
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.