Perform Advanced Spreadsheet Functions
About This Course
This is an advanced level course aimed at leaners who have a working knowledge of using spreadsheets. Spreadsheet applications are widely found in all workplaces. The ability to use the advanced features of a spreadsheet application is a highly valued skill required at the workplace. The competencies covered in this course will enable learners to improve their job performance in their current job. Learners will be able to assume more responsibilities in their current workplace, to move to a new job role or to seek more employment opportunities in other sectors
What You'll Learn
1) Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
2) Use functions such as those associated with logical, statistical, financial and mathematical operations
3) Create charts and apply advanced chart formatting
4) Work with tables and lists to analyse, filter and sort data. Create and use scenarios
5) Validate and audit spreadsheet data
6) Enhance productivity by working with named cell ranges and macros
7) Use linking, embedding and importing features to integrate data
8) Compare and merge spreadsheets. Apply spreadsheet security features
Entry Requirements
• Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 5.
• Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 5.
• Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 5.
• Learners to have minimum GCE ‘O’ level or ITE certificate education
• Learner should have at least 1 year’s working experience in any industry.
• Learners must be able to operate a personal computer, use keyboard and mouse
• Learners are expected to have intermediate knowledge of Microsoft Excel