Training

ICDL Base Module Spreadsheets 1 Day

Description: 

Prerequisite

 None

Course Brief

 

Covers the key skills needed to use spreadsheets, can be applied to a range of spreadsheets software from vendor packages to ‘freeware'. Certifies best practice in effective spreadsheets software use

Course Outline

Managing Worksheets

  • Rows and Columns
  • Worksheets

 Formulas and Functions

  • Arithmetic Formulas
  • Functions

 Formatting

  • Numbers/Dates
  • Contents
  • Alignment, Border Effects

Charts

  • Create
  • Edit

 Prepare outputs

  • Setup
  • Check and Print

 

 

 

 

 

Specification: 

On completion of this module the candidate 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; 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; 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
  • Check and correct spreadsheet content before finally printing spreadsheets

  Subsidiaries of Totheburn Trading