Workplace Productivity using Excel
TGS-2022016976
Course Overview
This module provides fundamental knowledge and skills for utilising spreadsheet applications effectively in the workplace. Participants will learn to gather, manage, and edit data across worksheets and workbooks. The course covers essential features necessary to compile, format, and analyse data to generate meaningful reports. Learners will become proficient in creating and using formulas and functions, managing rows and columns, and formatting data and cells. This introductory course is designed to enhance productivity and enable efficient data management for beginners
Training Type
Full Time
Who Should Attend
This training is relevant to all staff (Operational, Supervisory & Managerial) tasked with collating, managing and analysing data of the organisations to determine current performance and then develop recommendations for improvement to senior management
Course Duration
2 Days
Total Training Duration (Hour)
17
Course Outline
Learning Unit 1: Getting Started With A Spreadsheet Application
- Using the application
- Working with workbooks
- Basic spreadsheet concepts
- Using functionalities of the application
Learning Unit 2: Manage Data In A Spreadsheet
- Good practices in managing data
- Enter & edit data
- Moving within a worksheet
- Cell selection techniques
- Copy, cut & paste
- Find & replace
- Sort & filter
Learning Unit 3: Manage Worksheets
- Insert, delete & format rows & columns
- Insert, delete, rename, move & copy worksheets
Learning Unit 4: Perform Calculations
- Arithmetic formulas
- Excel functions
- Cell referencing
Learning Unit 5: Perform Formatting Of Data
- Format data
- Format cells
Learning Unit 6: Create Charts
- Create standard charts
- Format charts
Learning Unit 7: Set Up Worksheets And Select Print Options
- Adjust page options
- Header & footer
- Adjust sheet display options
- Preview worksheet
- Select printing options
Course Learning Outcome
By the end of this course, learners will be able to:
- Use fundamental features of a spreadsheet application
- Gather and edit data
- Manage rows and columns in a worksheet
- Manage worksheets in a workbook
- Create formulas and functions
- Format data and cells
- Create and format standard charts
- Select spreadsheet settings
- Preview a spreadsheet and select print options
Pre-requisites
- Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 4
- Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 4
- Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 4
- Learners to have minimum GCE ‘O’ level or ITE certificate education
- Learner should have at least 1 year’s working experience in any industry
- Learners must have basic computer skills, i.e. be able to operate a personal computer, use keyboard and mouse
Funding Information
08 Nov 2022 To 07 Nov 2026
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $420.00 | $457.80 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| Individual (Baseline) | $210.00 | $247.80 |
| Individual (MCES) | $126.00 | $163.80 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| SME | Before GST | With GST (9%) |
| Corporate (SME) | $126.00 | $163.80 |
| Non-SME | Before GST | With GST (9%) |
| Corporate (Non-SME, Baseline) | $210.00 | $247.80 |
| Corporate (Non-SME, MCES) | $126.00 | $163.80 |
Company Sponsored Funding Types
- SME
- Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
- 70% of course fee funded
- Non-SME (Baseline)
- Non-SME companies, employee is Singaporean or PR aged below 40
- 50% of course fee funded
- Non-SME (MCES)
- Non-SME companies, employee is Singaporean aged 40 years and above
- 70% of course fee funded
Absentee Payroll Funding for Companies:
- $4.50 per training hour capped at $100,000 per enterprise per calendar year
------------------------------------------------------------------------
Self-sponsored Funding Types
- MCES
- Singaporean aged 40 years and above
- 70% of course fee funded
- Normal
- Singaporean / PR aged 21 years and above
- 50% of course fee funded
