Excel Analytics: Linear Regression Analysis in MS Excel

Linear Regression analysis in Excel. Analytics in Excel includes regression analysis, Goal seek and What-if analysis

4.49 (763 reviews)
Data & Analytics
3.5 hours
Jul 2022
last update
regular price

What you will learn

Learn how to solve real life problem using the Linear Regression technique

Preliminary analysis of data using Univariate analysis before running Linear regression

Predict future outcomes basis past data by implementing Simplest Machine Learning algorithm

Understand how to interpret the result of Linear Regression model and translate them into actionable insight

Indepth knowledge of data collection and data preprocessing for Machine Learning Linear Regression problem

Course contains a end-to-end DIY project to implement your learnings from the lectures


You're looking for a complete Linear Regression course that teaches you everything you need to create a Linear Regression model in Excel, right?

You've found the right Linear Regression course!

After completing this course you will be able to:

· Identify the business problem which can be solved using linear regression technique of Machine Learning.

· Create a linear regression model in Excel and analyze its result.

· Confidently practice, discuss and understand Machine Learning concepts

How this course will help you?

A Verifiable Certificate of Completion is presented to all students who undertake this Machine learning basics course.

If you are a business manager or an executive, or a student who wants to learn and apply machine learning in Real world problems of business, this course will give you a solid base for that by teaching you the most popular technique of machine learning, which is Linear Regression

Why should you choose this course?

This course covers all the steps that one should take while solving a business problem through linear regression.

Most courses only focus on teaching how to run the analysis but we believe that what happens before and after running analysis is even more important i.e. before running analysis it is very important that you have the right data and do some pre-processing on it. And after running analysis, you should be able to judge how good your model is and interpret the results to actually be able to help your business.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. As managers in Global Analytics Consulting firm, we have helped businesses solve their business problem using machine learning techniques and we have used our experience to include the practical aspects of data analysis in this course

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

This is very good, i love the fact the all explanation given can be understood by a layman - Joshua

Thank you Author for this wonderful course. You are the best and this course is worth any price. - Daisy

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there are class notes attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning.

What is covered in this course?

This course teaches you all the steps of creating a Linear Regression model, which is the most popular Machine Learning model, to solve business problems.

Below are the course contents of this course on Linear Regression:

· Section 1 - Basics of Statistics

This section is divided into five different lectures starting from types of data then types of statistics

then graphical representations to describe the data and then a lecture on measures of center like mean

median and mode and lastly measures of dispersion like range and standard deviation

· Section 2 - Data Preprocessing

In this section you will learn what actions you need to take a step by step to get the data and then

prepare it for the analysis these steps are very important.

We start with understanding the importance of business knowledge then we will see how to do data exploration. We learn how to do uni-variate analysis and bi-variate analysis then we cover topics like outlier treatment, missing value imputation, variable transformation and correlation.

· Section 3 - Regression Model

This section starts with simple linear regression and then covers multiple linear regression.

We have covered the basic theory behind each concept without getting too mathematical about it so that you

understand where the concept is coming from and how it is important. But even if you don't understand

it, it will be okay as long as you learn how to run and interpret the result as taught in the practical lectures.

We also look at how to quantify models accuracy, what is the meaning of F statistic, how categorical variables in the independent variables dataset are interpreted in the results, what are other variations to the ordinary least squared method and how do we finally interpret the result to find out the answer to a business problem.

By the end of this course, your confidence in creating a regression model in R will soar. You'll have a thorough understanding of how to use regression modelling to create predictive models and solve business problems.

Go ahead and click the enroll button, and I'll see you in lesson 1!


Start-Tech Academy


Below is a list of popular FAQs of students who want to start their Machine learning journey-

What is Machine Learning?

Machine Learning is a field of computer science which gives the computer the ability to learn without being explicitly programmed. It is a branch of artificial intelligence based on the idea that systems can learn from data, identify patterns and make decisions with minimal human intervention.

What is the Linear regression technique of Machine learning?

Linear Regression is a simple machine learning model for regression problems, i.e., when the target variable is a real value.

Linear regression is a linear model, e.g. a model that assumes a linear relationship between the input variables (x) and the single output variable (y). More specifically, that y can be calculated from a linear combination of the input variables (x).

When there is a single input variable (x), the method is referred to as simple linear regression.

When there are multiple input variables, the method is known as multiple linear regression.

Why learn Linear regression technique of Machine learning?

There are four reasons to learn Linear regression technique of Machine learning:

1. Linear Regression is the most popular machine learning technique

2. Linear Regression has fairly good prediction accuracy

3. Linear Regression is simple to implement and easy to interpret

4. It gives you a firm base to start learning other advanced techniques of Machine Learning

How much time does it take to learn Linear regression technique of machine learning?

Linear Regression is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn Linear regression starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to remember whatever you have learnt. Therefore, we have also provided you with another data set to work on as a separate project of Linear regression.

What are the steps I should follow to be able to build a Machine Learning model?

You can divide your learning process into 4 parts:

Statistics and Probability - Implementing Machine learning techniques require basic knowledge of Statistics and probability concepts. Second section of the course covers this part.

Understanding of Machine learning - Fourth section helps you understand the terms and concepts associated with Machine learning and gives you the steps to be followed to build a machine learning model

