ICDL Workforce – Spreadsheets
Course Objective:
On completion of this course, learners will be able to:
-
Work with spreadsheets and save them in different file formats, locally or in the cloud.
-
Use available help resources, shortcuts and the go to tool to enhance productivity.
-
Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data.
-
Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets.
-
Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas.
-
Format numbers and text content in a spreadsheet and use available autoformat/table styles.
-
Choose suitable charts and create and format charts to communicate information meaningfully.
-
Adjust spreadsheet page settings and check and correct spreadsheet content before printing
Course Outline:
Topic 1: Using the Application
-
Working with Spreadsheets
-
Enhancing Productivity
Topic 2: Cells
-
Insert, Select
-
Edit, Sort
-
Copy, Move, Delete
Topic 3: Managing Worksheets
-
Rows and Columns
-
Worksheets
Topic 4: Formulas and Functions
-
Arithmetic Formulas
-
Functions
Topic 5: Formatting
-
Numbers/Dates
-
Content
-
Alignment, Border, Effects
Topic 6: Charts
-
Create
-
Edit
Topic 7: Prepare Outputs
-
Setup
-
Check and Print
For Whom:
Suitable for beginners, juniors, jobseekers and individuals who are interested to improve their data management and analysis capabilities.
Entry Requirements:
Learners are assumed to:
-
Have basic computer skills
-
Be able to listen, read and write English at a proficiency level equivalent Workplace Literacy (WPL) Level 4 Low Intermediate (Lower Secondary) and above; and
-
Be able to manipulate numbers at a proficiency level equivalent to Workplace Numeracy (WPN) Level 4 Low Intermediate (Lower Secondary) and above.
Essential Requirements:
Learners are required to bring their personal laptop with Microsoft Excel pre-installed for an optimal learning experience. |
Training Medium:
This course is conducted in English. |
Training Methodology:
The course will use a combination of the following methods to ensure effective learning and skill development:
|
Assessment Methodology:
ICDL assessment is conducted at the end of the course. |
Certification:
A ICDL Certificate of Proficiency will be awarded to learners upon completing and passing the assessment. Otherwise, a Certificate of Participation will be issued to those who attained a minimum attendance of 75%. |
Funding Available | Course Fee |
---|---|
UTAP (Call to Enquire) | $490.50 |
-
Fees stated are for a class size of 10 pax and above. For class size of less than 10 pax, kindly call Electronics Industries Training Centre (ELITC) to enquire.
-
Fees stated are non-member rate. For member rate, kindly call Electronics Industries Training Centre (ELITC) to enquire.
-
All courses listed, except for the following, are eligible for Union Training Assistance Programme (UTAP). NTUC members can enjoy up to 50% funding (capped at $250 per year) under UTAP.
-
Public Speaking & Presentation
-
Empowered Leadership: Mastering the New Gen Leadership
-
Strategic Leadership: Navigating the New Gen Landscape
-
Excel Fundamentals
-
Essential Skills for Engineers: Quality Systems, Data & Project Management
-
-
A non-refundable registration fee of $20.00 is payable upon registration.
-
ELITC reserves the right to cancel any classes due to unforeseen circumstances. In such cases, a full refund of fees will be made.