Full program description

Microsoft Excel 2013: Intermediate

What's In It For Me

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

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: MSE13I

SSG SkillsConnect Reference Number: CRS-N-0032567

Course Duration

2 Days / 14 Hours

Course Outline

  • Formatting a Worksheet
    • Applying and Removing Cell Styles
    • Using Document Themes
    • Applying Conditional Formatting
    • Finding and Replacing Formatting

  • Creating and Working with Charts
    • Choosing and Selecting the Source Data
    • Choosing the Right Chart
    • Editing, Adding, and Removing Chart Data
    • Changing Chart Data
    • Changing Chart Type
    • Using Sparkline
    • Changing Chart Layout and Style
    • Working with Chart Labels
    • Changing the Chart Gridlines
    • Changing the Scale
    • Emphasizing Data
    • Using Chart Template

  • Working with the Web and External Data
    • Inserting a Hyperlink
    • Importing Data from an Access Database or Text File

  • Managing Workbooks
    • Using Workbook Views
    • Splitting and Freezing a Window
    • Setting the Print Area
    • Adjusting Page Margins and Orientation
    • Adding Print Titles, Gridlines, and Row and Column Headings
    • Adjusting Paper Size and Print Scale
    • Printing a Selection, Multiple Worksheets, and Workbooks
    • Working with Multiple Workbook Windows

  • More Functions and Formulas
    • Referencing External Data
    • Defining Names
    • Using and Managing Defined Names
    • Displaying and Tracing Formulas
    • Understanding Formula Errors
    • Using Logical Functions (IF)
    • Text Functions
    • Math & Trig Functions
      • CountIF
      • SumIF
      • AverageIF

  • Working with Data Ranges
    • Sorting by One Column
    • Sorting by Multiple Columns
    • Filtering Data
    • Creating a Custom AutoFilter

  • Working with Tables
    • Creating a Table
    • Adding and Removing Data
    • Working with the Total Row
    • Removing Duplicate Rows of Data
    • Formatting the Table
    • Using Data Validation
    • Converting to a Range

Course Objectives

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

Pre-requisites

Funding Information

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

MSE13I