WSQ Microsoft Excel Essentials Course

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

Course Description

Being the most widely used spreadsheet tool, Microsoft Excel is an essential application for working with data – whether for data analytics, business, or research. Designed to impart you with essential working skills of Excel and how to use it managing data.

This course lays the foundation in applying business statistics, analytical and quantitative skills in Excel. Throughout this course, you’ll gain valuable experience working with data sets and spreadsheets. You will learn how to use formulas and functions, create charts and graphs, and use conditional formatting to visually represent your data.

With strong focus on practice and applied learning in this course, you’ll have the opportunity to manipulate data and gain hands-on experience using Excel. By the end of this course, you’ll have a solid foundation in using Excel and will have the skills and knowledge needed to effectively use Excel.

Course Objectives

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

  • Identify the various types of business statistics, including descriptive statistics in Excel workbooks.
  • Create and edit imported data from external sources in Excel.
  • Create formulas and functions to calculate business statistics.
  • Edit worksheet data and cells.
  • Format cells and worksheets in Excel, and utilise conditional formatting to emphasise
  • Manage multiple worksheets and windows.
  • Prepare and format worksheets for printing.
  • Sort and filter data range.
  • Create charts using existing data

Course Outline

Introduction to Business Statistics & Application Fundamentals
  • Navigating a Worksheet
  • Entering Labels & Values
  • Editing Cell Contents
  • Selecting Cells & Ranges
  • Entering Content Automatically using AutoFill
  • Importing Data
Editing a Worksheet
  • Copying & Moving Cells
  • Checking Spelling
  • Insert Cells, Rows, & Columns
  • Delete Cells, Rows, & Columns
  • Hiding & Unhiding Rows & Columns
  • Using Undo & Redo
  • Finding & Replacing Content
  • Cell Comments
Managing Worksheets
  • Using Workbook Views
  • Selecting & Switching Between Worksheets
  • Inserting, Renaming & Deleting Worksheets
  • Moving & Copying Worksheets
  • Changing Worksheet Tab Colour
  • Splitting & Freezing a Window
  • Working with Multiple Workbook Windows
  • Hiding & Unhiding Worksheets
Working with Data Ranges
  • Sorting by One Column
  • Sorting by Multiple Columns
  • Filtering Data
Introduction to Formulas & Functions
  • Overview of Formulas & Cell References
  • Entering Formulas
  • Absolute & Relative References
  • Formulas with Multiple Operators
  • Using Essential Statistical Function
  • Referencing External Data
Formatting a Worksheet
  • Formatting Text & Values
  • Adjusting Column Width & Row Height
  • Working with Cell Alignment
  • Adding Cell Borders & Background Colours
  • Copying Formatting
  • Working with Cell Styles & Document Themes
  • Applying Conditional Formatting
Managing Page Setup & Printing
  • Previewing & Printing a Worksheet
  • Setting the Print Area
  • Adjusting Page Margins & Orientation
  • Adjusting Paper Size & Print Scale
  • Adding Print Titles, Gridlines & Headings
  • Creating Headers & Footers
  • Printing a Selection, Multiple Worksheets & Workbooks
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

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 90% 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 Essentials

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-2023041089

Nett Course Fee
$175.50 after 70% SkillsFuture Subsidy

Course Schedule

Course NameCourse CodeVenueJanuary 2024February 2024March 2024April 2024May 2024June 2024
WSQ Microsoft Excel EssentialsTGS-2023041089International Plaza--18-19
TGS-2023041089JTC Summit-15-16