Machine Learning using Microsoft Excel

LEVEL: BEGINNER                    HRDF: CLAIMABLE 

Fifteen (15) CPD Hours approved by MBOT

TRAINERS: 

Associate Professor Dr. Hitham Seddig Alhassan Alhussian, Associate Professor Dr Said Jadid Abdul Kadir & Dr Noureen Talpur  

 

4 - 6 JUNE 2024

 

CAPE

Level 8, Permata Sapura, Kuala Lumpur City Centre, 50088 Kuala Lumpur

 

9.00AM - 5.00PM

 

RM 3,000 FOR PROFESSIONALS

10% Discount for Early Bird (until 4 May 2024) / Group / Students

CONTENT SUMMARY

INTRODUCTION

In this course we introduce methods for applying machine learning (ML) using Microsoft Excel as a tool. Machine learning has become attractive to a broad range of professionals, as it helps to reveal hidden patterns and provide a competitive advantage based on available data. Through this course, participants will master the fundamentals of ML and the capabilities it has to offer through Excel. This includes developing prediction models and understanding the results/insights for decision-making. The course is designed for non-technical participants from various fields.

COURSE CONTENT

Module 1 : Understanding Machine Learning and Excel Data Processing

  • Understanding ML and Excel
    • Intro to ML
    • Why use Excel
    • Types of ML in Excel

Module 2 : Data Preparation: Excel

  • Data preparation basics
    • Data exploration and preparation
    • Handle missing values, outliers, and categorical variables

Module 3 : Create and Deploy a Regression Model: Excel

  • Build a regression model
    • Regression model use cases
    • Perform linear regression.
    • Interpret and evaluate results. 
    • Visualize regression result
  • Case study 1:
    • Build a regression model.
    • Interpret results from regression model
  • Discussion

Module 4 : Create and Deploy a Classification Model: Excel

  • Build a classification model
    • Classification model use cases 
    • Perform classification
    • Interpret and evaluate results 
    • Visualize classification results
  • Case study 2:
    • Build a classification model
    • Interpret result from classification model

Module 5 : Create and Deploy a Clustering Model: Excel

  • Build a clustering model
    • Clustering model use cases
    • Perform clustering
    • Interpret and evaluate results 
    • Visualize clustering results
  • Case study 3:
    • Build a clustering model
    • Interpret result from clustering model
  • Discussion

Module 6 : Create and Deploy Decision Trees: Excel

  • Build a clustering model
    • Entropy (Loss function)
    • Information Gain
    • Decision Trees in Excel
    • Decision trees (Prediction)
  • Case study 3:
    • Build a decision tree
    • Interpret result from decision tree
  • Reflection
  • Conclusion

OBJECTIVES

Upon completion of this course, participants will be able to:

  • Understand the fundamentals of ML and its applications.
  • Analyze raw data and conduct simple data preparation for ML tasks.
  • Evaluate which ML techniques suitable for data.
  • Deploy ML model and solutions using Microsoft Excel.
  • Produce a ML solution and interpret outcome for suggesting actionable insights.


WHO SHOULD ATTEND?

  • Anyone interested in Excel
  • Managers and Executives 
  • Engineers, Researchers & Consultants 
  • Start-ups Company
  • Junior/Senior Lecturers





OUR TRAINERS

1. Associate Professor Dr. Hitham Seddig Alhassan Alhussian (UTP)

Dr Hitham Al-Hussian received his BSc and MSc in Computer Science from the School of Mathematical Sciences, University of Khartoum (UofK), Sudan. He obtained his PhD from Universiti Teknologi PETRONAS (UTP), Malaysia. Following his PhD, he worked as a Post Doctorate Researcher in the High-Performance Cloud Computing Center (HPC3) in UTP. He is currently, a Senior Lecturer in the department of Computer and Information Sciences in UTP and a core member of Centre for Research in Data Science (CERDAS). His main research interests include real-time parallel computing, big data and cloud computing, machine learning and data mining.

2. Associate Professor Dr Said Jadid Abdul Kadir  (UTP)

Dr. Said Jadid, is currently a Lecturer at the Department of Computer and Information Sciences, Universiti Teknologi PETRONAS (UTP). He holds a Degree in Computer Science from Moi University (2009), Master’s Degree in Computer Science from Universiti Teknologi Malaysia (2012) and a PhD in Information Technology from Universiti Teknologi PETRONAS (2016). His research interests are in the areas of Machine Learning (Supervised Learning) and Data Analytics (Predictive and Streaming Analytics). He has been appointed as a reviewer for Artificial Intelligence Review (Q2 Journal) and a technical committee for various international conferences. . 

COUNTDOWN

DaysHoursMinutesSeconds

REGISTRATION FEES

PROFESSIONALS

MYR3,000*

*fee quoted does not include SST, HRDF service fee, GST/VAT or withholding tax (if applicable).

EARLY BIRD/ GROUP/ STUDENT

MYR2,700*

*fee quoted does not include SST, HRDF service fee, GST/VAT or withholding tax (if applicable).

OUR LOCATION

Centre for Advanced & Professional Education (CAPE)

 Level 8, Permata Sapura, Kuala Lumpur City Centre, 50088 Kuala Lumpur​

CALL US

+605 - 368 7558 /

+605 - 368 8485

DROP US AN EMAIL

cape@utp.edu.my