Course content Download Full Course Catalogue

Click on an application to jump to the overview. Click the headings to expand or collapse the content.


Digital Literacy

  • Getting started
  • Digital devices
  • Apps, applications and files
  • Staying safe
  • Communication
  • The Internet

Digital Skills

  • Mouse Skills
  • Keyboard Skills
  • Switching On and Off
  • Using Windows
  • Working with Applications
  • File Management
  • Web Skills

Entry Level

  • Mouse Skills
  • Keyboard Skills
  • Switching On and Off
  • Using Windows
  • Working with Applications
  • File Management
  • Web Skills
  • E-mail Skills
  • Word Processing
  • Working Safely

Digital Literacy Overview

Getting started

  • Digital literacy
  • Digital citizenship

Digital devices

  • Introducing digital devices

Apps, applications and files

  • Manufacturers, operating systems and applications
  • Managing files
  • Using external devices and storage
  • Sharing information

Staying safe

  • Viruses, malware and virus checkers
  • Phishing and unverified links
  • Your digital footprint
  • Password security

Communication

  • Using email and webmail
  • Online chat
  • Blogs and podcasts
  • Social networks
  • Etiquette and ethics

The Internet

  • Connecting to the internet
  • Web browsers
  • Using search engines
  • The Internet of Things

Download detailed Digital Literacy competencies

Digital Skills Overview

Mouse Skills

  • Moving, clicking and double clicking
  • Scrolling and dragging

Keyboard Skills

  • Inputting letters, numbers and punctuation
  • Delete and backspace
  • Using the keyboard to move around a file

Switching on and off

  • Logging on and logging off
  • Restarting and shutting down

Working with Windows

  • The desktop and parts of the window
  • Moving and re-sizing windows

Working with Applications

  • Opening files, selecting text
  • Cut, copy and paste
  • Task manager
  • Snipping tool
  • Problem steps recorder

File Management

  • The computer filing system
  • Finding, opening files and folders
  • Moving, copying files and folders
  • File compression
  • Deleting and restoring files

Web Skills

  • Web addresses
  • Searching the web
  • Using hyperlinks
  • Using web forms

Download detailed Digital Skills competencies

Entry Overview

Mouse skills

  • Introduction to Pointing Devices
  • Moving the mouse & clicking
  • Double Clicking
  • Dragging
  • Scrolling
  • Right Clicking
  • Drawing skills

Keyboard skills

  • Introduction to Text Entry Devices
  • Letters and numbers
  • Capital Letters
  • The Insertion Point / Text Entry Cursor
  • Punctuation & Symbols
  • The Return key
  • Backspace and Delete
  • The Tab Key
  • Useful Keys / Key Combinations

Switching on and off

  • Power Switches & Switching On
  • Logging On
  • Changing Your Password
  • Locking the Computer
  • Logging Off
  • Restarting
  • Shutting down

Using Windows

  • The Desktop
  • The Start Menu
  • Parts of a window
  • Maximise, minimise, close and restore
  • Moving a window
  • Resizing a window

Working with applications

  • Introduction to Applications
  • Starting Applications
  • Using the drawing canvas and drawing shapes
  • Toolbars
  • Menus
  • The Application Ribbon
  • Context Menus
  • Working with Dialogue Boxes & Task Panes
  • Save & Save As
  • Opening Files
  • Page Setup, Print Preview and Printing
  • Accessing 'Help'
  • Switching Between Windows
  • Selecting Text
  • Overtyping
  • Cut, Copy and Paste
  • Using 'Undo'
  • Working with Tables
  • Using Task Manager

File management

  • Introducing the Computer Filing System
  • The 'My Computer' window
  • Changing views
  • Locating your Network Drive
  • Working with the Explorer View
  • Finding and Opening Files & Folders
  • Sorting Files
  • Creating Folders
  • Moving & Copying Files / Folders
  • Renaming Files / Folders
  • Deleting Files
  • Restoring Files from the 'Recycle Bin'
  • Emptying the 'Recycle Bin'

Web skills

  • Introducing Web Browsers
  • Using Web Addresses
  • Finding and Following Links
  • Searching the Web
  • Using Web Forms

