ICDL Workforce – Spreadsheets

Synopsis:

Unlock your potential with an ICDL Spreadsheet Certification. This globally recognized credential proves your data management skills, opening doors to exciting career opportunities. This course introduces spreadsheet software, equipping learners with the essential skills to effectively manage and analyze data. The course covers fundamental concepts, data entry and manipulation techniques, formula creation, data formatting and chart generation. Learners will gain practical experience through hands-on exercises, building confidence and proficiency in using spreadsheets for various applications. No prior spreadsheet experience is required.

Enquire Further Here:

    Where have you heard about us?

    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:
    • Lectures: To provide learners with a foundation for further learning. In this course, lectures are effective for conveying foundational knowledge, such as statistical analysis concepts and data organization.
    • Demonstrations: To provide visual and practical examples, enhancing comprehension and illustrating real-world applications.
    • Practical Exercises: To offer opportunities for learners to apply newly acquired knowledge, reinforcing learning through hands-on practice.

    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 AvailableCourse 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.
      1. Public Speaking & Presentation
      2. Empowered Leadership: Mastering the New Gen Leadership
      3. Strategic Leadership: Navigating the New Gen Landscape
      4. Excel Fundamentals
      5. 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.
    Scroll to Top