Training Courses

Microsoft Excel Foundation 1 Day Training Course

The Course Includes:

  • Introduction to spreadsheets
  • Overview of Excel menus and toolbars
  • Entering and editing data & text
  • Adjusting column & rows
  • Inserting and deleting columns & rows
  • Selecting & formatting data
  • Copy and pasting data & text
  • Using Auto sum for quick calculations
  • How to build formulas to perform calculations
  • Introduction to Excel functions
  • Printing Excel spreadsheets

Microsoft Excel Intermediate 1 Day Training Course

The Course Includes:

  • Excel overview refresher
  • Understanding absolute cell addresses
  • Linking data between workbooks
  • Using advanced formulas & functions
  • Highlighting values with conditional formatting
  • Understanding Conditional Logic: Using IF statements
  • Finding records using VLookup & HLookup functions
  • Creating subtotals & working with levels
  • Sorting data using advanced filters
  • Sorting data using pivot tables and charts
  • Creating and using macros
  • Protecting workbooks, worksheets & individual cells
  • Consolidating data in multiple worksheets & workbooks
  • Data validation: creating drop-down lists
  • Embedding spreadsheets in Word & PowerPoint documents
  • Using charts and graphs to display data

Microsoft Excel Advanced 1 Day Training Course

The Course Includes:

  • Advanced Conditional Logic: nested IF, AND, OR & NOT functions
  • The Maths Functions: using SUMIF, COUNTIF & AVERAGEIF
  • New Excel 2007 Functions: using SUMIFS, COUNTIFS & AVERAGEIFS
  • Working with Data: the TRIM, FIND, MID & VALUE functions
  • Finding Data Records: using the MATCH & INDEX functions
  • Advanced Database Functions: the DSUM, DAVERAGE & DCOUNT functions
  • Analytical Tools: using Goal Seek & Scenarios

Microsoft Project Foundation 1 Day Training Course

The Course Includes:

  • Introduction to the main MS Project Views
  • How MS Project creates the Gantt Chart
  • Creating & defining a new project
  • Defining project working times
  • Creating custom calendars
  • Entering and outlining project tasks
  • Understanding task linkage types
  • How to link tasks correctly
  • Setting milestones & deadlines
  • Setting lag and lead time
  • Entering & assigning resources
  • How to resolve overallocated resources
  • Setting the baseline & interim plans
  • Tracking and updating the project

Microsoft Project Training Advanced 1 Day Training Course

The Course Includes:

  • Understanding the critical path in MS Project
  • Correctly applying task constraints
  • Creating individual task calendars
  • Working with multiple pay rates
  • Applying custom calendars& work times
  • Entering material resource consumption rates
  • Interrupting work & rescheduling tasks
  • Setting up recurring tasks
  • Working with resource availability
  • Leveling overallocated resources
  • Grouping data by custom selection
  • Applying & working with a budget in MS Project
  • Creating detailed visual reports in Excel

Microsoft Access Foundation 1 Day Training Course

The Course Includes:

  • What’s new in Access 2007
  • Creating a new database
  • Opening database files
  • Creating tables
  • Using table views
  • Understanding data types
  • Setting Primary keys
  • Changing field properties
  • Creating input masks
  • Understanding table relationships
  • Using sub datasheets
  • Creating & using forms
  • Using filters
  • Creating queries

Microsoft Word Foundation 1 Day Training Course

The Course Includes:

  • Creating a file and folder structure
  • Overview of Word menus and toolbars
  • Opening and saving Word documents
  • Entering and formatting text
  • Formatting paragraphs
  • Proofing text
  • Copying and pasting text
  • Importing graphics & photos
  • Creating page layouts using tables
  • Printing Word documents

Microsoft Word Training Advanced 1 Day Training Course

The Course Includes:

  • Creating and applying Styles
  • Structuring a document with Levels
  • Understanding and using Outline View
  • Creating a Table of Contents
  • How to create protected Forms
  • Inserting and using Bookmarks
  • How to cross reference bookmarks
  • Inserting Citations & creating a Bibliography
  • How to import and edit graphics & photos
  • Creating protected form documents
  • Creating and running Macros

Microsoft PowerPoint Training Course: 1 Day Foundation / Advanced

The Course Includes:

  • Overview of PowerPoint capabilities
  • Overview of menus and toolbars
  • Introduction to the PowerPoint screens & views
  • Using the Auto Content wizard for quick slideshows
  • Creating slides using AutoLayout templates
  • Customising slide colour schemes
  • Adding graphics, photos and video
  • Adding slide transitions
  • Adding text animation effects
  • Running the slideshow

Presentation Skills 2 Day Training Course

The Course Includes:

Day 1

  • Microsoft PowerPoint Training Course

Day 2

  • The importance of good presentation skills
  • Dealing with public speaking nerves
  • Engaging the audience
  • Understanding non-verbal communication
  • Use of visual aids: flipchart, handouts etc
  • Structuring the presentation
  • Pre-presentation preparation
  • Dealing with problems

Beginners IT Foundation Training Course

The Course Includes:

  • Overview of Microsoft Windows
  • Setting up a simple file structure
  • Creating files & folders
  • Opening & closing applications
  • Working with multiple applications
  • Understanding the Internet
  • How to use an Internet web browser
  • Sending and receiving email & attachments
  • Introduction to Microsoft Word
  • Basic word processing with MS Word
  • Writing a professional business letter

Email Marketing Training Course:
1 Day Foundation

The Course Includes:

  • UsingĀ  email as an effective marketing tool
  • Understand permission based email Vs Spam
  • Methods of email delivery
  • Designing effective email flyers
  • Writing subject lines which capture attention
  • Running campaigns using an email service provider
  • Tracking email campaigns using metrics
  • Building & maintaining an email database
  • How to get people to subscribe to your email list

Website Design Training Course: 1 Day Foundation

The Course Includes:

  • The principles of good website design
  • Registering domain names and website hosting
  • Introduction to the web language of HTML
  • Using Microsoft FrontPage
  • Building the first web page
  • Building an efficient website menu
  • Creating additional web pages
  • Using photos and graphics
  • Uploading the website using FTP

Macromedia Dreamweaver Training Course:
1 Day Foundation

The Course Includes:

  • Overview of the software menus and tool pallets
  • Setting up the website folder structure
  • Configuring FTP connections
  • Using Code and Design views
  • Laying out a web page using tables
  • Inserting forms and form elements
  • Introduction to Cascading Style Sheets (CSS)
  • Inserting graphics and photos
  • Building a menu system
  • Testing in different browsers
  • Uploading the website to the server

Adobe Photoshop Training Course: 1 Day Foundation

The Course Includes:

  • Overview of the software menus and tool pallets
  • Opening and editing photos
  • Importing and editing vector artwork
  • Creating unique graphic work
  • Producing graphics for use in Internet web pages
  • Preparing photos for the Internet
  • Producing graphics and photos for print
  • Understanding image file types and exporting work

Search Engine Optimisation Training Course:
1 Day Foundation

The Course Includes:

    • Introduction to search engine optimisation
    • Understanding how Google finds web pages
    • On-Page & Off-Page optimisation principles
    • Choosing the right key words to target
    • Writing keyword optimised content
    • Using heading tags to get the search engine’s attention
    • Understanding the C – Shape content principle
    • Making your web pages ‘search engine friendly’
    • Making better use of internal page links
    • Getting Google to ‘crawl’ your website
    • Understanding the Google PageRank system
    • Building links to increase your PageRank
    • Using Google Analytics to track your website