Training: ICDL BASE – Spreadsheets – BM4

Ref. ECDL1-BM4
Duration:
2
 days
Exam:
Optional
Level:
Fundamental

Description

This course sets out essential concepts and skills relating to understanding the concept of spreadsheets and using a spreadsheet to produce accurate work outputs.

Participant profiles

  • Anyone who already have basic knowledge of the Excel Spreadsheet and wish to obtain the ICDL certification

Objectives

  • Work with spreadsheets and save them in different file formats, locally or in the cloud
  • Use available help resources, shortcuts and the go to tool 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 recognize error values in formulas
  • Format numbers and text content in a spreadsheet and use available autoformat/table styles
  • Choose suitable charts, and create and format charts to communicate information meaningfully
  • Adjust spreadsheet page settings and check and correct spreadsheet content before printing

Prerequisites

  • Basic knowledge of Windows
  • Have worked with Excel

Course content

Using the Application

Module 1: Working with Spreadsheets

  • Open, close a spreadsheet application. Open, close spreadsheet(s)
  • Create a new spreadsheet based on default template, other available template locally or online
  • Save a spreadsheet to a location on a local, online drive. Save a spreadsheet under another name to a location on a local, online drive
  • Save a spreadsheet as another file type like: text file, pdf, csv, software specific file extension
  • Switch between open spreadsheets

Module 2: Enhancing Productivity

  • Set basic options/preferences in the application: user name, default folder to open, save documents
  • Use available help resources
  • Use magnification/zoom tools
  • Display, hide built-in toolbars. Restore, minimise the ribbon
  • Recognise good practice in navigating within a document: use shortcuts, go to tool
  • Use go to tool to navigate to a specific page

Cells

Module 1: Insert, Select

  • Understand that a cell in a worksheet should contain only one element of data, for example, quantity in one cell, description in adjacent cell
  • Recognise good practice in creating lists: avoid blank rows and columns in the main body of list, 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

Module 2: Edit, Sort

  • Edit cell contents
  • Use the undo, redo command
  • Use a simple search command for specific content in a worksheet
  • Use a simple replace command for specific content in a worksheet
  • Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order

Module 3: Copy, Move, Delete

  • Copy the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets
  • Use the autofill tool/copy handle tool to copy, increment data, formula, function
  • Move the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets
  • Delete cell contents

Managing Worksheets

Module 1: 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 width, row height to a specified value, to optimal width or height
  • Freeze, unfreeze row and/or column titles

Module 2: Worksheets

  • Insert a new worksheet, delete a worksheet
  • Recognise good practice in naming worksheets: use meaningful worksheet names rather than the default names
  • Copy, move a worksheet within a spreadsheet, between spreadsheets. Rename a worksheet

Formulas and Functions

Module 1: Arithmetic

  • Recognise good practice in formula creation: use cell references rather than numbers in formulas
  • Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division)
  • Identify and understand standard error values associated with formulas: #NAME?, #DIV/0!, #REF!, #VALUE!
  • Understand and use relative, absolute cell referencing in formulas

Module 2: 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

Module 1: 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 date style, currency symbol
  • Format cells to display numbers as percentages

Module 2: Contents

  • Apply text formatting to cell contents: font size, font type
  • Apply text formatting to cell contents: bold, italic, underline, double underline
  • Apply different colours to cell contents, cell background
  • Apply an autoformat/table style to a cell range
  • Copy the formatting from a cell, cell range to another cell, cell range

Module 3: Alignment, Border Effects

  • Apply, remove text wrapping to contents within a cell, cell range
  • Align cell contents: horizontally, vertically. Adjust orientation of cell contents
  • Merge and centre cell contents in a merged cell. Unmerge cells
  • Apply, remove border effects to a cell, cell range: lines, colours

Charts

Module 1: Create

  • Understand the uses of different types of chart: column chart, bar chart, line chart, pie chart
  • 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

Module 2: Edit

  • Add, remove, edit a chart title
  • Add, remove a chart legend
  • Add, remove data labels in 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

Preparing to print

Module 1: 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, delete fields: page numbering, date, time, file name, worksheet name into headers, footers

Module 2: 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

Documentation

  • Digital courseware included

Lab / Exercises

  • Practice exercises will be offered during and at the end of each module

Exam

  • This course prepares to the exam ICDL Base – Spreadsheets (BM4). If you wish to take this exam, please contact our secretariat who will let you know the cost of the exam and will take care of all the necessary administrative procedures for you

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 1'200.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • Exam fee (Skills Card not included)
  • Pre-training level evaluation
  • Digital documentation

jeu18juil(juil 18)09:00ven19(juil 19)17:00VirtuelVirtual Etiquettes de sessionECDL1-BM4

jeu18juil(juil 18)09:00ven19(juil 19)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL1-BM4

jeu22Aoû(Aoû 22)09:00ven23(Aoû 23)17:00VirtuelVirtual Etiquettes de sessionECDL1-BM4

jeu22Aoû(Aoû 22)09:00ven23(Aoû 23)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL1-BM4

jeu26Sep(Sep 26)09:00ven27(Sep 27)17:00VirtuelVirtual Etiquettes de sessionECDL1-BM4

jeu26Sep(Sep 26)09:00ven27(Sep 27)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL1-BM4

jeu31Octven01NovVirtuelVirtual Etiquettes de sessionECDL1-BM4

jeu31Octven01NovLausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL1-BM4

jeu05Déc(Déc 5)09:00ven06(Déc 6)17:00VirtuelVirtual Etiquettes de sessionECDL1-BM4

jeu05Déc(Déc 5)09:00ven06(Déc 6)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL1-BM4

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X