Training The Digital Workforce of Tomorrow.
AVICDL-EXC16Advanced | ICDL Microsoft Excel 2016 Advanced



3 Day(s)

Instructor-Led Training

from SGD $525*

Course Schedules

Contact For Dates

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

Course Overview

Participants will have the knowledge and application skills in using a spreadsheet application at an advanced level. The skills include maintaining complex spreadsheets, using complicated functions of various types, and using auditing techniques to check for errors.

Pre-Requisites: Users already with Excel basic proficiency

Who Should Enrol?

Course Outcome

Successful candidates will be able to:

  • 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.
  • 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.


Section 1: Formatting

Section 2: Functions and Formulas

Section 3: Charts

Section 4: Data Analysis

Section 5: Pivot Tables

Section 6: Auditing and Validating Data

Section 7: Enhancing Productivity

Section 8: Collaborative Editing


Related Courses

You might also be interested in these courses

ICDL-EXC19Basic | ICDL Microsoft Excel Basic 2019
AVICDL-WOR16Adv | ICDL Microsoft Word 2016 Advanced
AVICDL-PPT16Adv | ICDL Microsoft PowerPoint 2016 Advanced
ICDL-DM | WSQ ICDL Digital Marketing
ICDL-IL | ICDL Information Literacy
AVICDL-EXC16Basic | ICDL Microsoft Excel 2016 Basic