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

Try the quiz to test your Microsoft Excel skill: Pre-Course Survey (Excel)