Microsoft Excel – Advanced
QUALIFICATION NAME
Microsoft Courses
DUAL SPECIALISATIONS
Microsoft Excel – Advanced
DURATION
1 day
MODE OF DELIVERY
Face-to-face (Part-Time/Full-Time)
Blended learning
Self-paced
Course Overview
This course is designed for those individuals who have worked extensively using Microsoft Excel for more complex tasks. This one – day course will provide participants with the opportunity to complete practical exercises and applied examples based around the advanced functions of the software including use of macros, data validation techniques and data consolidation methods. Participants will benefit from hands on tuition to help them develop their skills.
Trainers with industry as well as teaching experience
Small class size, so well - focused individually
Easily accessible via public transport
Well - equipped IT resources
Protect a workbook and save with a backup
Understand and use advanced functions
Consolidate data, link and export data
Use What - If Analysis tools such as Goal Seek, Solver and Scenarios
Create and modify PivotTables and PivotCharts
Create and modify Macros
Pre- requisite
There is no pre – requisite for this course, however learners are advised to complete Microsoft Excel – Introduction as well as Intermediate course s before to do this.
Certification and Careers
The course is designed for the learners to lead for Microsoft Office Specialist (MOS) certification exam.
Candidate can get a course completion certificate from Omni College.
The course helps learners to do and manage the complex office administrative related excel documents efficiently
Note: *The general elective units may change at college’s discretion, if necessary.
