Upon course completion, learners will be able to:
- Apply advanced formatting options such as conditional formatting and customized 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
- 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 and macros
- Use linking, embedding and importing features to integrate data
- Compare and merge spreadsheets. Apply spreadsheet security features
Pre-requisites
Required Prerequisites:
** Kindly be informed that all trainees will have to take an Excel diagnostic test prior to registration.
(a) F2F Classes, these are the admission requirements.
- Have advance knowledge on Excel spreadsheet such as using Cells, Rows and Columns, Formulas and Functions, Formatting, Charts and preparing Outputs
- Be a proficient user of computer and computer software
- Be able to Speak, Listen, Read and Write English at WPL Level 4 or equivalent
- Be able to manipulate numbers at WPN Level 4 or equivalent
- Have keen interest to acquire new knowledge and skill
(b) Virtual Learning Classes, these are the admission requirements.
Trainings will be conducted on Zoom platform, thus webcam and microphone are compulsory
Applicants need to:
- Have a Windows OS PC prior to class (Apple Mac OS is not applicable)
- Have advance knowledge on Excel spreadsheet such as using Cells, Rows and Columns, Formulas and Functions, Formatting, Charts and preparing Outputs
- Be a proficient user of computer and computer software
- Be able to Speak, Listen, Read and Write English at WPL Level 4 or equivalent
- Be able to manipulate numbers at WPN Level 4 or equivalent
- Have keen interest to acquire new knowledge and skill
Course Outline
1. Formatting
- Cells
- Worksheets
2. Formulas and Functions
- Using Formulas and Functions
3. Charts
- Creating Charts
- Formatting Charts
4. Analysis
- Using Tables
- Sorting and Filtering
- Scenarios
5. Validating and Auditing
- Validating
- Auditing
6. Enhancing Productivity
- Naming Cells
- Paste Special
- Linking, Embedding and Importing
- Automation
7. Collaborative Editing
- Reviewing and Security
Certificate 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.
Categories
More Information
- NTUC LearningHub
Add a review