Professional In-house IT Training for Businesses

This course looks at some of the features in Word that are designed to help you work.

Who Is The Course Aimed At

People who have been using Word for a while and now want to take their skills to the next level.

Course Objectives/Key Benefits

• To understand Page Layout Features
• To use Bullets and indentations efficiently
• Using AutoCorrect to get results quicker
• Creating Tables to show information
• Using Headers and Footer within a document
• Using Styles to make documents work for efficiently

Course Content

• Margins
• Page Breaks
• Indentations
• Auto Correct
• Tables
• Sections
• Introduction to styles
• Headers and Footer

Training method:

Hands on training in a friendly and relaxed atmosphere

Course outcome/qualification:

Certificate of Attendance.

Pre-requisite Knowledge/Qualifications:

Ability to use a mouse and some experience of using Word.

This course looks at how to create hand-outs and other such materials using Publisher.

Who Is The Course Aimed At:

People who have little or no experience using Publisher.

Course Objectives/Key Benefits:

• Navigating around the screen
• Learning about personal information
• Learning basic skill needed when using Publisher
• To use Tables
• To use Designs
• Learning about Layouts
• To use Graphics

Course Content:

• Screen Layout
• Navigation
• Inserting basic information
• Layouts
• Moving, resizing and using Text boxes
• Alignment
• Spelling
• Cut, Copy and Paste
• Format Painter
• Creating Tables
• Using Designs
• Working with Drawing Objects
• Using ClipArt
• Using Pictures

Training method:

Hands on training in a friendly and relaxed atmosphere

Course outcome/qualification:

Certificate of Attendance.

Pre-requisite Knowledge/Qualifications:

Some experience of other Microsoft products.

This course will allow you to create a PowerPoint Presentation with some of the enhanced Features.

Who Is The Course Aimed At

Anyone who has little experience with PowerPoint but would like to be able to put together a presentation.

Course Objectives/Key Benefits

• To be able to create and manipulate slides
• To use ClipArt and pictures on slides
• To see the best ways of using tables on slides
• To create slides with charts
• To add movement to the slideshow
• To organise and print the slideshow
• To use the Master Slide to effect all slides at once
• To create templates to use in the future

Course Content

PowerPoint Introduction Course Content

• Creating Slides
• Adding Pictures to Slides
• Adding Tables to Slides
• Creating Charts
• Using basic Transitions
• Using basic Animation
• Using Slide Sorter View
• Using Slide Show View
• Using Master View
• Saving Templates

Training method:

Hands on training in a friendly and relaxed atmosphere.

Course outcome/qualification:

Certificate of Attendance.

Pre-requisite Knowledge/Qualifications.

Ability to use a mouse and some experience of using Microsoft Products.

The Advanced PowerPoint Level 3 aims to provide delegates with skills in integrating text and graphics, producing complex presentations with the use of advanced layout and structural presentation tools.

Who Is The Course Aimed At?

Delegates with a good all-round knowledge of PowerPoint who are interested in extending their expertise in creating professional presentations using a variety of advanced tools.

Course Content

Advanced Level 3 PowerPoint workshop includes:

Working with Text
Formatting
Bullets

Working with Pictures
Inserting and editing pictures
Manipulating, formatting and managing pictures

Tables Charts and Diagrams
Inserting, editing and formatting tables
Inserting charts and formatting SmartArt

PowerPoint Files
Using Windows Explorer within PowerPoint
File management tools
Using presentation tools: Optimisation and compression
Using presentation tools: Inspection and checking

Multimedia in a Presentation
Inserting and editing video and audio files

Slide Masters and Templates
Creating and using slide master
Using placeholders
Using hand-out masters
Using notes masters
Colour schemes
Creating templates

Advanced Shows
Setting up & presenting your show
Creating a custom show
Advanced presentation techniques

Training method:

Hands on training in a friendly and relaxed atmosphere

Course outcome/qualification:

Certificate of Attendance.

Entry Requirements

Delegates should have a sound knowledge of PowerPoint, with mouse use, having created presentations in the past.

This course looks at some of the features in Outlook which allow you to work more efficiently.

Who Is The Course Aimed At

Anyone that uses Outlook

Course Objectives/Key Benefits

• To use further features when sending an email
• To be able to organise your inbox in the most efficient way
• To use the electronic calendar to organise your life
• To see the advantages of using Contacts
• To use Tasks

Outlook Course Content

• Sending and Receiving emails
• Organising your Inbox
• Using the calendar
• Contacts
• Task
• Setting Options

Training method:

Hands on training in a friendly and relaxed atmosphere

Course outcome/qualification:

Certificate of Attendance.

Pre-requisite Knowledge/Qualifications

Ability to use a mouse and some experience of using Oulook.

The Google + course provides coaching for any member of staff in the business involved in marketing.  As business is now moving towards a heavy digital (or online) approach, it is imperative your business moves this way too. Marketing has changed massively in the last 10 years and your business needs to adopt these simple techniques to effectively harness online marketing.  In this course we cover the power of social media and how it can have a positive impact on brand awareness, quality traffic to your website and lead generation.

Who Is The Course Aimed At

Anyone who needs to learn how to use Google+ for business.

Course Objectives/Key Benefits

Delegates will learn how they can use social medium Google + effectively to support the business online marketing endeavors, create and enhance brand awareness, broaden business profile and increase awareness and leads into an organisation.

Google +  Course Content

On completion, delegates will have a greater understanding of:

• The reason to embrace social media
• How to set up a profile
• How to create a business listing
• How to use Google+
• How to learn and grow by using Google+

Training method:

The session draws on the presenter’s practical experience as an experienced marketer with organisations of all sizes/sectors. The use of the internet to demonstrate live examples along with the use of the whiteboard and discussions.