Programming Experience - A significant part of machine learning is programming. Python and R clearly stand out to be the leaders in the recent days. Third section will help you set up the R environment and teach you some basic operations. In later sections there is a video on how to implement each concept taught in theory lecture in R

Understanding of Linear Regression modelling - Having a good knowledge of Linear Regression gives you a solid understanding of how machine learning works. Even though Linear regression is the simplest technique of Machine learning, it is still the most popular one with fairly good prediction ability. Fifth and sixth section cover Linear regression topic end-to-end and with each theory lecture comes a corresponding practical lecture in R where we actually run each query with you.


Excel Analytics: Linear Regression Analysis in MS Excel - Screenshot_01Excel Analytics: Linear Regression Analysis in MS Excel - Screenshot_02Excel Analytics: Linear Regression Analysis in MS Excel - Screenshot_03Excel Analytics: Linear Regression Analysis in MS Excel - Screenshot_04


Getting Data Ready for Regression Model

Gathering Business Knowledge
Data Exploration
Course resources
The Data and the Data Dictionary
Univariate analysis and EDD
Discriptive Data Analytics in Excel
Outlier Treatment
Identifying and Treating Outliers in Excel
Missing Value Imputation
Identifying and Treating missing values in Excel
Variable Transformation in Excel
Dummy variable creation: Handling qualitative data
Dummy Variable Creation in Excel
Correlation Analysis
Creating Correlation Matrix in Excel

Creating Regression Model

The Problem Statement
Basic Equations and Ordinary Least Squares (OLS) method
Assessing accuracy of predicted coefficients
Assessing Model Accuracy: RSE and R squared
Creating Simple Linear Regression model
Multiple Linear Regression
The F - statistic
Interpreting results of Categorical variables
Creating Multiple Linear Regression model
Excel: Running Linear Regression using Solver

What-if analysis

Transportation Problem in Excel using Goal Seek

Bonus Section

Bonus Lecture


April 6, 2022
It is way better than any course I have ever taken on Udemy. Cannot stress enough how great of a job they have done putting together exactly what you need to now.
March 24, 2022
Good explaination of all concepts but concepts like RSS, p value were little bit confusing. Overall, it was nice.
January 30, 2022
Regression as in excel 9/10 Efforts: 8/10 Basics of regression 5/10 No explanation of terms like t value, pr value, etc.
June 19, 2021
Amazing grip over the concepts and loved the detailing especially Multiple Regression and doing it again using Solver. Crisp and Clear...!
June 4, 2021
This course is great for practical knowledge of regression analysis. If you don't want to spend too much time on the math behind regression analysis and want to get straight to your business problem, here ya go.
March 15, 2021
This course is very well organized. The presenter explains everything in a way in which all of the information is easily absorbed. I also enjoyed the examples used as they gave me a greater understanding of how the concepts relate to the real word, 5 stars.
February 19, 2021
Good course, i was a little bit lost when the mathematical formulas of linear regression appear, not because they are complex, but because im not accustomed to the mathematical syntax.
February 11, 2021
One of the good course for those who want to learn Data Analysis tool and make career in data Analytic .
January 27, 2021
The lessons are well explained and after a theory lesson there is always a practical lesson to use all the concepts
May 9, 2020
The course provided great insights. However, it would have been great had the instructor delved into some of the basic of statistics part
April 20, 2020
I like the course from the beginning to the end. I can confidently say the tutor has done a great job.
April 18, 2020
I will recommend this wonderful course to every beginner. It simply well structure course,starting from basic to advance level. Thank You very much Udemy as well as instructor for such nice course.
April 18, 2020
I am learning new things so that i think it is better for me and all I learnt lots of knowledge about linear regression analysis in ms excel
April 12, 2020
It was undoubtedly a wonderful course. The teacher has great experience in this field I must say. I have learned something special which I will implement in my professional life. Thank you Udemy.
April 3, 2020
I don't understand the accent well. It's very distracting form the material and I find myself getting overwhelmed trying to read the caption and slides at the same time



Excel Analytics: Linear Regression Analysis in MS Excel - Price chart


Excel Analytics: Linear Regression Analysis in MS Excel - Ratings chart

Enrollment distribution

Excel Analytics: Linear Regression Analysis in MS Excel - Distribution chart


8/20/2019100% OFF
11/25/2019100% OFF
1/20/2020100% OFF
3/6/2020100% OFF
4/10/2020100% OFF
4/17/2020100% OFF
4/25/2020100% OFF
5/2/2020100% OFF
5/12/2020100% OFF
5/19/2020100% OFF
6/1/2020100% OFF
6/18/2020100% OFF
7/8/2020100% OFF
8/1/2020100% OFF
8/29/2020100% OFF
9/19/2020100% OFF
10/11/2020100% OFF
10/20/2020100% OFF
11/1/2020100% OFF
11/4/2020100% OFF
12/25/2020100% OFF
1/13/2021100% OFF
2/18/2022100% OFF
4/19/2022100% OFF
4/25/2022100% OFF
4/26/2022100% OFF
5/12/2022100% OFF
5/24/2022100% OFF
5/27/2022100% OFF
6/13/2022100% OFF
6/19/2022100% OFF
7/13/2022100% OFF
7/25/2022100% OFF
7/29/2022100% OFF
udemy ID
course created date
course indexed date
course submited by