Problem solving using EXCEL

(Intermediate Level)

LEVEL: INTERMEDIATE                    HRDF: CLAIMABLE 

Ten (10) CPD Hours approved by MBOT

TRAINERS: 

Ts Dr Norshakirah Abdul Aziz & Dr Hitham Al-Hussian 

 

7 - 8 AUGUST 2024

 

CAPE

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

 

9.00AM - 5.00PM

 

RM 2,500 FOR PROFESSIONALS

10% Discount for Early Bird (until 7 July 2024) / Group / Students

CONTENT SUMMARY

INTRODUCTION

This course is designed to expose the participants, with the concept, techniques, issues and challenges involved in data management focusing EXCEL as analytics tool. Exposure will also be provided to the participants on analytics using EXCEL. In particular, the participants would be able to examine the dataset and make possible analysis of large volumes of data at the end of the course.  At the same time, the course prepares the participants to be technically competent in analyzing and managing data. 

COURSE CONTENT

Module 1: 

Introduction to Data Management using EXCEL

  • What is Data Management
  • Fundamental of Data Cleansing/Data Preparation
  • Making sense of data

Module 2: 

Data Cleansing 

Data Management: Making sense of Data using EXCEL

  • Excel Worksheet Info
    • File properties
    • Customized Ribbon
  • Data Understanding & Data Cleansing/Preparation
    • Data Types
    • Remove duplicates
    • Find Errors with Go to Special Constants
    • Text to Columns: Dates
    • VLOOKUP
    • Power Query
  • Data Preparation 
    • Autofill
    • Sort & Filter
    • Filter Data
    • Pivot table
  • Data Visualization
    • Dashboard

Module 3: 

Data visualization using EXCEL

Insight to action 

  • Problem Solving using EXCEL
    • Working with Data & Macros
    • Formula & Function
    • Charts & Objects/Images
  • Insight
    • Case study 1
    • Case study 2
  • Group Presentation

OBJECTIVES

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

  • Perform EXCEL data cleansing
  • Perform analytics using EXCEL as data source 
  • Making sense of data from Insight to Action
  • Dashboard using EXCEL


AIM:

The course is aimed:

  • To offer the knowledge and skills to examine data management that allow analysis of large volumes of data in near real time.


WHO SHOULD ATTEND?

  • Clerk
  • Admin Assistant
  • Assistant Officer
  • Research Officer
  • Executive





OUR TRAINERS

1. Ts Dr Norshakirah Bt Abdul Aziz  (UTP)

Ts Dr Norshakirah Bt Abdul Aziz is a Senior Lecturer at the Computer and Information Sciences Department at Universiti Teknologi PETRONAS, Malaysia. Currently, she is a researcher at the UTP Centre of Research in Data Sciences (CeRDaS) and Data Governance Leader at High-Performance Cloud Computing Data Centre (HPCCC). She holds a Diploma in Management Technology, Bachelor's Degree in Information Technology (IT), MSc Degree in IT, and a PhD in e-SCM Integration & Collaboration. Also, she has a total of 16 years of experience gained from academic institutions and industry under her belt. Her industry working experience is related to Business Intelligence, E-Business, and IT Project Management. Her research scope covers Business Intelligence, Data Analytics, Data Governance, and Digital Addiction. Besides, she is a qualified Technologist Specialist (Ts), an HRDF Certified Trainer, and a present EXCO Committee Member for Data Science Association, Malaysia and also provided training to all management level for E-Procurement & E-Business short courses. 

2. Dr Hitham Al-Hussian  (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.

COUNTDOWN

DaysHoursMinutesSeconds

REGISTRATION FEES

PROFESSIONALS

MYR2,500*

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

EARLY BIRD/ GROUP/ STUDENT

MYR2,250*

*fee quoted does not include SST, GST, HRDF service fee / 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