Microsoft Excel 2016 Beginner

Course Overview

NTUC LearningHub Course Code: MSE16B

SSG SkillsConnect Reference Number: CRS-N-0033304

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

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
an NTUC Social Enterprise
© COPYRIGHT 2019 NTUC LearningHub. All Rights Reserved.