ICDL-EXC16Advanced | ICDL Microsoft Excel 2016 Advanced

AVWSQ-EXC16Advanced

-

3 Day(s)

Instructor-Led Training

from SGD $525*

Course Schedules

05 Dec 2022 - 07 Dec 2022

TELL YOUR FRIENDS

Exam Code

Course Duration

3 Day(s)

Delivery Mode

Instructor-Led Training

Course Price

from $525
*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 IS THE COURSE FOR?

ATTAINABLE SKILLS

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.

LEARNING PATHWAY

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

FULL COURSE OUTLINE 👉

Related Courses

You might also be interested in these courses

icdl-banner
AVICDL-EXC16Basic | ICDL Microsoft Excel 2016 Basic
icdl-banner
AVICDL-WOR16Basic | ICDL Microsoft Word 2016 Basic
icdl-banner
ICDL-DA | ICDL Data Analytics
icdl-banner
AVICDL-PPT16Basic | ICDL Microsoft PowerPoint 2016 Basic
wsq-icdl-digital-marketing-banner
ICDL-DM | WSQ ICDL Digital Marketing
icdl-banner
ICDL-CPT | ICDL Computing

Have A Question?

WE'RE Here To Assist You 😊

Alternatively, you may contact us via live chat on the bottom right of your browser.

Search For A Course..

You may be interested in these