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 16 – 18 Nov 2020 14 – 16 Dec 2020 2021 Course Dates |
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