Information Technology

Information Technology

Microsoft Word – intermediate level
Duration: 1 day

Course content

Advanced editing
Making Word work for you

Styles and auto text
Using the Style Organiser
AutoCorrect and AutoText

Tables
Making tables a breeze

Setting up tabs
Using Tabs
Using Tabs in a table

What delegates will learn

  • Use advanced editing features
  • Use and create styles
  • Store repetitive text
  • Create edit and format tables
  • Set up tabs

This course builds on the basic Word course. It will also suit those with a good working knowledge of Word who want to learn more about the wide range of functionality that Word offers,

Microsoft Word for Beginners
Duration: 1 day

Course content

The basics
Page setup
Using basic functions

Formatting
Managing formatting
Format painter

Editing
Working with changes

Managing files
Working effectively with files

What delegates will learn

  • Understand the Word screen
  • Format a basic document
  • Edit and print a document
  • Print a document
  • Copy and delete documents
  • File management

This course is for first time users of Microsoft Word

Microsoft Project
Duration: 1 day

Course content

The basics
Fundamentals of project management

Creating projects
Step by step guide to setting up the project

Formatting
Formatting the Gantt chart

Working with resources
How to link in the people

What delegates will learn

  • Understand the basic principles of Project
  • Format and print a project
  • Work with resources
  • Entering tasks and durations
  • Understanding and using milestones & linking tasks
  • Changing relationships
  • Setting lead and lag time and understand constraints
  • Outlining a project
  • Using summary and subtasks
  • Working with the critical path and using resources

This course is for people that have never used Microsoft Project but are tasked with managing a project efficiently.

Microsoft PowerPoint
Duration: 1 day

Course content

The basics
Getting started with Microsoft PowerPoint

Slides
Slide layouts, editing and formatting

Adding flair
Inserting objects, graphs and drawings

Features
Standard designs
Animation effects

What delegates will learn

  • How to get started with Microsoft PowerPoint
  • PowerPoint toolbars
  • Slide auto-layouts
  • Slide templates
  • Adding and editing text to a slide
  • Formatting
  • How to inserting objects, graphs and drawings
  • Creating a background
  • Standard designs & Animation effects
  • Creating slide shows

This course serves as a great introduction for those with little or no experience of working with Microsoft PowerPoint

Microsoft Excel Part 2
Duration: 1 day

Course content

Managing screens
Splitting screens, freezing panes, hide/unhide

Features
Autofill, relative v absolute, databases

Mulitple worksheets
Look up tables
Manipulating sheets

Charts and graphs
Using the chart wizard
Formatting charts

What delegates will learn

  • How to split screens
  • How to use freezing panes
  • How to use hide/unhide
  • How to use autofill
  • How to use relative vs absolute
  • How to use If function
  • File & sheet linking
  • How to use graphical images
  • How to use charts / graphs
  • How to use databases

Users who have completed the Intro to Excel or are familiar with basic formulas & entering / editing data.

Microsoft Access
Duration: 1 day

Course content

Database design
The key skills of the telesales person

Working with data
The process from preparation to the sale

Forms
Selling your product confidently and clearly

Queries
Recognising, negotiating and closing the sale

What delegates will learn

  • Access wizards
  • How to design a database
  • Define fields, data types and field properties
  • Define records, tables and table relationships
  • Validating and formatting fields
  • Using datasheet view
  • Searching and manipulating the data
  • How to use filtering
  • How to use form
  • How to use queries

This course is for people that have little or no knowledge of databases but need an introduction.