What's In It For Me
- Understand the advanced formatting options of Excel
- Use functions such as statistical, financial and mathematical operations etc
- Analyse, filter & sort data based on the tables and data needed
Who Should Attend
Individuals who have successfully reached ES-ICDL basic skills levels and wish to further enhance their expertise in Advanced Spreadsheets.
Course Duration
24 Hours
Course Outline
- Apply advanced formatting options such as conditional formatting 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 integrate data
- Collaborate on and review spreadsheets. Apply spreadsheet security features
Certification Obtained and Conferred by
Successful trainees will receive the internationally recognised ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.
This is a joint certification between SSG and ICDL Singapore
Categories
More Information
- (Local Institution) NTUC LearningHub
Add a review