Perform Spreadsheet Functions 24 hours
Funding Validity Period
19 September 2023
-
18 September 2027
Course Overview
This course is a comprehensive 24-hour program designed to equip learners with essential spreadsheet skills. Starting with the basics of navigating and utilising a spreadsheet application, participants will progress through managing data, organising worksheets, and performing basic calculations. The course also covers data formatting, chart creation for data presentation, and setting up worksheets with print options to ensure professional and effective spreadsheet use.
*This course includes an online assessment (ICDL).
Skills Acquired
By the end of this course, learners will be able to:
- Use fundamental features of a spreadsheet application.
- Identify areas for collection of data, collect and edit data.
- Manage rows, columns and worksheets to facilitate data manipulation.
- Create formulas and functions to create business statistics.
- Format data and cells.
- Create and format standard charts.
- Apply page setup options, preview and select print options.
Learning Modules
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 on data
- Arithmetic formulas
- Excel functions
- Cell referencing
Learning Unit 5: Perform formatting of data
- Format data
- Format cells
Learning Unit 6: Create charts to present data
- Create standard charts
- Format charts
Learning Unit 7: Set up worksheets and select print option
- Adjust page options
- Header & footer
- Preview worksheet
- Select print options
Who is this course for
This course is intended for learners who wish to equip themselves with the necessary knowledge and skills to be proficient with using the core features of a spreadsheet application. The skills include understanding fundamental spreadsheet concepts, designing a spreadsheet and using basic functions within a spreadsheet.
Academic prerequisites
- Learners must be able to read, write, speak and listen to English at secondary school level
- 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 be able to operate a personal computer, use keyboard and mouse
Course Fees
| Fees | Small Medium Enterprises (SMEs) | Non Small Medium Enterprises | Singaporean Employees aged 40 years and above |
|---|---|---|---|
| Full Fee | $720.00 | $720.00 | $720.00 |
| 9% GST (on full course fee) | $64.80 | $64.80 | $64.80 |
| Funding Amount | $504.00 (70% off course fee) | $360.00 (50% off course fee) | $504.00 (70% off course fee) |
| Nett Fee Payable (incl. GST) | $280.80 | $424.80 | $280.80 |
- 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
- Non-SME (MCES): Employee is Singaporean aged 40 years and above
- Eligible for Absentee Payroll Funding
- Eligible for SkillsFuture Enterprise Credit (SFEC)
| Fees | Singapore Citizens (40 years and above) | Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) |
|---|---|---|
| Full Fee | $720.00 | $720.00 |
| 9% GST (on full course fee) | $64.80 | $64.80 |
| Funding Amount | $504.00 (70% off course fee) | $360.00 (50% off course fee) |
| Nett Fee Payable (incl. GST) | $280.80 | $424.80 |
- MCES: Singaporean aged 40 years and above
- Normal: Singaporean / PR aged 21 years and above
- Eligible for UTAP funding
- Eligible for SkillsFuture Credit
- Eligible for PSEA Funds
Perform Spreadsheet Functions 24 hours
Course Highlight
Course Duration
24 HRS
Training Time
9am - 6pm
Mode of Training
Classroom
Course Reference Number
TGS-2023038008
Claude Cowork for Business Automation
16 HRS Course
Learn More
Build Apps in a Day with Vibe Coding
8 HRS Course
Learn More
Blockchain & Digital Assets for Business
16 HRS Course
Learn More
Smart with Google Workspace and AI
16 HRS Course
Learn More
Systems Thinking for Professional Growth
16 HRS Course
Learn More
Mastering Excel with AI and CoPilot
8 HRS Course
Learn More
Mastering Data Analysis with Python
16 HRS Course
Learn More
Finance for Non-financial Managers
16 HRS Course
Learn More