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

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