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. 

Participant will be able to

• 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

Completed Microsoft Excel 2013 Expert Core, or have equivalent Microsoft Excel 2013 Expert knowledge and experience:

• Manage the worksheet environment
• Create cell data
• Format cells and worksheets
• Manage worksheets and workbooks
• Apply formulas and functions
• Present data visually
• Share worksheet data with other users
• Analyze and organize data

English

Skillsfuture Singapore (SSG)

SSG Funding Validity Period

13 Sep 2018 – 11 Sep 2023

Singapore Citizens aged 25 years and above will be able to utilize their Skillsfuture Credits to offset against nett fee payable