ICDL-EXC16Advanced | ICDL Microsoft Excel 2016 Advanced

AVWSQ-EXC16Advanced

-

3 Day(s)

Instructor-Led Training

from SGD $525

Course Schedules

09 Jan 2023 - 11 Jan 2023
13 Feb 2023 - 15 Feb 2023
13 Mar 2023 - 15 Mar 2023
10 Apr 2023 - 12 Apr 2023
15 May 2023 - 17 May 2023
05 Jun 2023 - 07 Jun 2023
17 Oct 2022 - 19 Oct 2022
07 Nov 2022 - 09 Nov 2022
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 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

wsq-icdl-adobe-photoshop-cs6
ICDL-APSCS6 | ICDL Adobe Photoshop CS6
icdl-banner
ICDL-IL | WSQ ICDL Information Literacy
icdl-banner
ICDL-ACS13Basic | ICDL Microsoft Access 2013 Basic
icdl-banner
ICDL-WOR16Basic | ICDL Microsoft Word 2016 Basic
icdl-banner
ICDL-PPT16Advanced | ICDL Microsoft PowerPoint 2016 Advanced
icdl-banner
ICDL-PPT13Basic | ICDL Microsoft PowerPoint 2013 Basic

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