Microsoft Excel 2016 Expert
|
Course Code: |
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 20 – 22 Jan 2020 17 – 19 Feb 2020 23 – 25 Mar 2020 20 – 22 Apr 2020 18 – 20 May 2020 15 – 17 Jun 2020 20 – 22 Jul 2020 24 – 26 Aug 2020 14 – 16 Sep 2020 12 – 14 OCt 2020 9 – 11 Nov 2020 14 – 16 Dec 2020 |
| 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