WSQ Microsoft Excel Intermediate Course

Up to 70% SkillsFuture Singapore Funding Diagram - SkillsFuture Credit, PSEA & UTAP Claimable

Course Description

Do you often work with data at work or frequently extract data to create reports to update your leaders?
Microsoft Excel is a powerful spreadsheet program that allows you to make quick and accurate numerical
calculations.

You will be more confident when you present formulated spreadsheets to highlight your key data narratives. This
course is suitable for you if you are looking to explore more advanced features of Excel to increase your
productivity while working with data.

WSQ Microsoft Excel Intermediate course will teach you how to manage data ranges, protections, create tables
and charts, insert formulas and functions, trace errors, manage names, and how to sort and filter data. In
addition, you will learn how to create VLOOKUP formulas, IF functions and simple Pivot Tables to report or
summarize your data for more impactful reporting.

Course Objectives

At the end of the course, you will be able to:

  • Use Excel for statistical analysis by organising cell ranges, managing formula errors, applying conditional logic, and employing lookup functions for data search and matching.
  • Manage large Excel data sets, including multiple worksheets and workbooks, and application of protection measures for the interpretation of the categorised data.
  • Organise data in Excel by sorting, filtering, and separating the contents into multiple sets to effectively interpret the collected data for categorisation of meaningful identified data.
  • Use features in Excel to create tables, including managing data sets and removing duplicate records.
  • Optimise Excel functionalities for process improvement in business statistics by creating and formatting charts, including displaying data through histograms.

Course Outline

Formulas & Functions
  • Identify parts of data sets for categorisation of data
  • Cell Referencing (Relative & Absolute)
  • Use Excel to select and name data ranges for navigation and formulas
  • Trace formula precedents & dependents
  • Use Logical functions
    • Insert If to manage single condition
    • Insert IFERROR to manage errors in formulas
  • Use conditional count, sum & average functions
    • Understand function syntax
    • Insert functions to perform conditional business aggregate calculations
  • Use Database functions
    • Create criteria range & use comparison operators
    • Insert data functions to calculate aggregate values
  • Use Lookup functions
    • Approximate and Exact match types
    • Use vertical & horizontal functions to search for a value in a data set
Managing Workbooks & Protection
  • Split & freeze a window
  • View Multiple worksheets or workbooks simultaneously
  • Protect workbooks
  • Protect workbook structure
  • Protect worksheets & worksheet elements
  • Splitting & Freezing a Window
  • Working with Multiple Workbook Windows
  • Hiding & Unhiding Worksheets
Working with Data Ranges
  • Creating Custom AutoFill List
  • Sorting by Colours or Icons
  • Sorting by Custom List
  • Filtering Data
  • Creating Custom AutoFilter
  • Using Advanced Filter
Working with Tables
  • Create a Table
  • Add & remove data
  • Display total row & change summary calculation
  • Sort & filter a table
  • Remove duplicate rows of data
  • Add interactive slicer
  • Format the table
  • Summarize a table with a PivotTable
  • Convert table to a range
Introduction to Charts
  • Choosing & Selecting the Source Data
  • Choosing the Right Chart
  • Inserting, Moving, Resizing & Deleting Charts
  • Changing Chart Layouts & Styles
  • Changing Chart Type
  • Working with Chart Labels
Working with Charts
  • Filter chart
  • Apply with chart labels
  • Change the chart gridlines
  • Change the scale
  • Emphasize data
  • Using chart templates
  • Printing a Selection, Multiple Worksheets & Workbooks

Fees and Subsidies

Up to 70% SkillsFuture Singapore Funding Diagram - SkillsFuture Credit, PSEA & UTAP Claimable

*Eligible for Singaporean Citizens, Permanent Residents, and Long-Term Visit Pass Plus Holders

Course Fee:
S$450 (exclusive of 9% GST)

Course Fee After Eligible SSG Subsidies:
From S$175.50 (inclusive of 9% GST) after 70% SSG Subsidies

Learners  
Singaporean Citizens ≥ 40 years old S$175.50 (after SSG 70% Funding)

SkillsFuture Credits can be used on top of existing subsidies
Singaporean Citizens, PRs or LTVP+ Holders ≥ 21 years old

S$265.50 (after SSG 50% Funding)

For Singapore Citizens learners aged ≥ 25 years old SkillsFuture Credits can be used on top of existing subsidies.

For Singapore Citizens aged 17-30 Post Secondary Education Account Funds can be used.

Learners SMEs Non-SMEs
Singaporean Citizens ≥ 40 years old S$175.50 (after SSG 70% Funding)

SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
Singaporean Citizens, PRs or LTVP+ Holders ≥ 21 years old S$175.50 (after SSG 70% Funding)

SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies
S$265.50 (after SSG 50% Funding)

SkillsFuture Enterprise Credits (SFEC) can be used on top of existing subsidies

All prices are inclusive of 9% GST.

You may use U-tap to defray 50% of the unfunded course fee, capped at $250/year. NTUC members aged 40 and above can enjoy higher funding support up to $500/year for courses attended between 01 April 2022 to 31 March 2023. Sign up https://ntuc.co/ask-edm.

Related Courses

Data Analysis with Microsoft Excel DASHBOARD Reporting for Management

The course “Data Analysis with Microsoft Excel DASHBOARD Reporting for Management” offers a tailored training to create informative, customizable, and interactive dashboards that visually present key performance indicators (KPIs), metrics, and data points, allowing quick monitoring of business health and simplifying complex data sets for easy performance awareness.

Course Duration:
2 Days (9.00am – 5.00pm)

View course details here

Data Visualisation and Storytelling with Power BI

This two-day workshop emphasizes practical skills in utilizing Power BI to analyze trends, generate intuitive and interactive visuals, and effectively communicate data insights to key stakeholders.

Course Duration:
2 Days (9.00am – 6.00pm)

View course details here

WSQ Microsoft Excel Intermediate

Course Duration:

2 Days (9.00am – 6.00pm)

Course Fee Details:

$175.50 (incl. of 9% GST) after 70% SkillsFuture Subsidy

SkillsFuture Credits & UTAP claimable

Course Code: TGS-2024042612

Nett Course Fee
$175.50 after 70% SkillsFuture Subsidy

Course Schedule

Course NameCourse CodeVenueApril 2024May 2024June 2024July 2024August 2024September 2024
WSQ Microsoft Excel IntermediateTGS-2024042612International Plaza01-02--08-09--
TGS-2024042612JTC Summit--10-11--09-10
TGS-2024042612Mountbatten Square-02-03--01-02-