E-mail skills

  • Introducing E-mail
  • Opening & Closing Inbox Messages
  • Replying & Forwarding
  • Sending a New Message
  • Deleting Messages
  • Emptying 'Deleted Items'
  • Sorting Messages
  • Organising Messages
  • Creating Contacts
  • Using the Address Book
  • Working with Attachments
  • Adding Attachments

Word processing

  • Introduction to Word Processing
  • Working with Templates
  • Text Formatting
  • Layout Formatting
  • Find and Replace Text
  • Page layout
  • Inserting pictures and objects
  • Spell checking and proof-reading

Working safely

  • Understanding the Risks
  • Setting up your workstation
  • Routine Maintenance

Download detailed Entry Level competencies


Office Essentials for the Workplace

  • Working with Microsoft Office applications
  • Text and Text Formatting
  • Working with Files
  • Working with Tables
  • Working with Objects

Office Essentials

  • Getting started with programs

Office Essentials for the Workplace Overview

Working with Microsoft Office applications

  • Common Office screen elements
  • Ribbons
  • Getting Help

Text and Text Formatting

  • Selecting and formatting text
  • The Format Painter
  • Borders and shading
  • Bullet points
  • Hyperlinks
  • Finding and replacing text

Working with Files

  • Document properties
  • Using templates
  • Headers and footers
  • Keyboard shortcuts
  • Spellchecking
  • Page setup and printing

Working with Tables

  • Creating tables
  • Formatting tables
  • Adjusting tables

Working with Objects

  • Text boxes
  • Inserting pictures
  • Using SmartArt
  • Drawing shapes
  • Adding charts
  • Working with objects

Download detailed Office Essentials for the Workplace competencies

Office Essentials Overview

Getting started with programs

  • Common screen elements
  • Starting and closing applications
  • Using the Quick Access Toolbar
  • Using the Ribbon
  • Getting help

Download detailed Office Essentials competencies


Word for the Workplace

  • Working with documents
  • Formatting Documents
  • Working with Others

Level 1

  • Getting started with Word
  • Manipulating text
  • Proofing and printing
  • Layout and formatting
  • Working with objects
  • Working with tables
  • Collaboration tools

Level 2

  • Working with documents
  • Formatting content
  • Formatting documents
  • Illustrations and graphics
  • Using tables
  • Working with references
  • Proofing and working on documents with others
  • Sharing documents
  • Mass-mailing documents

Level 3

  • Managing Documents
  • Formatting content
  • Working with tables and charts
  • Tracking and reviewing documents
  • Referencing documents
  • Performing merges
  • Using macros
  • Using forms

Word for the Workplace Overview

Working with Documents

  • Outlining documents
  • Using the navigation pane
  • Adding a table of contents
  • Using bookmarks
  • Using auto correct

Formatting Documents

  • Formatting paragraphs
  • Indenting paragraphs
  • Setting tabs
  • Page formatting
  • Inserting section and page breaks

Working with Others

  • Sharing documents
  • Merging information in a document
  • Tracking changes

Download detailed Word for the Workplace

Level 1 Overview

Getting started with Word

  • Working with text
  • Working with documents
  • Changing the view of a document

Manipulating text

  • Selecting text
  • Undo and Redo
  • Using the Clipboard
  • Formatting text
  • Aligning text
  • Borders and shading
  • Using Format Painter
  • Setting tabs
  • Indenting paragraphs
  • Bullets and Numbering
  • Paragraph formatting
  • Page formatting
  • Inserting special characters, symbols and date

Proofing and printing

  • Spell-checking your document
  • Using the Thesaurus
  • Using Find and Replace
  • Printing documents

Layout and formatting

  • Inserting page and section breaks
  • Working with headers and footers
  • Using Publishing Format tools and Styles
  • Outlining your document
  • Creating footnotes and endnotes

Working with objects

  • Working with pictures
  • Manipulating pictures
  • Using the drawing canvas and drawing shapes
  • Working with other objects

Working with tables

  • Inserting tables
  • Formatting tables
  • Adjusting tables
  • Converting and sorting

