DATA ANALYSIS FUNDAMENTALS USING MICROSOFT EXCEL (IBF)-P210423ZWR

DATA ANALYSIS FUNDAMENTALS USING MICROSOFT EXCEL (IBF)-P210423ZWR

Funded
Course Duration
15.0 hr(s)
Mode of Assessment

Participants will be required to complete written and practical assessment.

Who Should Attend

This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships, including but not limited to the following job roles:

  • Associate Data Analyst
  • Data Analyst
  • Data Officer
  • Associate Data Engineer
  • Data Engineer
  • Associate Data Scientist
  • Data Scientist
  • Business Analyst
  • Data Team Leader

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.

Next available schedule

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

Laptop with Microsoft Office / Office 365 installed. 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

Minimum Specs

Recommended Specs

Others

  • Internet Connection: Wired or Wireless broadband (min 10 mbps)
  • Speakers and Microphone: built-in or USB plug-in or wireless Bluetooth
  • Webcam: built-in or USB plug-in

Software

  • Microsoft Excel / MS Office 365

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.

Additional Details

Medium of Instruction: English

Trainer to Trainee Ratio is 1:20

Price

Course Fee:

For Classes commencing between 1st July 2021 to 31st Dec 2021

 

Individual Sponsored Trainee

Company Sponsored Trainee

before GST

with GST

before GST

with GST

Full Course Fee

$780.00

$834.60

$780.00

$834.60

Singapore Citizens and PRs
(after 90% funding)

$28.86

$83.46

$78.00

$132.60

Singapore Citizens aged 40 years and above
(after 90% funding)

$28.86

$83.46

$78.00

$132.60

       

For Classes commencing between 1st Jan 2022 to 30th Jun 2022

 

Individual Sponsored Trainee

Company Sponsored Trainee

before GST

with GST

before GST

with GST

Full Course Fee

$780.00

$834.60

$780.00

$834.60

Singapore Citizens and PRs
(after 80% funding)

$112.32

$166.92

$156.00

$210.60

Singapore Citizens aged 40 years and above
(after 90% funding)

$28.86

$83.46

$78.00

$132.60

Eligibility:

Individual Sponsored Trainee

Company Sponsored Trainee

  • Singapore Citizens or Singapore Permanent Residents physically based in Singapore
  • Trainee must achieve 100% attendance and pass all relevant assessments
  • NTUC LearningHub reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria
  • Singapore Citizens or Singapore Permanent Residents physically based in Singapore
  • Trainee must achieve 100% attendance and pass all relevant assessments
  • Sponsoring company must be
    • Singapore-based financial Institutions regulated by MAS (licensed or exempt from licensing by MAS)
    • FinTech firms certified by Singapore FinTech Association
  • NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria
  • Eligible company-sponsored trainees will be able to clock CPD hours upon successful course completion

Remarks:

Individual Sponsored Trainee

Company Sponsored Trainee

SkillsFuture Credit:

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding

UTAP:

  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP)

Training Allowance Grant (TAG):

  • $10/hr of eligible training and assessment hours
  • Applicable for classes commencing between 1st Jul 2021 to 30th Jun 2022 (both dates inclusive)
  • TAG will only be disbursed to the eligible sponsoring companies upon the participants’ successful completion including fulfilling 100% attendance requirement and passing the assessments.

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.

What Others Also Enrolled In