ICDL Advanced Soreadsheets

Kaplan Singapore


Course introduction

ICDL programme gives people the skills they need to get a job, develop at work, and build their careers.

The programme is tailored to meet the demands of professionals across a broad range of sectors. From finance to marketing, and education to healthcare, ICDL programme provides the specialised digital skills that are needed to excel.



Course Benefits


Successful candidates will be able to:

  • Apply advanced formatting options such as conditional and customised number formatting and handle worksheets
  • Use functions such as those associated with logical, statistical, financial and mathematical operations.
  • Create charts and apply advanced chart formatting features
  • Work with tables and lists to analyse, filter and sort data. Create and use scenarios.
  • Validate and audit spreadsheet data
  • Enhance productivity by working with named cell ranges, macros and templates.
  • Use linking, embedding and importing features to integrate data.
  • Collaborate on and review spreadsheets. Apply spreadsheet security features.



Course Pre-Requisites


Pre-Requisites

  • Knowledge of basic PC skills
  • Basic proficiency in reading, writing and understanding English



Target Audience


Who Should Attend
PMETs who would like to enhance their skillsets in Microsoft Office application



Course Outline


Mode of training: Classroom

Duration: 16 hours (2 days)/ 24 hours (3 days)

For latest course schedule, please enquire with your course consultant or simply fill up the enquiry form.

Course Structure:
Module 1: Formatting
Module 2: Functions and Formulas
Module 3: Charts
Module 4: Analysis
Module 5: Validating and Auditing
Module 6: Enhancing Productivity
Module 7: Collaborative Editing



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


N.A

Kaplan reserves the right to change trainer, in light of unforeseen circumstances.



 

Top