Collaboration tools

  • Working with others

Download detailed Word Level 1 Content

Level 2 Overview

Working with documents

  • View documents
  • Navigate documents
  • Use the Document Navigation pane
  • Use document properties
  • Save documents
  • Work with AutoRecover and document versions

Formatting content

  • Format characters
  • Format with styles
  • Format paragraphs
  • Cut, copy and paste using the Clipboard
  • Organise using bullets
  • Organise using numbered and multilevel lists
  • Set tabs

Formatting documents

  • Apply and manipulate page setup settings
  • Use columns and hyphenation
  • Insert headers and footers
  • Outline a document
  • Manipulate page backgrounds and borders
  • Use templates
  • Use themes
  • Use building blocks

Illustrations and graphics

  • Work with pictures
  • Manipulate pictures
  • Include screenshots
  • Draw shapes
  • Arrange shapes and other objects
  • Use SmartArt
  • Use WordArt
  • Use text boxes

Using tables

  • Create a table
  • Manipulate tables
  • Format tables
  • Sort and convert tables

Working with references

  • Use hyperlinks
  • Add footnotes and endnotes
  • Use bookmarks
  • Add a table of contents

Proofing and working on documents with others

  • Find and replace text
  • Find and replace formatting
  • Spell-check a document
  • Use AutoCorrect
  • Add and view comments
  • Track changes
  • Compare and combine documents

Sharing documents

  • Protect a document with a password
  • Restrict access to a document
  • Share a document
  • Publish a document as a blog post

Mass-mailing documents

  • Create envelopes or labels
  • Merge information into a document
  • Merge information into labels

Download detailed Word Level 2 Content

Level 3 Overview

Managing Documents

  • Configure Word options
  • Use templates
  • Copy styles from another template
  • Apply a template to an existing document
  • Restrict access to a document

Formatting content

  • Apply advanced font attributes
  • Apply advanced paragraph attributes
  • Format with styles
  • Construct reusable content
  • Link text boxes

Working with tables and charts

  • Create a table using external data
  • Use formulas in a Word table
  • Add charts to a document

Tracking and reviewing documents

  • Track changes
  • Compare and combine documents

Referencing documents

  • Add citations and captions
  • List sources
  • Manage sources
  • Create cross-references
  • Create an index

Performing merges

  • Merge information into a document
  • Manage merges
  • Merge information into labels

Using macros

  • Set up and run a macro
  • Manage macros
  • Create shortcuts to macros

Using forms

  • Get started with forms
  • Content control properties
  • Prepare a form for distribution
  • Work with help text

Download detailed Word Level 3 Content


Level 1

  • Getting started with Excel
  • Manipulating the information
  • Working with formulas
  • Formatting a worksheet
  • Working with charts
  • Proofing and printing

Level 2

  • Viewing workbooks
  • Manipulating worksheets
  • Manipulating information
  • Using formulas
  • Using functions
  • Managing formulas and functions
  • Working with data
  • Formatting cells and worksheets
  • Formatting numbers
  • Working with charts
  • Working with illustrations
  • Collaborating with others
  • Preparing to print

Level 3

  • Setting up a workbook
  • Presenting data visually
  • Analysing data
  • Using PivotTables and PivotCharts
  • Formatting numbers
  • Using formulas and functions
  • Auditing workbooks
  • Using XML
  • Protecting and sharing workbooks
  • Using macros and form controls

Download detailed combined competencies for Excel

Level 1 Overview

Getting started with Excel

  • Basic concepts
  • Working with Workbooks
  • Managing your files
  • Entering data in the Worksheet

Manipulating the information

  • Selecting cells
  • Modifying data
  • Copying, moving and Auto-Filling data
  • Sorting data
  • Adjusting rows and columns
  • Managing Worksheets

Working with formulas

  • Creating simple formulas
  • Using common built-in functions
  • Using absolute and relative addresses
  • Being careful with formulas

Formatting a worksheet

  • Formatting cell contents
  • Borders, shading and Styles

Working with charts

  • Understanding charts
  • Changing the chart layout

