Course Overview
Bring your Spreadsheets skills to an expert level and be more confident, efficient and effective in using Spreadsheets.
Master the advanced functions of Spreadsheets applications to produce more sophisticated reports with deeper data analysis and complex mathematical calculations. With this, you will be able to draw out key insights from data and enhance your productivity and effectiveness at work.
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
Topic 1: Formatting
Worksheets
Topic 2: Functions and Formulas
Using Functions and Formulas
Topic 3: Charts
Creating Charts
Formatting Charts
Topic 4: Analysis
Using Tables
Sorting and Filtering
Scenarios
Topic 5: Validating and Auditing
Validating
Auditing
Topic 6: Enhancing Productivity
Naming Cells
Paste Special
Templates
Linking, Embedding and Importing
Automation
Topic 7: Collaborative Editing
Tracking and Reviewing
Security
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