Data Analytics and Visualizations using Microsoft Excel

Program Information

Duration:

2 Days

Time:

9.00 AM - 5.00 PM

Fees:

RM 2,800 (Classroom)
RM 1,600 (Online)

Course Date:

27 & 28 June 2022 (Classroom)
18 & 19 July 2022 (Online)

Program Overview

Get the most from Microsoft Excel!

Microsoft Excel is widely used in industries, education sectors and business organizations. Excel is user friendly and serves as a tool for data analysis. This course provides introduction to the basic functions of Excel as well as performing data analysis using statistical techniques to gain insights from data. The ultimate of the course would be creating the dashboard for the visualisation of the data. The course is designed for those who have little knowledge of using Excel and also for those who use Excel regularly and want to enhance their skills in using Excel.

Is this course for you?

This course covers basic operations in Excel, such as reading data from various data formats, organizing and managing data, data exploration through creative visualization charts to more advanced functionality of Excel in data analysis. Participants will acquire the skills of using Excel through hands-on and step-by-step instructions using easy-to-understand examples and illustrations. These skills will be useful for analysing data for real practical problems.

All our short courses are under HRDCorp claimable course (SBL-Khas) scheme, subject to prior application to HRD Corp by the employers/companies.

Program No: 10001177378
Provider Name: Malaysia Logistics Innovation Berhad
Training Provider ID No: 936566

Curriculum

Day 1

Session 1

Data Exploratory and Data Handling using Pivot Table (1.5 hours)
The participants will be exposed to excel spreadsheets and will learn how to work with the formulas and functions. For exploring and data handling, participants will be introduced to pivot tables as a data summarization tool. It is one of the most important and widely used features available in Excel.

Session 2

Descriptive Analysis and Excel Charting (2 hours)
In this session, participants will be guided to basic descriptive statistics such as statistics summary and how to visualize data as appropriate graphics.

Session 3

Data Analysis (2.5 hours)
Participants will explore the data analysis tools available in Excel to conduct data analysis such as a simple hypothesis testing, correlation and regression analysis.

Day 2

Session 4

Introduction Excel Dashboards (1.5 hours)
The participants will be introduced with an Excel dashboard which is as good as any other analytics tools.

Session 5

Interactive Excel Charting and Formula for Dashboard (2 hours)
Using Pivot Table to create Pivot Chart and converting ready charts into an interactive and self-explanatory dashboard. Participants will be taught how to create interactive formulas into the dashboard to make it more appealing and informative.

Session 6

Case Studies – Create your own Dashboard (2.5 hours)
The participants will be given a set of data as a case study. The participants need to apply their knowledge gained from the course to analyse and prepare an appealing visualization / dashboard to potential end users.

Trainers & Industry Experts

Prof. Dr. Ts. Ahmad Zia Ul-Saufie Bin Mohamad Japeri

Associate Professor, Faculty of Computer and Mathematical Sciences Universiti Teknologi Mara (UiTM)

Aida Wati Zainan Abidin

Lecturer, Faculty of Computer and Mathematical Sciences Universiti Teknologi Mara (UiTM)

Get More Information

MISI University
No. 2A, Persiaran Tebar Layar,
Seksyen U8, Bukit Jelutong, Shah Alam,
40150 Selangor, Malaysia.

Short Courses: