Course Description In the community care sector, corporate services staff are responsible for managing extensive data sets related to patient care, scheduling, inventory, and financial reporting. Proficiency in Excel is crucial for efficiently handling these responsibilities. This course equips staff with the ability to perform data entry, create and manage workbooks, use formulas and functions, and generate insightful reports, making them more effective in their roles and increasing their value to employers. The course offers practical training that enables participants to analyze data effectively, create simple spreadsheets, charts and reports, and automate routine tasks. These skills are essential for roles that require technical proficiency and the ability to drive organizational efficiency. As community care organizations continue to evolve, there is a growing need for staff to upgrade their skills to keep pace with technological advancements. The " Microsoft Office 365 – Excel (ICDL accredited) ” course provides essential training that empowers staff to utilize the full potential of Excel. The Spreadsheets module covers the main concepts and skills needed to use spreadsheets, such as tasks associated with developing, formatting, modifying, and using a spreadsheet. Course Level: Intermediate Course Outline: Module 1. Exploring Microsoft Excel Module 2. Getting Help Module 3. Basic Workbook Skills Module 4. Selection Module 5. Working with Columns and Rows Module 6. Number Formatting Module 7. Text Formatting Module 8. Cell Formatting Module 9. Working with Tables Module 10. Formulas Module 11. Cut, Copy and Paste Module 12. Data Management Module 13. Creating Charts Module 14. Using Page Setup Module 15. Printing Additional Information Please click on 'express your interest' to learn. A minimum of 75% attendance (with CS theory and practicum mandated) and a pass in Competency assessment are required for the completion and of course and receive your certification. Prevailing course fee subsidy at 90% for Singapore Citizens / Permanent Residents and 45% for Work Pass Holders working in eligible community care organizations.

Course Description In the community care sector, corporate services staff are often tasked with managing extensive data sets related to patient care, scheduling, inventory, and financial reporting. This course equips staff with the ability to perform complex data analysis, automate processes, and generate insightful reports, making them more effective in their daily work. For staff looking to advance their careers, mastering advanced Excel functions is helpful for them. The course offers practical hands-on training that enables participants to analyze data more effectively, create spreadsheets and charts, and automate routine tasks. By developing these competencies, staff can position themselves for promotions or more strategic roles within their organizations. As community care organizations continue to evolve, there is a growing need for staff to upgrade their skills to keep pace with technological advancements. The "Microsoft Office 365 – Excel Advanced (ICDL accredited)" course provides essential training that empowers staff to utilize the full potential of Excel. The course covers the advanced skills needed to use the versatile features of spreadsheets to produce reports, provide statistical or mathematical analysis, and manage data more effectively and productively. Level: Intermediate Course Outline: Module 1. Using Conditional and Custom Formats Module 2. Using Templates Module 3. Working with Databases Module 4. Working with Advanced Filters Module 5. Revising Charting Features Module 6. Creating/Revising PivotTables Module 7. Using Auditing Tools and Range Names Module 8. Importing Data Module 9. Using Advanced Functions Module 10. Using Scenarios Module 11. Using Worksheet Protection Module 12. Tracking and Merging Workbooks Module 13. Recording Macros