Delegates are encouraged to use their own experiences to keep the session relevant to their own needs.

Course outcome:

Certificate of Attendance

Pre-requisite Knowledge/Qualifications

None

The Advanced Microsoft Project Level 3 aims to equip delegates with the knowledge and skills necessary to apply the software to the successful management of a real business project.

Who Is The Course Aimed At

This practical hands-on course has been designed for professionals with some exposure to Microsoft Project.

Aim: To recap on the fundamentals of MS Project to ensure that all delegates have the same level of understanding of the software capabilities, prior to detailed project planning and reporting activity.

On completion of all three days delegates will be equipped with the knowledge and skills necessary to apply the Project software to their own work environment.

Note:  Delegates will have the option to apply a real business project to the training course. If this is not feasible, then a realistic project scenario will be provided by the course leader.

Course Content

Day 1

Session 1: Microsoft Project overview

All the fundamentals of the Microsoft Project software – to ensure all delegates have an equal starting point i.e. what it can (and cannot) deliver and introduces topics such as the user interface, installation, printing and file management.

Session 2: Planning and Costing theory

To recap on the basics of project planning techniques, including network analysis and critical path analysis (CPA). This is followed by a discussion of simple cost and budgeting methods.

Session 3: Planning with MS Project

Delegates will be tasked with a simple hands-on exercise using MS Project. This will cover Gantt charts; CPA, and the calculation of key dates and float.

Session 4: Cost/budgeting with Project

Once the above exercise is complete a set of human resources and equipment are added to the project tasks.  Together with some fixed costs a simple project budget is generated.

Day 2  

Session 1: Planning the Project

Tackles the detail of project planning with MS Project.  PERT diagramming will be covered together with Gantt charting. We will also cover Critical Path Analysis (CPA), the concept of float and the various options for manipulating logic. A single case study is used throughout.

Session 2: Resourcing the Project

This explores the resources required for a project (people, finance, materials, equipment and services) – and how these can be efficiently identified, quantified, sourced and managed.

Session 3: Costing the Project

Once the resources have been identified the next step is to attach costs (known or estimated), and in doing so, develop an overall project budget (which may be broken down into budgetary components for traceability).

Session 4: Reporting Options

Examines the various report options made available – including the full range of graphical and tabular report options.

Day 3 

Session 1: Optimising the project

Revisits the initial plans and budgets in order to test feasibility and assess any scope for improvement (typically cost reduction and/or shortened timescales) including what-if scenarios, resource-levelling options and risk assessments.

Session 2: Tracking the project

This session deals with the reality of the live project and the need to match actual performance to the plans, budgets and quality parameters.  It covers the options provided to measure and compare actual progress against the plan.

Session 3: Advanced reporting options

This covers the advanced reporting options provided by MS Project, including the export of data to other packages (e.g. Excel).

Session 4: Project Workshop

This final session gives delegates the opportunity to introduce real project-related issues from their own organisation for either group discussion or individual consultation with the course leader.

Entry Requirements

All delegates should have a sound working knowledge of the Microsoft Office environment, including Microsoft Project.

The Google Analytics course provides coaching for any member of staff in the business involved in marketing.  As business is now moving towards a heavy digital (or online) approach, it is imperative your business moves this way too. Marketing has changed massively in the last 10 years and your business needs to adopt these simple techniques to effectively harness online marketing.  In this course we cover the Google analytics tool, which gives all marketers information on the impact of their endeavours, in effect demonstrating the return on investment and providing valuable insight into marketing campaigns.

Who Is The Course Aimed At

Anyone who has a business website.

Course Objectives/Key Benefits

Delegates will learn how they can use Google analytics to effectively demonstrate the impact of their marketing campaigns and influence and shape future marketing activities.

Google Analytics and your Business Course Content

On completion, delegates will have a greater understanding of:

• The reason to embrace Google Analytics
• How to set up Google Analytics
• How to check for Google Analytics tracking code
• How to interpret the data
• How to set up Goal tracking
• Why and how to exclude IP addresses

Training method:

The session draws on the presenter’s practical experience as an experienced marketer with organisations of all sizes/sectors and the use of the whiteboard and discussion will be strong as will the use of the internet live to demonstrate real life examples.

Delegates are encouraged to use their own experiences to keep the session relevant to their real needs.

Course outcome:

Certificate of Attendance

Pre-requisite Knowledge/Qualifications

None

The Excel Intermediate course looks at some of the formulas and functions that can be used in Excel, including ones that allow you to link Spreadsheets

“Despite several of us thining we were quite proficient using excel; having a session for us which enabled us to update our knowledge on new features has shown us how we can make our lives so much easier when manipulating data within our business.  What we have implemented since we got back to the office is already saving us time and money!”  Sue Brown, Multitech Site Services

Who Is The Course Aimed At

People who have been using Excel for a while and now want to take their skills to the next level.

Course Objectives/Key Benefits

• Being able to use $ and brackets in formulas effectively
• Linking Worksheets and Workbooks
• Use the Watch Window to make using more than 1 sheet at a time easier
• Being able to use Names in Formula
• Protecting Worksheets
• Using dates within Formulas
• Being able to use all features of the Fill Handle

Excel Intermediate Course Content

• Using $ and brackets in Formulas
• Linking Worksheets and Workbooks
• Watch Window
• Names in Formula
• Protecting Worksheets and Books
• Dates
• Fill Handle

Training method:

Hands on training in a friendly and relaxed atmosphere

Course outcome/qualification:

Certificate of Attendance.

Pre-requisite Knowledge/Qualifications.

Ability to create basic formulas ie +, – etc and functions ie Sum, Average.