ICDL – Perform Spreadsheet Functions (Microsoft Excel) Core Level 2-days

COURSE details

Course Duration

17 HRS

Course Reference Number

N.A

Mode of Training

Classroom

  • 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

Course Outline

Overview of Module
Getting Started
  • Features and uses of a spreadsheet application
  • Start and exit spreadsheet application
  • Create a workbook
  • Open and close a workbook
  • Switch between workbooks
  • Save a workbook
  • The Excel screen
  • Display toolbar/Ribbons
  • Use magnification/zoom
  • Set basic options/preferences
  • Use Help function
Insert Data And Select Cells
  • Enter text, numbers and date
  • Move around a worksheet
  • Cell selection techniques
Edit And Sort Data
  • Edit cell contents
  • Use Undo and Redo commands
  • Use Find and Replace commands
  • Sort data
Copy, Move And Delete Cell Contents
  • Use copy/cut and paste
  • Using Clipboard
  • Paste Special
Rows And Columns
  • Insert and delete rows and columns
  • Insert and delete cell
  • Modify column width and row heights
  • Freeze and unfreeze rows and column
Worksheets
  • Turn on/off display of gridlines
  • Switching between worksheets
  • Select worksheets
  • Insert and delete worksheets
  • Copy, move and rename worksheets
Formulas
  • Create formula (Add, Subtract, Multiply, Divide)
  • Using mathematical operators (=, -, *, /)
  • Enter a formula
  • Use cell references in formula
Functions
  • Using Functions
  • Use AutoSum
  • Use AVERAGE, COUNT, MAX, MIN, COUNTA and ROUND functions
  • Use Logical function
  • Relative and absolute referencing
  • Display and print formulas
  • Common error messages in formula
Formatting
  • Format number and text
  • Format number and text
  • Using Format Painter
Charts
  • Create a chart
  • Move, re-size and delete a chart
  • Edit a chart
Worksheet Setup
  • Use the Spell-check command
  • Adjust page options
  • Add Header and Footer
  • Change sheet display options
Printing
  • Preview a worksheet
  • Use basic print options
  • Set print area
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored / Self Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$390 $35.10 $425.10

Related Courses

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761