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

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.
Categories
More Information
  • NTUC LearningHub
Sponsored Content
Location
  • NTUC Trade Union House, 73 Bras Basah Road. S.189556, Singapore, Central Singapore Community Development Council 189556

  • No comments yet.
  • Add a review
    error: Content is protected !!