Full program description

Microsoft Excel 2016: Intermediate

What's In It For Me

  • Format list using advanced formatting commands
  • Present data using Excel Chart
  • Create summarize report using Functions

Course Overview

NTUC LearningHub Course Code: MSE16I

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

Course Duration

2 Days / 14 Hours

Course Outline

  • FORMAT WORKSHEETS
    • APPLY CONDITIONAL FORMATTING
      • Applying Conditional Formatting
      • Remove Conditional Formatting
    • APPLY AND REMOVE CELL STYLES
      • Apply a Cell Style
      • Remove a Cell Style
    • CREATE AND MODIFY CELL STYLES
      • Create a New Style
      • Modify a Style

  • BUILD FORMULAS
    • ABSOLUTE AND RELATIVE REFERENCES
      • Relative References
      • Absolute References
    • CELL AND RANGE NAMES
      • Create a Name
      • Use a Cell or Range Name in a Formula
      • Navigate to a Named Range
      • Edit and Delete Cell or Range Names
    • LOGICAL FUNCTIONS
      • IF Function
    • Mathematical and Trig Functions
      • Sumif
    • Statistically Functions
      • Countif
      • Averageif
    • TEXT FUNCTIONS
      • Concatenate Text
      • Left
      • Right
      • Len
    • FORMULA ERRORS
      • #NAME? Error
      • #DIV/0 Error

  • VIEW AND MANAGE WORKSHEETS
    • VIEW WORKBOOKS
      • Change Workbook Views
      • Use Zoom
      • Create a Custom View
      • Apply a Custom View
    • FREEZE ROWS AND COLUMNS
      • Freeze Rows and Columns
      • Unfreeze Panes
    • SPLIT THE WORKSHEET WINDOW
      • Add a Worksheet Window Split
      • Remove a Worksheet Window Split

  • DATA AND TABLES
    • SORT DATA
      • Sort by One Column
      • Sort by Multiple Columns
    • TABLES
      • Create a Table
      • Apply a Table Style
      • Convert to a Range
    • ADD AND REMOVE TABLE DATA
      • Add Table Rows and Columns
      • Remove Table Rows and Columns
    • REMOVE DUPLICATES
    • TOTAL ROWS
      • Add a Total Row
      • Change Calculations
    • SLICERS
      • Insert a Slicer
      • Filter with a Slicer
      • Clear and Remove a Slicer
    • FILTER DATA
      • Filter
      • Clear a Filter
    • DATA VALIDATION
      • Create a Validation Rule 
      • Add an Input Message
      • Add an Error Message
    • IMPORT DATA
    • EXPORT DATA

  • CHARTS 
    • CREATE CHARTS
      • Create a Chart
      • Create a Recommended Chart
    • MOVE AND RESIZE CHART
      • Move a Chart
      • Resize a Chart
    • DELETE A CHART
    • CHANGE CHART TYPE
    • LAYOUT AND STYLE
      • Apply a Chart Layout
      • Apply a Chart Style
    • CHART COLORS
    • TITLES AND LEGENDS
      • Change the Chart Title
      • Add Axis Titles
      • Position the Chart Legend
    • GRIDLINES
      • Show Chart Gridlines
    • LABELS AND DATA TABLES
      • Add Data Labels 
      • Display a Data Table
    • DATA SERIES
      • Change the Color of a Data Series
    • MODIFY CHART DATA
      • Add a Data Series
      • Rename a Data Series
      • Reorder a Data Series
    • FILTER CHARTS
      • Filter a Chart
      • Remove a Filter
    • SPARKLINES
    • CHART TEMPLATES
      • Save a Chart as a Template
      • Create a New Chart from a Template

Course Objectives

  1. Format list using advanced formatting commands
  2. Present data using Excel Chart
  3. Create summarize report using Functions

Pre-requisites

Completed "Microsoft Excel 2016: Beginner" course or possess equivalent knowledge and skills

Funding Information

  • Eligible Singapore Citizens can use their SkillsFuture credit to offset course fees. (Course ID: CRS-N-0033295)
  • Companies can claim $2/hr funding from SSG (SkillsConnect Reference Number: CRS-N-0033295)
  • 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/o GST w GST w/o GST
Original Course Fee $330.00 $353.10 $330.00 $353.10
Promotional Course fee (until 30 Sep 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

MSE16I