Predictive Analytics Using EXCEL

  • Program Overview
  • 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
  • In-depth knowledge of data collection and data preprocessing for Machine Learning Linear Regression problem
  • Course contains an end-to-end DIY project to implement your learnings from the lectures


Hours 18

The Main Outlines

Getting Data Ready for Regression Model

Outlier Treatment

Univariate analysis and EDD

Identifying and Treating Outliers in Excel

Descriptive vs Predictive vs Prescriptive Analytics

Missing Value Imputation

Descriptive Data Analytics in Excel

Identifying and treating missing values in Excel

Variable Transformation in Excel

Dummy variable creation: Handling qualitative data

Dummy Variable Creation in Excel

Correlation Analysis

Correlation Coefficient in Excel

Creating Correlation Matrix in Excel

Other Branches

Contact us

33 El Messaha Street, Dokki A, Dokki, Giza, Egypt

P.O Box 12611



This email address is being protected from spambots. You need JavaScript enabled to view it.

Contact information

  • dummy33 El Messaha Street, Dokki A, Dokki, Giza Governorate, Egypt

  • dummyP.O Box 12611

  • dummy 16541 - +2 02 33318498

  • dummy+2 02 37497928


Our site on Google map