Full program description

Microsoft Excel 2016: Advanced

What's In It For Me

  • Data analysis using Microsoft Excel Features
  • Extract data using Lookup functions
  • Repeat task using Record Macros

Course Overview

NTUC LearningHub Course Code: MSE16A

SSG SkillsConnect Reference Number / Course ID to Claim SkillsFuture Credit: CRS-N-0033298

Course Duration

2 Days / 14 Hours

Course Outline

  • FORMAT WORKSHEETS
    • APPLY CONDITIONAL FORMATTING
      • Advanced Conditional Formatting Rules
    • Create a Custom Number Format

  • BUILD FORMULAS
    • LOOKUP FUNCTIONS
      • VLOOKUP
      • LOOKUP
    • Date & Time Functions
    • Math & Trig Functions
      • Sumifs
    • Statistical Functions
      • CountIfs
      • AverageIfs

  • COLLABORATE WITH EXCEL
    • CELL COMMENTS
      • Add a Comment
      • View a Comment
      • Edit a Comment 
      • Delete a Comment
    • SHARE WORKBOOKS
      • Share a Workbook
      • Stop Sharing a Workbook
    • TRACK CHANGES
      • Turn on Track Changes
      • Track Changes
      • Review Changes
      • Save a Change History
    • PROTECT A WORKSHEET
      • Make Cells Editable
      • Hiding Formulas
      • Protect a Worksheet
    • PASSWORD PROTECTION
    • SAVE AS WEB PAGES

  • PIVOT TABLES 
    • CREATE PIVOTTABLES
    • USE MULTIPLE PIVOTTABLE FIELDS
      • Add an Additional Field Value
      • Expand or Collapse a Heading
    • CHANGE A PIVOTTABLE’S CALCULATION
    • FILTER PIVOTTABLES
      • Add a Filter Field
      • Clear and Remove a Filter
    • GROUP VALUES 
      • Group PivotTable Values
      • Ungroup PivotTable Values
    • TIMELINES
      • Insert a Timeline
      • Clear or Remove a Timeline
    • PIVOTTABLE LAYOUT
    • REFRESH A PIVOTTABLE
      • Manually Update a PivotTable
      • Automatically Update a PivotTable
    • FORMAT A PIVOTTABLE
      • Use Style Options
      • Apply a Built-in Style
    • PIVOT CHARTS
      • Insert a PivotChart
      • Modify a PivotChart

  • Analyzing Data
    • Creating Scenarios
    • Creating a Scenario Report
    • Grouping and Outlining Data
    • Using Subtotals

  • 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 Objectives

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

Pre-requisites

Must have completed "Microsoft Excel 2016: Beginner" and "Microsoft Excel 2016: Intermediate" level courses or possess equivalent knowledge and skills

Funding Information

  • Eligible Singapore Citizens can use their SkillsFuture credit to offset course fees. (Course ID: CRS-N-0033298)
  • Companies can claim $2/hr funding from SSG (SkillsConnect Reference Number: CRS-N-0033298)
  • 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 http://www.ntuclearninghub.com/pages/union-training-assistance-programme-utap

Price

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 31 Dec 2017) $295.00 $315.65 $295.00 $315.65
Fee payable $295.00 $315.65 $267.00# $287.65

Remarks:

  • 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

MSE16A