— AVWSQ-EXC16Advanced

AVWSQ-EXC16Advanced | WSQ ICDL Microsoft Excel 2016 Advanced

AVWSQ-EXC16Advanced

-

3 Day(s)

Instructor-Led Training

SGD $525

icdl-banner

Course Schedules

05 Dec 2022 - 07 Dec 2022
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

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.

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

funded-course-tab
icdl-banner
AVWSQ-WOR13Advanced | WSQ ICDL Microsoft Word 2013 Advanced (3 days)
funded-course-tab
icdl-banner
AVWSQ-WOR16Basic | WSQ ICDL Microsoft Word 2016 Basic
funded-course-tab
icdl-banner
AVWSQ-EXC13Basic | WSQ ICDL Microsoft Excel 2013 Basic
funded-course-tab
icdl-banner
AVWSQ-WOR13Basic | WSQ ICDL Microsoft Word 2013 Basic
funded-course-tab
icdl-banner
AVWSQ-PPT16Basic | WSQ ICDL Microsoft PowerPoint 2016 Basic
funded-course-tab
icdl-banner
ICDL-DM | WSQ ICDL Digital Marketing

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