IBFIT03 - DATA ANALYSIS FUNDAMENTALS USING MICROSOFT EXCEL (IBF) by NTUC LearningHub

Course Overview

NTUC LearningHub Course Code: IBFIT03

IBF Programme Code: P210423ZWR

Microsoft Excel is a very widely used tool with many organizations and departments and being able to produce a quick analysis is an asset. This course provides participants with the knowledge and skills to work with and analyse data and work with business cases using Microsoft Excel. The objective is to familiarize the participants with the fundamentals of how to manage, transform and analyse data using the various functions in Excel.

Course Objectives

Upon completing this course, participants will be able to:

• Appreciate how data affects an organization
• Understand different types of data product
• Understand the project life cycle of data analytics
• Clean and transform data from different data sources
• Use Excel functions to join data, create calculated columns and add more value to analytics
• Create charts, reports and analyse data to gather business insights

Pre-requisites

• Knowledge, Skills & Experience
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Advanced working knowledge of Excel spreadsheets including formulas, such as Vlookup, and pivot tables
• Hardware & Software

Windows Laptop with Microsoft Office / Office 365 installed. MacOS hardware and laptop with Mac version of Office 365 are not recommended.

For Mac users, Bootcamp Windows 10 with PC version of Office 365 for MS Excel course is strongly recommended. This course will be conducted as a Virtual Live Class (VLC) via Zoom platform. Participants must have a laptop or a desktop with “Zoom Client for Meetings” installed. This can be downloaded from https://zoom.us/download

Course Outline

Basic Functions of MS Excel

• Exploring Excel Window and Cells
• Formatting Cells, Freezing & Conditional Formatting
• Excel built-in functions with categories
• Cross referencing functions – LOOKUPS

Reporting in Excel

• Creating Basic Charts
• Style Charts with Design Tabs
• Fine Tune Chart Elements
• The Creating a simple dashboard using various charts

Excel Tables

• Create Excel Tables
• Range vs Tables
• Summarizing Data
• Styling Tables
• Sorting and Filtering Tables
• Absolute References

Pivot Tables, Pivot Charts and Dashboards

• Creating Pivot Tables
• Sorting and Filtering Pivot Tables
• Formatting Pivot Tables
• Creating Pivot Charts
• Creating Dashboards

Data Models and Power Query

• ETL Concepts in Data Warehousing
• Process Automation
• Using an Excel Data model

Certificate Obtained and Conferred by

Candidate who successfully completed the course with

1. 100% attendance
2. Pass the assessment (Pass rate: 70%) will be awarded NTUC LearningHub Certificate of Completion.