Microsoft Excel 2016 Expert

Course Code:
MSEXC16E

Duration:
3 days
8.30am to 5.30pm  
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$650 (excl of G.S.T)
2020 Course Dates
16 – 18 Nov 2020
14 – 16 Dec 2020

2021 Course Dates
11 – 13 Jan 2021
15 – 17 Feb 2021
15 – 17 Mar 2021
19 – 21 Apr 2021

None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.
Do note that this course listed uses digital courseware. You are required to bring your own device to access the digital manual.

SkillsFuture Credit Eligible

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website (www.skillsfuture.sg/credit) to choose from the courses available on the SkillsFuture Credit course directory.

Course Overview

This is an advanced course which will prepare the participants to use advanced spreadsheet features and functionality.

Program Objective

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.

Course Outline

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

Click Here for full course outline

Take the Next Step

It Takes Less Than 5 Min