Microsoft Excel 2013 Expert


Course Code:

MSEXC13E

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)
2019 Course Dates
22 – 24 Jul 2019
26 – 28 Aug 2019
16 – 18 Sep 2019
14 – 16 Oct 2019
25 – 27 Nov 2019
16 – 18 Dec 2019
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.

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

Microsoft Excel Expert teaches participants how to use a variety of intermediate and advanced features to merge workbooks, perform data analysis, and audit formulas in spreadsheets. Participants also use summary functions, create PivotTables and PivotCharts, and work with macros.

Program Objectives

• Create dual axis charts

• Use dynamic charts Use chart animation Create trendline charts Create and apply chart templates

• Create custom conditional formats

• Use functions to format cells

• Manage conditional formatting rules

• Use the Error Checking Tool

• Trace formula errors

• Use the evaluate formula

• Define what a function is

• Use the correct syntax for functions

• Create and use lookup, transpose, date and time, financial, AND/OR, and conditional summary functions

• Nest functions inside other functions

• Create and use pivot tables and pivot charts

• Customize pivot tables and pivot charts

• Apply styles to pivot charts

• Use a data slicer with a pivot table

• Group and format data in a pivot table

• Create calculated fields in a pivot table

• Use PowerPivot and manage table relationships

• Use advanced filtering

• Create a shared workbook

• Track and merge changes on shared workbooks

• Insert cell comments

• Modify tab order

• Display data in multiple international formats and use international symbols

• Check worksheets for accessibility

• Use +Body and +Heading fonts

• Use custom formats for numbers, dates and times

• Use advanced format filling

• Create and modify custom cell styles

• Create custom color formats

• Set up a what-if scenario

• Use the Goal Seeking tool and create scenarios

• Use the watch window

• Open a workspace

• Consolidate data

• Create, modify, and delete a workbook template

• Protect worksheets and workbooks

• Allow ranges for editing in protected worksheets

• Copy macros from one workbook to another

• Remove workbook metadata

• Change Excel formula calculation options

Participants who complete this course will have reviewed all the exam objectives to prepare for: Microsoft Excel 2013 Expert Exams #77-427 and #77-428. Successful completion of the certification exam provides a competitive advantage by validating the knowledge and skill sets for individuals who may be seeking employment or further job opportunities in their careers.

Course Outline

Module 1: Advanced Functions and PivotTables

Module 2: Advanced Charts, Conditional Formatting, and Checking Formulas

Module 3: Filtering and Sharing Workbooks

Module 4: Working with Forms

Module 5: Pivot Charts and Advanced Formulas

Module 6: Protecting and Configuring Workbooks

Click Here for full course outline

Funding Eligibility

The general eligibility criteria are:

• Candidates must be Singapore Citizen(s) or Permanent Resident(s) of Singapore.

• Candidates must be fully sponsored by the Applicant Company for supportable cost components (such as Course fees) incurred on the training course.

• Candidates must attain a minimum of 75% attendance for the approved courses for funding.

• Candidates repeating training in the same course will not be eligible for Training Assistance.

•  Candidates shall fulfill such other conditions of eligibility as applicable to SSG Schemes which may be amended, revised, modified or varied from time to time and at any time in The Agency’s sole discretion.

• Candidates must be persons employed by the Applicant Company, in accordance to the Employment Act, except for sole proprietors and partners, working directors, commission-based agents and members of co-operatives. To illustrate, candidates who are recruited solely for the purpose of training and be released shortly from employment thereafter are not eligible for Training Assistance. To further illustrate, candidates who are employed on different terms of employment during and after training may also lead to The Agency concluding that they are not genuine employees and the objective and spirit of the Scheme has been violated.

• Candidates must complete the full course whilst in the Applicant Company’s employment.

• The Approved Courses for Funding attended must be relevant to the candidates’ current job and in line with the business needs of the Applicant Company.

Funding Table

Eligible Courses Type of Course All Singapore Citizens and Permanent Residents Singapore Citizens
Aged ≥ 40 years Aged ≥ 35 years and earning ≤ $1,900/month
Non-Certifiable Courses approved by SSG All $2/hour

* For Company-sponsored (SME) Students Only

Take the Next Step

It Takes Less Than 5 Min

Brand your business-class email address with your company name to build name recognition, and market your business with customized marketing materials that are easy to create. Connect better with customers and colleagues with a range of communication tools, from email and IM to social networking and video conferencing.

Whether you’re working in your office or on the go, you get a familiar, top-of-the-line set of productivity tools. Office applications—always the latest versions—let you create, edit, and share from your PC/Mac or your iOS, Android™, or Windows device with anyone in real time.