MODERN APPROACH TO ANALYSING BUSINESS DATA USING MICROSOFT EXCEL (SF) (SYNCHRONOUS E-LEARNING)

MODERN APPROACH TO ANALYSING BUSINESS DATA USING MICROSOFT EXCEL (SF) (SYNCHRONOUS E-LEARNING)

Funded

Course Duration

16.0 hr(s)

Mode of Assessment

Students will be required to complete a written assessment and a practical performance assessment during class.

Who Should Attend

This course is intended but not limited for the following job roles:

  • Data Analyst
  • Data Officer
  • Data Team Leader
  • Data Engineer
  • Business Analyst
  • Users with limited Microsoft Excel knowledge but require to work with IT and other departments within the organisation to conduct data analysis
  • Business professionals requiring Microsoft Excel knowledge for data analysis

What's In It for Me

  • Familiarise with the use of tables in Microsoft Excel
  • Find out more about Microsoft Excel’s functions such as the conditional and lookup functions
  • Learn the basic concepts of data preparation using Power Query
  • Discover useful concepts of data modelling using Excel Data Model
  • Create calculated columns and measures using Power Pivot
  • Explore data visualisation using Microsoft Excel

Course Overview

This course is intended for anyone who wants to stretch their data analysis capabilities using Microsoft Excel starting with a block of data to a table of data, going beyond just functions and formulas, and picking up more advanced capabilities leading to data preparation, data modelling and data visualisation using power query, power pivot, pivot charts, conditional formatting, slicers, timelines and dashboards.

Course Schedule

Next available schedule

See All Schedules

Course Objectives

  • Able to collect data from relevant data sources and select appropriate visualisation techniques to interpret and convey findings
  • Able to organise data in a table format to display information to reflect trend and correlations
  • Able to transform and contextualise data according to requirements to be displayed dynamically
  • Able to represent data into a proper data model that will in due course lead to data visualisation
  • Able to process data using tools and techniques for data display and visualisation purposes
  • Able to utilise visual objects, charts and dashboards for data interpretation and presentation to stakeholders

Pre-requisites

  • It is recommended that the participant would have used or have basic working knowledge of Microsoft Excel.
  • Hardware & Software
    This course will be conducted as a Virtual Live Class (VLC) via Zoom platform. Participants must own a zoom account and have a laptop or a desktop with “Zoom Client for Meetings” installed. This can be downloaded from https://zoom.us/download

System Requirement

Must Have:

Please ensure that your computer or laptop meets the following requirements.

  • Operating system: Windows 10 (MacOS is not supported)
  • Processor/CPU: 1.8 GHz, 2-core Intel Core i3 or higher
  • Minimum 20 GB hard disk space.
  • Minimum 8 Gb RAM
  • Webcam (The camera must be turned on for the duration of the class)
  • Microphone
  • Internet Connection: Wired or Wireless broadband
  • Latest version of Zoom software to be installed on computer or laptop prior to the class.

Good to Have:

  • Wired internet connection
    Wired internet will provide you with stable and reliable connection.

  • Dual monitors
    Using a dual monitor setup will undoubtedly improve your training experience, enabling you to simultaneously participate in hands-on exercises and maintain engagement with your instructor.

Not Supported:

1. Using tablets is not recommended due to their smaller screen size, which could cause
    eye strain and discomfort over the course of the program's duration.
 

2. Mac OS version of MS Excel has limited features and functions that will decrease the
    learning experience of this course.

Course Outline

  • Collect the Data
    • Steps to use MS Forms
    • Create and Remove a Table of Data
  • Look at the Data
    • Total row of a Table
    • IF, IFS and nested IF conditions
    • Lookup functions
  • Prepare the Data
    • Power Query
    • Merge and Append Queries
  • Model the Data
    • Create a Excel Data Model
    • Create, manage and delete relationships
    • Data Hierarchy
  • Process the Data
    • Using Power Pivot
    • Calculated Columns
    • Measures
  • Visualise the Data
    • Conditional Formatting
    • Pivotcharts and Sparklines
    • Timeline and Slicer
    • Dashboard

Certificate Obtained and Conferred by

Awarded Statement of Attainments (SOA)

Upon completion of the course and assessment, students will also be awarded with the following ICT SOA: ICT-DIT-3006-1.1 Data Visualisation

  • Certificate of completion from NTUC LearningHub

Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.

Additional Details

Medium of Instruction: English

Trainer: Trainee ratio is 1:20

Price

Course Fee and Government Subsidies

  

Individual Sponsored 

Company Sponsored 

 

Non-SME 

SME 

Before GST 

After GST 

Before GST 

After GST 

Before GST 

After GST 

Full Course Fee
(For Foreigners and those not eligible for subsidies)

$1,200.00

$1,308.00

$1,200.00

$1,308.00

$1,200.00

$1,308.00

For Singapore Citizens aged 39 years and below
and
For all Singapore Permanent Residents
(The minimum age for individual sponsored trainees is 21 years)

$360.00

$392.40

$360.00

$392.40

$120.00

$152.40

For Singapore Citizens aged 40 years and above

$120.00

$152.40

$120.00

$152.40

$120.00

$152.40

Funding Eligibility Criteria:

Individual Sponsored Trainee

Company Sponsored Trainee
  • Singapore Citizens or Singapore Permanent Residents

  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses

  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • 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

  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses

  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria

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: 

  • This course is eligible for Union Training Assistance Programme (UTAP).
  • NTUC members can enjoy up to 50% funding (capped at $250 per year) under UTAP. 

PSEA: 

  • To check for Post-Secondary Education Account (PSEA) eligibility for this course, visit:
    (a)     SkillsFuture (TGS-2018501080) for Virtual Learning Class (VLC)
    (b)     SkillsFuture (TGS-2023019588) for Face-to-Face class
  • Scroll down to “Keyword Tags” to verify for PSEA eligibility. 
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.  
  • And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA. 
  • Not all courses are eligible for PSEA funding.

Absentee Payroll (AP) Funding: 

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year.
  • AP funding will be computed based on the actual number of training hours attended by the trainee.
  • Note: Courses / Modules under Professional Conversion Programme (PCP) will not be eligible for AP funding claim. 

Terms & 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

Funded

DATA ANALYSIS FUNDAMENTALS USING MICROSOFT EXCEL (IBF)

View detail
Before Funding $780.00
View detail
Funded

MODERN APPROACH TO ANALYSING BUSINESS DATA USING MICROSOFT EXCEL (SF) (SYNCHRONOUS E-LEARNING)

View detail
Before Funding $1,200.00
View detail
Funded

DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI (SYNCHRONOUS E-LEARNING)

View detail
Before Funding $1,200.00
View detail