Full program description

Microsoft Excel 2013: 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

Please note, this course will be discontinued w.e.f 31 Aug 2017. Please register for the 2016 version here instead.

Course Overview

NTUC LearningHub Course Code: MSE13B

SSG SkillsConnect Reference Number: CRS-N-0032566

Course Duration

2 Days / 14 Hours

Course Outline

  • Program Fundamentals
    • Starting Excel 2013
    • Whats New in Excel 2013
    • Understanding the Excel Program Screen
    • Creating a New Workbook
    • Opening a Workbook
    • Previewing and Printing a Worksheet
    • Saving a Workbook
    • Closing a Workbook
    • Using Help
    • Exiting Excel

  • Getting Started with Worksheets
    • Navigating a Worksheet
    • Entering Labels and Values
    • Selecting a Cell Range and Entering Data in a Cell Range
    • Overview of Formulas and Cell References
    • Entering Formulas
    • Entering Content Automatically

  •  Editing a Worksheet
    • Editing Cell Contents
    • Copying and Moving Cells 
    • Inserting Cells, Rows, and Columns
    • Deleting Cells, Rows, and Columns
    • Using Undo and Redo
    • Finding and Replacing Content

  • Formatting a Worksheet
    • Formatting Text
    • Formatting Values
    • Adjusting Row Height and Column Width
    • Working with Cell Alignment
    • Adding Cell Borders and Background Colors
    • Copying Formatting

  • Managing Workbooks
    • Selecting and Switching Between Worksheets
    • Inserting and Deleting Worksheets
    • Renaming, Moving, and Copying Worksheets
    • Creating Headers and Footers
    • Hiding Rows, Columns, Worksheets, and Windows

  • More Functions and Formulas
    • Formulas with Multiple Operators
    • New Functions
    • Inserting and Editing a Function
    • AutoCalculate and Manual Calculation
    • Common Functions
      • Sum
      • Average
      • Max
      • Min
      • Count
      • CountA

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

Funding Information

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

MSE13B