Please enable JavaScript
24 hours – ICDL Perform Spreadsheet Functions (Excel 2016) – Eagle Infotech Consultants
Eagle Infotech Consultants
150 Orchard Road #06-14
Orchard Plaza Singapore 238841

24 hours – ICDL Perform Spreadsheet Functions (Excel 2016)

Course Duration
24 hours
Course Reference Number
CRS-Q-0030169-ES
Funding Validity Period
Till  3 Sep 2020
Mode of Training
Classroom
Course Synopsis

This module enables learners to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application.  Learners will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.On completion of this module each learner will be able to:

  • Work with spreadsheets and save them in different file formats
  • Choose built-in options such as the Help function within the application to enhance productivity
  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
  • Format numbers and text content in a spreadsheet
  • Choose, create and format charts to communicate information meaningfully
  • Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets

Target Audience
This course is intended for learners with little or no knowledge of using a spreadsheet application.

Assumed Skills
The learner must be able to:

  • operate a Personal Computer, use keyboard and mouse
  • read, write, speak and understand English (Work Place Literacy Level 4 – lower secondary level)

Course Content

Using the Application

Working with Spreadsheets
  • Open, close a spreadsheet application. Open and close spreadsheets.
  • Create a new spreadsheet based on default template.
  • Save a spreadsheet to a location on a drive. Save a spreadsheet under another name to a location on a drive.
  • Save a spreadsheet as another file type like: template, text file, software specific file extension, version number.
  • Switch between open spreadsheets
Enhancing Productivity
  • Set basic options/preferences in the application: user name, default folder to open, save spreadsheets.
  • Use available Help functions.
  • Use magnification/zoom tools.
  • Display, hide built-in toolbars. Restore, minimize the ribbon.

Cells

Insert, Select
  • Understand that a cell in a worksheet should contain only one element of data, (for example, first name detail in one cell, surname detail in adjacent cell).
  • Recognize good practice in creating lists: avoid blank rows and columns in the main body of list, insert blank row before Total row, ensure cells bordering list are blank.
  • Enter a number, date, text in a cell.
  • Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet.
Edit, Sort
  • Edit cell content, modify existing cell content.
  • Use the undo, redo command.
  • Use the search command for specific content in a worksheet.
  • Use the replace command for specific content in a worksheet.
  • Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order.
Copy, Move, Delete
  • Copy the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
  • Use the AutoFill tool/copy handle tool to copy, increment data entries.
  • Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
  • Delete cell contents.

Managing Worksheets

Rows and Columns
  • Select a row, range of adjacent rows, range of non-adjacent rows.
  • Select a column, range of adjacent columns, range of non-adjacent columns.
  • Insert, delete rows and columns.
  • Modify column widths, row heights to a specified value, to optimal width or height.
  • Freeze, unfreeze row and/or column titles.
  • < >Switch between worksheets.
  • Insert a new worksheet, delete a worksheet.
  • Recognize good practice in naming worksheets: use meaningful worksheet names rather than accept default names.
  • Copy, move, rename a worksheet within a spreadsheet.

Formulas and Functions

Arithmetic Formulas
  • Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas.
  • Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).
  • Identify and understand standard error values associated with using formulas: #NAME?, #DIV/0!, #REF!.
  • Understand and use relative, absolute cell referencing in formulas.
Functions
  • Use sum, average, minimum, maximum, count, counta, round functions.
  • Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <.

Formatting

Numbers/Dates
  • Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands.
  • Format cells to display a date style, to display a currency symbol.
  • Format cells to display numbers as percentages.
Contents
  • Change cell content appearance: font sizes, font types.
  • Apply formatting to cell contents: bold, italic, underline, double underline.
  • Apply different colours to cell content, cell background.
  • Copy the formatting from a cell, cell range to another cell, cell range.
Alignment, Border Effects
  • Apply text wrapping to contents within a cell, cell range.
  • Align cell contents: horizontally, vertically. Adjust cell content orientation.
  • Merge cells and centre a title in a merged cell.
  • Add border effects to a cell, cell range: lines, colours.

Charts

Create
  • Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart.
  • Select a chart.
  • Change the chart type.
  • Move, resize, delete a chart.
Edit
  • Add, remove, edit a chart title.
  • Add data labels to a chart: values/numbers, percentages.
  • Change chart area background colour, legend fill colour.
  • Change the column, bar, line, pie slice colours in the chart.
  • Change font size and colour of chart title, chart axes, chart legend text.

Prepare Outputs

Setup
  • Change worksheet margins: top, bottom, left, right.
  • Change worksheet orientation: portrait, landscape. Change paper size.
  • Adjust page setup to fit worksheet contents on a specified number of pages.
  • Add, edit, delete text in headers, footers in a worksheet.
  • Insert and delete fields: page numbering information, date, time, file name, worksheet name into headers, footers.
Check and Print
  • Check and correct spreadsheet calculations and text.
  • Turn on, off display of gridlines, display of row and column headings for printing purposes.
  • Apply automatic title row(s) printing on every page of a printed worksheet.
  • Preview a worksheet.
  • Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.

Course Fees (Self-Sponsored)

Full Fee GST Nett Fee after Funding (Incl. GST)
MCES Normal WTS
$535 $37.45 $90.95 $164.45 $64.20

MCES: Singaporean age 40 and above
Normal: Singaporean/PR age 21 and above
WTS: Singaporean age 35 and above and earning  $2,000 or below per month

 

View Course Dates