Training The Digital Workforce of Tomorrow.
EXC16E | Microsoft Excel 2016 Expert

EXC16E

77-728

3 Day(s)

Instructor-Led Training

from SGD $650*

Course Schedules

08 Jan 2024 - 10 Jan 2024
18 Mar 2024 - 20 Mar 2024
27 May 2024 - 29 May 2024
29 Jul 2024 - 31 Jul 2024
30 Sep 2024 - 02 Oct 2023
16 Oct 2023 - 18 Oct 2023

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

Course Overview

This is an advanced course which will prepare the participants to use advanced spreadsheet features and functionality. 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 Should Enrol?

Information workers using Excel in daily work processes. Basic experience with Excel including creating workbooks, navigating worksheets, columns and rows and using basic functions such as SUM, AVERAGE will be expected from the audience.

Course Outcome

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.

LEARNING PATHWAY

Module 1: Advanced Formatting

Module 2: Advanced Functions and Formulas

Module 3: Data Analysis using Pivot Tables and Business Intelligence

Module 4: Workbook Management Features

Module 5: Advanced Charts, Functions and What-If Analysis

Module 6: Data Filtering, Macros and Forms

FULL COURSE OUTLINE 👉

Related Courses

You might also be interested in these courses

office-banner.
PPT19 - Microsoft PowerPoint 2019
office-banner.
VIS16 | Microsoft Visio 2016
office-banner.
WOR19S - Microsoft Word 2019
office-banner.
EX02-200-2019 | Analysis with Excel 2019
office-banner.
EXC19E | Microsoft Excel 2019 Expert
office-banner.
WOR19E - Microsoft Word 2019 (Expert)