NTUC LearningHub

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 Objectives

 

  • Collect data from relevant data sources and select appropriate visualisation techniques to interpret and convey findings
  • Organise data in a table format to display information to reflect trend and correlations
  • Transform and contextualise data according to requirements to be displayed dynamically
  • Represent data into a proper data model that will in due course lead to data visualisation
  • Process data using tools and techniques for data display and visualisation purposes
  • Utilise visual objects, charts and dashboards for data interpretation and presentation to stakeholders

 

Pre-requisites

 

The admission requirements are:

  • Basic working knowledge of Microsoft Excel
  • Read, write, and speak English at WPL Level 4
  • Manipulate numbers at WPN Level 4
  • 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. Download from zoom.us/download.

System Requirement

Must-have:
Please ensure that your computer or laptop meets the following requirements.

  • Operating system: Windows 10 or MacOS (64 bit or above)
  • Processor/CPU: 1.8 GHz, 2-core Intel Core i3 or higher
  • Minimum 20 GB hard disk space
  • Minimum 8 GB RAM
  • Webcam (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 recommended:
Using tablets are not recommended due to their smaller screen size, which could cause eye strain and discomfort over the course of the program's duration.

 

Course Outline

 

Module 1: Look at the Data

    • Create and Remove a Table of Data
    • Total row of a Table
    • IF, IFS and nested IF conditions
    • Lookup functions

Module 2: Prepare the Data

    • Power Query
    • Merge and Append Queries

Module 3: Model the Data

    • Create an Excel Data Model
    • Create, manage and delete relationships
    • Data Hierarchy

Module 4: Process the Data

    • Using Power Pivot
    • Calculated Columns
    • Measures

 

Module 5: Visualise the Data

    • Conditional Formatting
    • Pivotcharts and Sparklines
    • Timeline and Slicer
    • Dashboard

 

Certificate Obtained and Conferred by

 

  • Upon meeting 75% attendance and passing the assessment, participants will be awarded with a digital Statement of Attainment (SOA), accredited by SkillsFuture Singapore. SOA will be reflected as [ICT-DIT-3006-1.1 Data Visualisation].
  • Upon meeting 75% attendance and passing the assessment, participants will be awarded with a digital Certificate of Completion from NTUC LearningHub.
Categories
More Information
  • NTUC LearningHub
  • No comments yet.
  • Add a review
    error: Content is protected !!