Microsoft Excel 2016 Basic and Intermediate
Print in

Objective:

Participants will learn how to use Microsoft Excel to perform calculation and some simple functions, creating chart and understanding the use of spreadsheet.

Course Outline

Getting Started

  • Spreadsheets
  • File Ribbon Tab
  • Ribbon
  • Quick Access Toolbar
  • Tell me what you want to do (New!)

Working with a Workbook

  • Create a Workbook
  • Save a workbook
  • Open a Workbook
  • Entering a Data

Manipulating Data

  • Select Data
  • Copy and Paste
  • Cut and Paste
  • Fill Handle
  • Undo and Redo
  • Flash Fill

Modifying a Worksheet

  • Insert Cells, Rows and Columns
  • Delete Cells, Rows and Columns
  • Modifying column, row and cells
  • File and Replace
  • Go To Command
  • Spell Check
  • Entering Formulas
  • Function Library

Formulas

  • Excel Formulas
  • Function Library
  • Relative and Absolute
  • Linking Worksheets

Formatting a Worksheet

  • Convert Text to Columns
  • Modify Fonts
  • Format Cells Dialog Box
  • Add Borders and Colors to Cells
  • Formatting Value
  • Creating a Custom Number
  • Hide or Unhide Rows and Columns
  • Merge Cells
  • Align Cell Contents

Developing a Workbook

  • Format Worksheet Tab
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheet

Page Properties and Printing

  • Set Print Titles
  • Create a Header and Footer
  • Set Page Margins
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range

Charts

  • Create a Chart
  • Recommended Chart
  • Modifying a Chart
  • Chart Tools
    • Pie Chart Example
  • Sparklines

Sort and Filter

  • Basic Sorts
  • Custom Sorts
  • Filtering

Customize the Layout

  • Split a Worksheet
  • Freeze Rows and Column
  • Hide and Unhide Worksheets

For individial, you may submit your claim via http://www.skillsfuture.sg/credit.

Register online @ http://one.pa.gov.sg

SDF Applicant, please register @ https://www.skillsconnect.gov.sg

IT Centre reserves the right to reschedule the course without prior notice due to class size or unforeseen circumstances.