IT07A11: MODERN APPROACH TO ANALYSING BUSINESS DATA USING MICROSOFT EXCEL (SF)
MODERN APPROACH TO ANALYSING BUSINESS DATA USING MICROSOFT EXCEL (SF)
Course Duration
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
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.
Good to Have:
Not Supported: 2. Mac OS version of MS Excel has limited features and functions that will decrease the |
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 |
$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 |
$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 |
|
|
Remarks:
Individual Sponsored Trainee |
Company Sponsored Trainee |
SkillsFuture Credit:
UTAP:
PSEA:
|
Absentee Payroll (AP) Funding:
|
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.
Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
---|
What Others Also Enrolled In
MODERN APPROACH TO ANALYSING BUSINESS DATA USING MICROSOFT EXCEL (SF)
View detailDATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI
View detail