Full program description

Microsoft Excel 2016: Beginner

What's In It For Me

  • Familiarize with Microsoft Excel
  • Able to calculate by writing simple formulas and functions
  • Manage multiple worksheets in a file

Course Overview

NTUC LearningHub Course Code: MSE16B

SSG SkillsConnect Reference Number: CRS-N-0033304

Course Duration

2 Days / 14 Hours

Course Outline

  • GETTING STARTED
    • UNDERSTAND THE EXCEL SCREEN
    • CREATE WORKBOOKS
      • Create a Blank Workbook
      • Create a Workbook from a Template
    • NAVIGATE WORKSHEETS
    • OPEN AND SAVE WORKBOOKS
      • Open a Workbooks
      • Save a Workbook 
    • PRINT
    • HELP
    • CLOSE AND EXIT
      • Close a Workbook
      • Close Excel

  • EDIT A WORKBOOK
    • SELECT CELLS AND RANGES
      • Select a Cell
      • Select the Entire Worksheet
      • Select Rows
      • Select Columns
      • Select a Cell Range
    • EDIT CELL DATA
      • Enter Cell Data
      • Replace Cell Data
      • Delete Cell Data 
      • Edit Cell Data
    • CUT, COPY, AND PASTE
      • Copy and Paste
      • Cut and Paste
      • Move Using Drag and Drop
    • MORE PASTING OPTIONS
    • AUTOFILL
      • Copy Data Using AutoFill
      • Enter a Series of Values with AutoFill
    • INSERT AND DELETE CELLS
      • Insert Cells
      • Delete Cells
    • FIND AND REPLACE TEXT
      • Finding Text
      • Replacing Text
    • HIDE COLUMNS AND ROWS
      • Hide Rows or Columns
      • Unhide Rows or Columns

  • FORMAT WORKSHEETS
    • FORMAT TEXT
      • Changing Font Appearance
      • Changing Font Size and Color
      • Formatting a Part of a Cell
    • ALIGN CELLS
      • Change Cell Alignment
      • Indent a Cell’s Contents
    • WRAP TEXT AND MERGE CELLS
      • Wrap Text in a Cell
      • Merge Cells
      • Split Merged Cells
    • FORMAT NUMBERS AND DATES
      • Format a Number or Date
      • Use Advanced Number Formats
    • BORDERS AND BACKGROUND COLORS
      • Add Cell Shading
      • Add a Cell Border
      • Advanced Border Options
    • COPY FORMATTING
    • ROW HEIGHTS AND COLUMN WIDTHS
      • Adjust Column Width
      • Adjust Row Height
      • Use Additional Size Options
    • FIND AND REPLACE FORMATTING
    • INSERT AN IMAGE

  • BUILD FORMULAS
    • FORMULA AND FUNCTION BASICS
      • Create Formula
      • Edit a Formula
      • Use a Function
    • SUMS AND AVERAGES
      • Create a Sum Formula
      • Create an Average Formula
    • REFERENCE EXTERNAL DATA
      • Reference Another Worksheet
    • FORMULA ERRORS
      • #### Error
      • #VALUE! Error
      • #REF! Error

  • VIEW AND MANAGE WORKSHEETS
    • MOVE AND COPY WORKSHEETS
    • INSERT, RENAME, AND DELETE WORKSHEETS
      • Insert a Worksheet
      • Rename a Worksheet
      • Delete a Worksheet
    • HIDING WORKSHEETS AND GRIDLINES
      • Hide a Worksheet
      • Unhide a Worksheet
      • Hide or Display Gridlines

  • PRINT WORKSHEETS
    • PAGE SIZE AND SCALE
      • Change Page Size
      • Change Print Scale
    • PRINT AREA AND PAGE BREAKS
      • Set the Print Area
      • Remove a Print Area
      • Use Page Breaks
    • PRINT HEADINGS
      • HEADERS AND FOOTERS
      • Add a Header or Footer
      • Adjust the Header and Footer Height
    • MARGINS AND ORIENTATION
      • Set Print Margins
      • Set Page Orientation

Course Objectives

  1. Familiarize with Microsoft Excel
  2. Calculate by writing simple formulas and functions
  3. Manage multiple worksheets

Pre-requisites

  1. Simple typing using the keyboard
  2. Navigating using the mouse
  3. Managing files and creating folders
  4. Working knowledge of files management

Funding Information

  • Eligible Singapore Citizens can use their SkillsFuture credit to offset course fees. (Course ID: CRS-N-0033304)
  • Companies can claim $2/hr funding from SSG (SkillsConnect Reference Number: CRS-N-0033304)
  • 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 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

MSE16B