Proofing and printing

  • Spell checking
  • Previewing the Worksheet
  • Adding and removing page breaks
  • Customising the printout
  • Printing the worksheet

Download detailed Excel Level 1 competencies

Level 2 Overview

Viewing workbooks

  • Open and arrange windows
  • Split panes
  • Freeze panes
  • Change the zoom

Manipulating worksheets

  • Adjust column width
  • Adjust row height
  • Insert and delete rows, columns and cells
  • Hide and unhide rows or columns
  • Manage worksheets

Manipulating information

  • Move and copy data
  • Paste with live preview
  • Use AutoFill
  • Use hyperlinks

Using formulas

  • Create and edit simple formulas
  • Understand and enforce simple precedence in formulas
  • Nest parentheses in formulas
  • Use relative and absolute cell references
  • Refer to other worksheets
  • Link other workbooks

Using functions

  • Get started with functions
  • Find, choose and insert functions
  • Define names for cells and cell ranges
  • Count cells using functions
  • Use logical functions: IF
  • Use logical functions: AND, OR
  • Use lookup functions

Managing formulas and functions

  • Understand error message
  • Use the Error Checking tool
  • Adjust error checking options
  • Display and print formulas
  • Trace formula precedents and dependents

Working with data

  • Create a table
  • Sort data
  • Filter data using AutoFilter
  • Use advanced filters
  • Use the subtotal function
  • Outline data
  • Convert text to columns
  • Apply conditional formatting rules
  • Visualise data with conditional formatting
  • Insert sparklines

Formatting cells and worksheets

  • Change the appearance of cells and their contents
  • Align cell contents
  • Wrap text in a cell
  • Merge and split cells
  • Use Format Painter
  • Use cell styles
  • Format using themes
  • Format worksheets

Formatting numbers

  • Format numbers in a cell
  • Format currency and accounting numbers
  • Format dates and times
  • Get started with custom number formats
  • Go further with custom number formats
  • Use custom date and time formats

Working with charts

  • Create a basic chart
  • Select and add chart data
  • Change a chart type
  • Create a pie chart
  • Move and resize charts
  • Customise chart design with styles and layouts
  • Add and arrange chart elements
  • Edit chart axes and gridlines
  • Format chart elements

Working with illustrations

  • Insert graphics
  • Draw shapes
  • Modify graphics
  • Insert WordArt
  • Using SmartArt graphics

Collaborating with others

  • Use document properties
  • Inspect a document
  • Use comments
  • Share workbooks
  • Track changes
  • Protect a workbook with a password
  • Protect cells
  • Validate data
  • Use pick lists

Preparing to print

  • Add headers and footers to worksheets
  • Adjust margins
  • Add and review page breaks
  • Print row and column headings
  • Customise printout

Download detailed Excel Level 2 competencies

Level 3 Overview

Setting up a workbook

  • Set advanced and custom workbook properties
  • Use workbook templates
  • Set calculation properties

Presenting data visually

  • Create dynamic charts
  • Format chart elements
  • Add a trendline to a chart
  • Add secondary axes to a chart
  • Use chart templates
  • Insert sparklines

Analysing data

  • Use the Goal Seek tool
  • Set up scenarios
  • Create a data table
  • Consolidate data from multiple worksheets

Using PivotTables and PivotCharts

  • Create a PivotTable
  • Manipulate a PivotTable
  • Use PivotTable slicers
  • Insert a PivotChart
  • Group data in a PivotTable

Formatting numbers

  • Get started with custom number formats
  • Go further with custom number formats
  • Use custom date and time format

Using formulas and functions

  • Use array formulas
  • Use lookup functions
  • Use logical functions: IF
  • Use logical functions: AND, OR
  • Use conditional summary functions

Auditing workbooks

  • Check for errors in workbooks
  • Adjust error checking options
  • Display and print formulas
  • Trace formula precedents and dependents
  • Evaluate a formula
  • Validate data
  • Locate invalid data
  • Use pick lists

Using XML

  • Get started with XML
  • Go further with XML
  • Export data as XML

Protecting and sharing workbooks

  • Protect a workbook with a password
  • Protect parts of a workbook
  • Work with Track Changes

