— AVWSQ-EXC13Advanced | WSQ ICDL Microsoft Excel 2013 Advanced (3 days)

AVWSQ-EXC13Advanced | WSQ ICDL Microsoft Excel 2013 Advanced (3 days)

AVWSQ-EXC13Advanced | WSQ ICDL Microsoft Excel 2013 Advanced (3 days)

-

3 Day(s)

Instructor-Led Training

SGD $500

icdl-banner

Course Schedules

12 Dec 2022 - 14 Dec 2022
25 Jan 2023 - 27 Jan 2023
20 Feb 2023 - 22 Feb 2023
20 Mar 2023 - 22 Mar 2023
17 Apr 2023 - 19 Apr 2023
19 Jun 2023 - 21 Jun 2023
17 Oct 2022 - 19 Oct 2022
14 Nov 2022 - 16 Nov 2022

TELL YOUR FRIENDS

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.

WHO IS THE COURSE FOR?

Mix from various companies, industries, and departments

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: Auditing and Validating

Section 6: Linking

Section 7: Collaborative Editing

FULL COURSE OUTLINE 👉

Related Courses

You might also be interested in these courses

funded-course-tab
icdl-banner
AVWSQ-EXC13Basic | WSQ ICDL Microsoft Excel 2013 Basic
funded-course-tab
icdl-banner
ICDL-CS | WSQ ICDL Computer Essentials
funded-course-tab
wsq-icdl-adobe-photoshop-cs6
AVWSQ-APSCS6 | WSQ ICDL Adobe Photoshop CS6
funded-course-tab
icdl-banner
AVWSQ-ACS13Basic | WSQ ICDL Microsoft Access 2013 Basic
funded-course-tab
icdl-banner
AVWSQ-EXC16Advanced | WSQ ICDL Microsoft Excel 2016 Advanced
funded-course-tab
icdl-banner
ICDL-DA | ICDL Data Analytics

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