Please note, we are closed @ 3pm on 24 Nov 2017 for our Dinner & Dance event. Last ticket to be issued is 2.30pm.    Changes to WSH Professional Courses w.e.f 1 Oct 2017! Click here to find out more!

Microsoft Excel 2013 Advanced

Course Overview

NTUC LearningHub Course Code: MSE16A

SSG SkillsConnect Reference Number: CRS-N-0032570

Course Objective

  1. Data analysis using Microsoft Excel Features
  2. Extract data using Lookup functions
  3. Repeat task using Record Macros
  4. Collaborate with co-workers


Must have completed “Microsoft Excel 2013: Beginner” and “Microsoft Excel 2013: Intermediate” level courses or possess equivalent knowledge and skills.

Course Duration

5 Days / 35 Hours

Course Outline

Formatting a Worksheet

  • Applying and Removing Cell Styles
  • Creating and Modifying Cell Styles
  • Using Document Themes
  • Applying Conditional Formatting
  • Creating and Managing Conditional Formatting Rules


Editing a Worksheet

  • Adding Comments to Cells
  • Tracking Changes


Managing Workbooks

  • Creating a Template
  • Protecting a Workbook
  • Protecting Worksheets and Worksheet Elements
  • Sharing a Workbook


Working with Data Ranges

  • Using an Advanced Filter


More Functions and Formulas

  • Using Database Functions (DSUM)
  • Using Lookup Functions (VLOOKUP)
  • Date & Time Functions
  • Math & Trig Functions
  • Statistical Functions
  • Lookup & Reference Functions


Working with PivotTables

  • Creating a PivotTable
  • Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Filtering and Sorting a PivotTable
  • Working with PivotTable Layout
  • Grouping PivotTable Items
  • Updating a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart
  • Creating a standalone PivotChart
  • Drilling up or down
  • Using Slicers
  • Sharing Slicers Between PivotTables


Analyzing Data

  • Creating Scenarios
  • Creating a Scenario Report
  • Using Goal Seek
  • Grouping and Outlining Data
  • Using Subtotals
  • Consolidating Data by Position or Category
  • Consolidating Data Using Formulas


Working with Macros

  • Recording a Macro
  • Playing and Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar


Customizing Excel

  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • Changing Excel’s Default Options
  • Creating a Custom Number Format


Course Fee:
Individual Sponsored Company Sponsored
w/o GST w GST w/o GST w GST
Original Course Fee $330.00 $353.10 $330.00 $353.10
Promotional Course fee (until 30 Jun 2017) $295.00 $315.65 $295.00 $315.65
Fee payable $295.00 $315.65 $267.00# $287.65



  • Individual Sponsored
    • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable.
    • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP). For more details on UTAP, click here.


  • Company Sponsored
    • # This course is supported by SSG with Cat-C Funding and Company sponsored candidates (Singapore Citizens and PRs) are eligible for $2/hr funding. Price indicated above is after funding.


Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.

Funding Information

  • Eligible Singapore Citizens can use their SkillsFuture credit to offset course fees. (Course ID: CRS-N-0032570)
  • Companies can claim $2/hr funding from SSG (SkillsConnect Reference Number: CRS-N-0032570)
  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) with Union Training Assistance Programme (UTAP). For more details on UTAP, visit here.
an NTUC Social Enterprise
© COPYRIGHT 2017 NTUC LearningHub. All Rights Reserved.