Using macros and form controls

  • Create a macro
  • Create a shortcut to a macro
  • Manage macro settings
  • Insert form controls: buttons
  • Insert form controls: list boxes
  • Insert form controls: spin buttons

Download detailed Excel Level 3 competencies


Outlook for the Workplace

  • Introducing Email
  • Using Email
  • Organising Messages
  • Appointments and Meetings
  • Using Contacts

Level 2

  • Introducing Outlook
  • Writing and sending emails
  • Managing emails
  • Using the Calendar
  • Working with Contacts
  • Using Tasks
  • Using Notes and the Journal

Outlook for the Workplace Overview

Introducing Email

  • What Outlook is and how it can be used
  • The various Outlook modules

Using Email

  • Viewing emails
  • Replying and forwarding
  • Creating new messages
  • Signatures and the address book
  • Adding attachments
  • Setting up an out of office

Organising Messages

  • Sorting emails
  • Using folders
  • Searching for emails
  • Tidying up the inbox
  • Creating rules

Appointments and Meetings

  • Creating appointments
  • Creating meetings
  • Dealing with meeting requests and scheduling
  • Sharing a calendar

Using Contacts

  • Creating contacts
  • Creating contact groups

Download detailed Outlook for the Workplace competencies

Level 2 Overview

Introducing Outlook

  • Explore the Outlook modules
  • Use the Navigation Pane
  • Use the To-Do Bar
  • Create an email
  • View and read emails
  • Respond to emails
  • Categorise items
  • Flag an email

Writing and sending emails

  • Write and save drafts
  • Change message formats
  • Apply themes and stationery
  • Set default message fonts
  • Mark how important an email is
  • Mark how sensitive an email is
  • Set delivery options
  • Request delivery or read receipts
  • Use voting buttons
  • Add a signature

Managing emails

  • Work with attachments
  • Sort emails
  • Work with Conversations
  • Search emails
  • Use the People Pane
  • Work with folders
  • Archive emails
  • Use search folders
  • Set up rules for emails
  • Deal with junk email
  • Clean up the mailbox
  • Set up an out of office reply
  • Set security options
  • Work with data files

Using the Calendar

  • Looking at the calendar module
  • Create an appointment
  • Create an appointment from an email
  • Add an event
  • Request a meeting
  • Use the Scheduling Assistant
  • Make changes to a meeting
  • Set calendar options
  • Create and use multiple calendars
  • Share your calendar with a colleague
  • Share your calendar with somebody outside the organisation

Working with Contacts

  • Looking at the contacts module
  • Create a new contact
  • Create a new contact from an email
  • Use contacts folders
  • Use electronic business card
  • Create a contact group
  • Use a contact group

Using Tasks

  • View tasks and to-do items
  • Create a task
  • Record progress on a task
  • Manage tasks with folders
  • Assign a task to somebody else
  • Provide updates on a task

Using Notes and the Journal

  • Create a note
  • Manage notes
  • Use Outlook's Journal

Download detailed Outlook Level 2 Content


Level 1

  • Getting started with PowerPoint
  • Setting up the presentation
  • Working with text
  • Formatting text
  • Working with objects
  • Be able to format objects
  • Enhancing the presentation
  • Bringing it all together

Level 2

  • Working in PowerPoint
  • Creating a presentation
  • Formatting slides
  • Working with text
  • Working with graphics and multimedia
  • Working with tables and charts
  • Using animations and transitions
  • Collaborating on presentations
  • Preparing presentations
  • Delivering presentations

Download detailed combined competencies for PowerPoint

Level 1 Overview

Getting started with PowerPoint

  • Basic concepts
  • Creating presentations
  • Entering text in the Outline tab and Slide pane
  • Working with presentations
  • Displaying information in the presentation

Setting up the presentation

  • Creating a Master slide
  • Inserting headers and footers
  • Managing the slides

Working with text

  • Selecting and editing text
  • Manipulating text
  • Checking the spelling

Formatting text

  • Understanding formatting
  • Aligning text
  • Changing bulleted information

