Skip To Content
Microsoft Excel Advanced (Windows Only) is a Program

Microsoft Excel Advanced (Windows Only)

Time limit: 14 days

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Microsoft Excel Advanced (Windows Only)

What's In It For Me

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

Software:

(For Virtual Learning Classroom)

Participant laptop and desktop must be pre-installed

With Windows Microsoft Excel 2016 or above

Course Overview

NTUC LearningHub Course Code: MSEA

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 PIVOTTABLES 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
  • Analysing 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
  • Customising Excel
    • Customising the Ribbon
    • Customising the Quick Access Toolbar
    • Changing Excels 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

Price

Course Fee:
  Before GST With GST
Full Course Fee  $  330.00  $  353.10

Remarks:

  • Individual Sponsored
    • 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
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

MSEA