IT Training

MS Word Introduction

Target Audience: If you are a newcomer or self taught user on MS Word, then this course will be perfect. The course covers all topics required to produce documents that not only look good, but are well structured.

Content:

  • Creating New Documents
  • How to Format Text and Paragraphs
  • Creating Bullet and Numbering Lists
  • Using Tabs
  • Creating Tables
  • How to Insert Clipart and Pictures
  • Performing Page Setup
  • Printing Documents

Course Requirements: You do not need any previous knowledge of Word, but should have basic windows, keyboard and mouse skills.

Course Duration: One Day.

MS Word Intermediate

Target Audience: This MS Word intermediate course will build on the basic course. The course is perfect for existing Word users whom need to produce documents that are more complex with graphics or charts.

Content:

  • Formating Tables
  • Creating Newspaper Columns
  • Create AutoText and AutoCorrect Entries
  • Applying Section Breaks
  • Odd/Even and Different Headers & Footers
  • Use of Advanced Proofing Tools

Requirements: You must have good basic Word skills to get the most from this course.

Course Duration: One Day.

 

MS Word Advanced

Target Audience: The advanced Word training course will help users that need to produce large documents, e.g. legal or proposal documents.

Content:

  • Understanding Use and Apply Styles
  • How to Create Table of Contents, Index and Referencing Tools
  • Creating Templates
  • How to Track Changes
  • How to Use Outlining to Restructure
  • Creating Basic Macros

Requirements: You must have sound Word skills and understand key concepts of documents, or equivalent to our Intermediate course level.

Course Duration: One Day.

 

MS Excel Introduction

Target Audience: This course is designed for new users of Excel, or those whom have been self taught. We cover all aspects of creation a spreadsheet including writing formulae.

Content:

  • Creating and maintaining spreadsheets
  • How to create and edit formulae
  • Format and print worksheets
  • Performing basic list management tasks

Requirements: You do not need any previous knowledge of Excel, but should have basic windows, keyboard and mouse skills.

Course Duration: One Day.

 

MS Excel Intermediate

Target Audience: This Excel intermediate course will build on your basic Excel skills and show you more complex formulae, how to build formulae across worksheets, linking data and charting your data. We also cover protecting your sheets and workbooks.

Content:

  • Use of Logical Functions, Financial and Statistical Functions
  • Nest Functions
  • Multiple Worksheet Management and Formulae
  • Creating Charts
  • How to Protect Worksheets & Workbooks

Requirements: To get the most from this course, you must be able to perform basic Excel actions and create formulae and functions.

Course Duration: One Day.

 

MS Excel Advanced

Target Audience: This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros.

Content:

  • Using Lookup & Informational Functions
  • How to Create Pivot Tables
  • Using the What-If Tools
  • Sharing and Tracking Workbooks
  • Recording Basic Macros

Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.

Course Duration: One Day.

 

MS PowerPoint Introduction

Target Audience: This course is designed for new users, or users that have been self taught on PowerPoint. The course covers all aspect of creating a presentation from scratch right through to running a presentation with animation.

Content:

  • Creating Presentations
  • Formating Presentations
  • Creating Charts, Tables, Diagrams etc
  • How to Create Handouts
  • Animation and Presenting Skills

Requirements: No previous experience of PowerPoint is required to attend this course. You should have basic windows, keyboard and mouse skills.

Course Duration: One Day.

 

MS PowerPoint Advanced

Target Audience: This course is designed for users that have been self taught on PowerPoint or whom have attended an introduction course. The course covers more advanced tools and running multiple presentations.

Content:

  • How to Create Multiple Masters
  • How to Import / Link Data
  • Advanced Animation
  • Advanced Slide Show Techniques
  • Actions Settings

Requirements: You should have a good basic level of PowerPoint knowledge before attending this course

Course Duration: One Day.

 

MS Access Introduction

Target Audience: This course is designed for new Access users or self taught users. The course will cover all aspects of database design and objects.

Content:

  • Understanding Database Concepts and Objects
  • How to Create, Edit and Maintain Tables
  • Creating Queries
  • Creating Forms
  • Creating Reports
  • How to Create Relational Tables, Forms, Queries and Reports

Requirements: No previous experience of Access is required to attend this course. You must have good basic Windows skills, e.g. Mouse and Keyboard

Course Duration: Two Days.

 

MS Access Intermediate

Target Audience: This course is designed for existing Access users with sound basic skills. The course will focus more on Queries, Forms and reports. We also cover more advanced relationships.

Content:

  • How to Create Action Queries
  • Creating Advanced Forms
  • How to Create Advanced Reports
  • Understanding and Creating a Switchboard

Requirements: You must have sound Access skills and understand key concepts of a database, equivalent to our intermediate course contents.

Course Duration: One Day.

MS Access Advanced

Target Audience: This course is designed for existing Access users whom need to start automating database tasks or simply complex database sequences.

Content:

  • Creating and Appling Macros
  • Understand Events
  • Creating Conditional and Named Macros
  • Creating Custom Toolbars and Menu’s
  • Using the Startup Options

Requirements: You must have sound Access skills and understand key concepts of a database, equivalent to our intermediate course contents.

Course Duration: One Day.

MS Outlook Introduction

Target Audience: This course is designed for new users of MS Outlook. If you are self taught, then the course will also bridge knowledge gaps.

Content:

  • How to Send and receive email
  • Managing email with folders
  • Using the Contacts Facility
  • Using the Calendar
  • Using Tasks
  • How to Use Notes

Requirements: No previous experience on Outlook is required, but you should have good basic Windows skills.

Course Duration: One Day.

Windows 7

Target Audience: This course is designed for new users of Windows 7 and for existing Windows XP users migrating to the Windows 7 environment. If you are self taught, then the course will also bridge knowledge gaps.

Content:

  • Introducion to Microsoft
  • Windows 7
  • Use The Start  Menu and Taskbar
  • Exploring The Features in Windows 7 Environment
  • Working With Files and Folders
  • Working With New and Enhanced Programs
  • How to Create Shortcuts, Use Gadgets and Change System Settings
  • How to Browse the Web with Internet Explorer

Requirements: No previous experience on Windows is required, but you should be able to use a keyboard and mouse.

Course Duration: One Day.

 

Ms Publisher – Introduction

Target Audience: This course is designed to introduce users to the techniques of Desk Top Publishing. After this one day course, delegates will be able to design and create professional stationery and publications.

Content:

  • Creating Publications with the Wizard and by Design
  • Working with the Publication Layout
  • Page Layout
  • Working with Frames
  • Using tools – Clipart, WordArt etc
  • Editing & Formatting
  • Bullet/Numbered Lists
  • Importing Text
  • Working with Borders, Shadows and Patterns
  • The Finishing Touches
  • Spell-Check
  • Printing your Publication

Requirements: The Abilityto use a keyboard and mouse.

Course Duration: One Day.