Working with objects

  • Using Clip Art
  • Using graphics
  • Working with tables
  • Working with charts
  • Working with objects
  • Formatting objects

Enhancing the presentation

  • Changing the background colour
  • Adding animation
  • Understanding motion paths
  • Adding slide transitions

Bringing it all together

  • Printing the presentation
  • Creating notes and handouts
  • Running and viewing the presentation

Download detailed PowerPoint Level 1 competencies

Level 2 Overview

Working in PowerPoint

  • View presentations in different ways
  • View multiple presentation windows
  • Configure PowerPoint options

Creating a presentation

  • Use templates and themes
  • Use slide masters
  • Create a presentation from an outline
  • Manage slides
  • Reuse slides from other presentations

Formatting slides

  • Change the layout of a slide
  • Add a background to a slide
  • Set up slide footers
  • Change the size and orientation of slides

Working with text

  • Enter and format text
  • Use text effects
  • Use lists
  • Use text boxes
  • Format text boxes

Working with graphics and multimedia

  • Insert and manipulate images
  • Insert and manipulate shapes
  • Arrange objects
  • Use SmartArt
  • Insert audio and video content

Working with tables and charts

  • Insert a table
  • Format a table
  • Insert a chart
  • Format a chart

Using animations and transitions

  • Add animation to a slide
  • Customise animations
  • Use Animation Painter
  • Use motion paths
  • Apply transitions

Collaborating on presentations

  • Use comments on a presentation
  • Proof a presentation
  • Compare and combine presentations
  • Protect a presentation

Preparing presentations

  • Add notes to slides
  • Save a presentation
  • Create handouts
  • Print a presentation

Delivering presentations

  • Run a slide show
  • Use presentation tools
  • Use timings and narration
  • Use multiple displays
  • Record and broadcast presentations

Download detailed PowerPoint Level 2 Content


Level 2

  • Getting started
  • Using notebooks
  • Managing content
  • Sharing and collaborating

Download detailed OneNote Level 2 Content

Level 2 Overview

Getting started

  • Introducing OneNote
  • Setting up a Notebook
  • Customising a notebook
  • Opening, closing and saving notebooks

Using notebooks

  • Creating pages and subpages
  • Working with pages
  • Managing pages
  • Working with sections
  • Using side notes

Managing content

  • Working with containers
  • Managing containers
  • Formatting text
  • Inserting tables
  • Inserting pictures
  • Using drawing tools
  • Copying and pasting from other applications
  • Adding links
  • Making linked notes
  • Inserting files
  • Using templates
  • Using history and backups
  • Tagging information
  • Searching for content

Sharing and collaborating

  • Sending content from OneNote
  • Sending content to OneNote
  • Sharing on OneDrive
  • Managing OneDrive files and folders
  • Setting shared permissions
  • Using OneNote Online
  • Other sharing options
  • Synchronizing changes
  • Collaborating with others

Download detailed OneNote Level 2 Content


Level 2

  • Fundamentals
  • Working with sites
  • Working with lists
  • Working with document and picture libraries
  • Working with pages
  • Working with meeting workspaces
  • Working with surveys

Download detailed SharePoint Level 2 Content

Level 2 Overview

Fundamentals

  • Introducing SharePoint
  • Accessing SharePoint
  • The SharePoint Environment
  • Using Alerts and RSS Feeds

Working with sites

  • Managing Sub Sites

Working with lists

  • Introducing Lists
  • Creating Lists
  • Modifying Lists
  • Using Lists

Working with document and picture libraries

  • Using Document Libraries
  • Managing files
  • Version control
  • Using Picture Libraries

Working with pages

  • Creating and editing pages
  • Managing pages on the Quick Launch
  • Working with the Recycle Bin

Working with workflows

  • Introducing Workflows
  • Adding a Workflow
  • Starting a Workflow
  • Tracking a Workflow

Working with meeting workspaces

  • Introducing Meeting Workspaces
  • Creating Meeting Workspaces
  • Using Meeting Workspaces
  • Managing Meeting Workspaces

Working with surveys

  • Creating a Survey
  • Completing a Survey
  • Viewing Survey Results

Download detailed SharePoint Level 2 Content