IT Training


Kirkpatrick Consult Limited IT Training Image

What We Do

At KCL our trainers are qualified teachers, lecturers and Microsoft Certified Professionals.  This unusual combination of depth of IT knowledge and education skills allows us to not only deliver a standard set of courses (as listed below) but also enables us to create bespoke courses dependant on client demands.  Should you require something unique (maybe due to customised in-house software) we are more than happy to come to your offices, learn about the product and then go away to create an engaging course ready to be delivered to your staff, as and when you need it.

If this is something of interest, contact us to find out more.

Word 2013We offer loads of different courses in Microsoft Word!! 

Look at the table below to see which levels are available for each version of Word:

Course
2003
2007
2010
2013
Introductory
Basic
Intermediate
Advanced

As each version is slightly different to the next, the content of each course changes slightly, but take a look at the suggested course content below for each level, to get an idea of which level is right for you.

 

After completing the introductory course you will be able to:

  • Find popular commands quickly on the ribbon.
  • See how the File menu has evolved to the Microsoft Office Backstage view.
  • Do essential tasks, such formatting, saving, and printing.
  • Work between Word 2010 and earlier versions of Word.

 

After completing the basic course you will be able to:

  • Use the Word Navigation Pane to search and move around in a document
  • Create visually compelling documents in Word 2010
  • Get control of page numbers, headers, and footers
  • Create accessible documents in Word 2010
  • Know Word 2010 keyboard shortcuts
  • Know some Word 2010 tips and tricks
  • Add a table of contents in Word 2010

 

After completing the intermediate course you will be able to:

  • Manage Your Documents
    • Using Windows Explorer within Word
    • Saving Your Files
    • Finishing Your Files
    • Making Word Work Backwards
    • Viewing Your Files
  • Use Formatting Tools
    • Working with Templates
    • Using Bullets and Numbering
    • Using the Paragraph Dialog
    • Using Delineation Tools
    • Working with Pages
    • Adding Hyperlinks
  • Create Headers and Footers
    • Creating Basic Headers and Footers
    • Using the Header & Footer Tools – Design Tab
    • Inserting Page Numbers
    • Doing More with Headers and Footers
  • Work with Pictures
    • Inserting Pictures
    • Editing Pictures
    • Doing More with Pictures
    • Formatting Pictures
    • Managing Pictures
  • Work with Shapes
    • Drawing Shapes
    • Working with Shapes
    • Working with Text and Shapes
    • Advanced Shape Tasks
  • Perform a Mail Merge
    • Using the Mail Merge Wizard
    • Performing a Manual Mail Merge
    • Sending a Document Electronically

 

After completing the advanced course you will be able to:

  • Managing and Reviewing Documents
    • Using Comments
    • Tracking Changes
    • Combining Multiple Versions of Documents
    • Creating an Outline
  • Working with Reference Tools
    • Creating a Table of Contents
    • Creating References within a Document
    • Creating a Bibliography
    • Creating Index and Reference Tables
    • Creating References to Other Documents
  • Using Time Saving Tools
    • Using Language Tools
    • Inserting Pre-Defined Text
    • Using the Navigation Pane
  • Working with Advanced Graphics and Objects
    • Inserting Text Boxes
    • Inserting WordArt
    • Creating SmartArt
    • Editing SmartArt
    • Using Building Blocks and Quick Parts
  • Creating Tables
    • Inserting Tables
    • Editing Tables
    • Formatting Tables
    • Working with Table Data
  • Creating Equations and Charts
    • Working with Equations
    • Creating Charts
    • Formatting Charts
    • Analysing Chart Data

 

Excel 2013We offer loads of different courses in Microsoft Excel!! 

Look at the table below to see which levels are available for each version of Excel:

Course
2003
2007
2010
2013
Introductory
Basic
Intermediate
Advanced

As each version is slightly different to the next, the content of each course changes slightly, but take a look at the suggested course content below for each level, to get an idea of which level is right for you.

 

Introductory course contents:

Getting Started with Excel 2010

• Starting Out  • About Workbooks  • Exploring your Workbook  • Getting Help with Excel

The Excel Interface

• The Quick Access Toolbar and File Menu  • The Home Tab  • The Insert Tab  • The Page Layout Tab  • The Formulas Tab  • The Data Tab  • The Review Tab

Excel Basics

• Working with Excel  • Basic Excel Features  • Moving your Data  • Smart Tags and Options Buttons  • Editing Tools

Editing your Workbook

• Modifying Cells and Data  • Cell Formatting  • Enhancing a Worksheet’s Appearance

Printing and Viewing your Workbook

• Using the View Tab  • Managing a Single Window  • Managing Multiple Windows  • Printing your Workbook

Working with Charts

• Creating Charts  • Selecting Chart Data  • Working with Chart Options

 

Basic course contents:

Advanced File Tasks

• Using Windows Explorer within Excel  • Saving your Files  • Using File Management Tools, Part One  • Using File Management Tools, Part Two

Working with Functions and Formulas

• Using Formulas in Excel  • Exploring Excel Functions  • Using Functions in Excel  • Working with Names and Ranges  • Working with Array Formulas

Managing Tables

• Working with Tables  • Working with Records and Fields  • Working with Tables and Filters  • Using Excel as a Database

Adding the Finishing Touches

• Research Tools  • Using Themes  • Adding Text Boxes  • Inserting Pictures and ClipArt  • Editing Pictures

Showing Data as a Graphic

• Inserting SmartArt  • Formatting SmartArt  • Adding Symbols, Equations, and Shapes  • Sparklines  • Editing Sparklines

 

Intermediate course contents:

Grouping & Outlining and Subtotals

• Outlining and Grouping Data  • Using the Subtotals Tool

What-If Analysis

• Exploring Scenarios  • Goal Seek and Data Tables  • Using Solver

PivotTables

• Getting Started with PivotTables  • Displaying Data in a PivotTable  • Formatting a PivotTable  • Using the Classic PivotTable Layout  • Slicers

Charting Pivoted Data

• Getting Started with PivotCharts  • Using the PivotChart Tools Tabs  • Formatting a PivotChart

Advanced Excel Tasks

• Excel and Hyperlinks  • Using Custom AutoFill Lists  • Sharing Workbooks

Creating Lookup Functions

• Using the VLOOKUP Function  • Using the LOOKUP Function

Introduction to Macros

• Recording and Playing Macros  • Copying and Deleting Macros  • Visual Basic and Macros

 

Advanced course contents:

Advanced Conditional Formatting

• Editing Standard Formatting Rules  • Using Formulas in Conditional Formatting

Using Form Controls and Templates

• Using Form Controls  • Creating Templates

Advanced Lookup Functions

• Using the Index Function  • Using the Match Function  • Using Index and Match Together  • Using Index and Match with Array Formula  • Using the Indirect Function

Advanced Functions

• Using Error Functions  • Using Logical Functions  • Using Array Formulas  • Using Rounding Functions

Advanced Pivot Table Tools

• Importing Pivot Table Data  • Calculated Fields in Pivot Tables  • Showing Pivot Data as a Percentage  • Creating Custom Pivot Tables Styles

Introduction to User Defined Functions Using VBA

• Creating a User Defined Function  • Creating an Interactive Procedure  • Create and Share a Function Add-in

 

Access 2013We offer loads of different courses in Microsoft Access!! 

Look at the table below to see which levels are available for each version of Access:

Course
2003
2007
2010
2013
Introductory
Basic
Intermediate
Advanced

As each version is slightly different to the next, the content of each course changes slightly, but take a look at the suggested course content below for each level, to get an idea of which level is right for you.

 

Introductory course contents:

Getting Started with Access

• Starting Out  • Interface Basics  • Database Security  • Getting Help

The New Ribbon Interface

• The Quick Access Toolbar  • Basics of Tabs  • The Home Tab  • The Create Tab  • The External Data Tab  • The Database Tools Tab

Creating a Simple Database

• First Steps in Database Creation  • Database Records  • Creating a Table  • Formatting Text

Forms; Queries; Reports and Filters

• Creating and Using Forms  • Creating and Using Queries  • Creating and Using Reports  • Sorting and Filtering Data  • Viewing Data  • Printing a Database Object

 

Basic course contents:

Advanced File Tasks

• Using Windows Explorer within Access  • Database Management  • Saving Your Files  • Exporting Files  • Linking Files

Working with Tables

• Customising Tables  • Table Properties: Formatting  • More Table Properties  • Data Validation and Lookup Wizard

Working with Forms

• Basic Form Controls  • Advanced Form Controls  • Formatting Your Form  • Formatting Controls  • Using Themes

Working with Reports

• Organizing Report Data  • Formatting Reports  • Common Report Tasks

Working with Queries

• Basic Queries  • Doing More with Queries  • Creating Advanced Queries  • Creating Management (Action) Queries

Intermediate course contents:

Advanced Data Management

• Referential Integrity  • Table Relationships  • An Introduction to SQL  • Modal Dialog Boxes

Advanced Form Tasks

• Using Subforms  • Creating a Navigation Form  • Advanced Form Controls  • Exporting a Form  • Other Form Tasks

Pivoting Data

• Creating a PivotTable  • Using PivotTables  • Advanced PivotTable Tasks  • Creating a PivotChart  • More on PivotCharts

 

Advanced course contents:

SQL and Microsoft Access

• Understanding SQL • Using the SELECT Statement • Using Subqueries • Using SQL Joins

Macros and Visual Basic for Applications (VBA)

• Macro Basics • More about Macros • Access and VBA • Building Advanced Procedures • Using VBA in a Database

PowerPoint 2013We offer loads of different courses in Microsoft PowerPoint!! 

Look at the table below to see which levels are available for each version of PowerPoint:

Course
2003
2007
2010
2013
Introductory
Basic
Intermediate
Advanced

As each version is slightly different to the next, the content of each course changes slightly, but take a look at the suggested course content below for each level, to get an idea of which level is right for you.

 

Introductory course contents:

Getting Started with Powerpoint

• Meeting Microsoft Office PowerPoint 2010  • Creating a Presentation  • Working with Your Presentation  • Editing Your Presentation  • Arranging Slides  • Getting Help in PowerPoint

Understanding & Customising the PowerPoint Interface

• Getting Acquainted  • The Quick Access Toolbar  • Tabs and Groups  • Customising the Ribbon

Creating and Formatting Presentations

• Using Templates  • Working with Text Boxes  • Basic Editing Tools  • Formatting Text: Effects; Fonts and Spacing  • Formatting Text: Alignment; Indenting and Lists  • Advanced Text Tools

 

Basic course contents:

Adding Shapes and Art to Your Presentation

• Drawing Shapes • Working with Shapes • Working with Text and Shapes • Advanced Shape Tasks

Viewing and Printing Your Presentation

• Using Layouts and Views • Viewing a Slide Show • Preparing Your Presentation • Printing Your Presentation

Adding the Finishing Touches

• Research Tools • Using Themes and Backgrounds • Creating Slide Transitions • Creating Basic Animations • Creating Advanced Animations

 

Intermediate course contents:

Managing PowerPoint Files

• Using Windows Explorer within PowerPoint  • File Management Tools  • Using Presentation Tools: Optimisation and Compression  • Using Presentation Tools: Inspection and Checking

Working with Pictures

• Inserting Pictures  • Editing Pictures  • Manipulating Pictures  • Formatting Pictures  • Managing Pictures

Adding Multimedia to a Presentation

• Inserting Video Files  • Editing Video Files  • Inserting Audio Files  • Editing Audio Files

Adding Tables Charts and Diagrams

• Inserting Tables  • Editing Tables  • Formatting Tables  • Inserting Charts  • Inserting SmartArt  • Formatting SmartArt

 

Advanced course contents:

Setting up Slide Masters

• Creating a Slide Master • Using Placeholders • Using Slide Masters • Using Hand-out Masters • Using Notes Masters

Reviewing Presentations

• Using Comments • Reviewing a Presentation

Creating Advanced Types of Shows

• Setting up Your Show • Presenting Your Show • Creating a Custom Show • Advanced Presentation Techniques

 

Outlook 2013We offer loads of different courses in Microsoft Outlook!! 

Look at the table below to see which levels are available for each version of Outlook:

Course
2003
2007
2010
2013
Introductory
Basic
Intermediate
Advanced

As each version is slightly different to the next, the content of each course changes slightly, but take a look at the suggested course content below for each level, to get an idea of which level is right for you.

 

Introductory course contents:

Getting Started with Outlook

• Explore the Outlook Interface  • Send a Simple Message  • Read Messages  • Reply to and Forward a Message  • Print a Message  • Delete a Message

Composing Messages

• Address a Message  • Format a Message  • Check Spelling and Grammar  • Attach a File

 

Basic course contents:

Organizing Messages

• Open and Save an Attachment • Flag a Message • Organize Content with Folders

Managing Contacts

• Add a Contact • Find the Geographical Location of a Contact • Manage Contacts

Scheduling Appointments

• Explore the Outlook Calendar • Schedule an Appointment • Assign Categories and Edit Appointments

Scheduling Meetings

• Schedule a Meeting • Reply to a Meeting Request • Propose a New Meeting Time • Manage Meetings • Print the Calendar

Managing Tasks and Notes

• Create a Task • Edit and Update a Task • Create a Note • Edit a Note • Display a Note on the Desktop

Intermediate course contents:

Setting Calendar Options

• Set Work Days and Times  • Display an Additional Time Zone  • Set Availability Options

Customizing Message Options

• Modify Message Settings  • Modify Delivery Options  • Change the Message Format  • Notify Others that You Will Be Out of the Office  • Create a Distribution List  • Insert a Hyperlink

Tracking Work Activities Using the Journal

• Automatically Record a Journal Entry  • Manually Record a Journal Entry  • Modify a Journal Entry

Managing Tasks

• Assign a Task  • Reply to a Task Request  • Send a Task Update  • Track Assigned Tasks

Sharing Folder Information

• Specify Folder Permissions  • Delegate Access to Folders  • Access Another User’s Folder  • Send Calendar Information in an Email Message

Customizing the Outlook Environment

• Customize the Toolbar  • Create a New Toolbar  • Customize the Menu Bar  • Customize the Quick Access Toolbar  • Customize the To-Do Bar  • Create a Folder Home Page

Locating Outlook Items

• Sort Messages Using Multiple Criteria  • Find Messages  • Find Outlook Items Using Multiple Criteria  • Filter Messages  • Organize Messages  • Manage Junk Email

Working with Public Folders

• Create a Public Folder  • Add Users to a Public Folder  • Post Information in a Public Folder  • Send an Email Message to a Public Folder

 

Advanced course contents:

Personalizing Your Email

• Apply Stationery and Themes  • Create a Custom Theme  • Create Signatures  • Modify Signatures  • Configure Email Message Security Settings

Organizing Outlook Items

• Group Items  • Create Search Folders  • Apply Conditional Formatting

Managing Outlook Data Files

• Create a Data File  • Add Outlook Data Files to a Mail Profile  • Change Data File Settings

Working with Contacts

• Forward Contacts  • Edit an Electronic Business Card  • Export Contacts  • Perform a Mail Merge  • Link Items to Business Contact Manager

Saving and Archiving Email

• Save Messages in Alternate Formats  • Archive Messages  • Protect Personal Folders

Creating a Custom Form

• Add Form Fields  • Save a Form as a Template  • Test a Form

Working Offline and Remotely

• Make Folders Available Offline  • Configure RPC Over HTTP  • Download Selected Messages  • Publish Calendar Information to Office Online

 

 

SharePoint 2013We offer loads of different courses in Microsoft SharePoint!! 

Look at the table below to see which levels are available for each version of SharePoint:

Course
2003
2007
2010
2013
Introductory
Basic
Intermediate
Advanced

As each version is slightly different to the next, the content of each course changes slightly, but take a look at the suggested course content below for each level, to get an idea of which level is right for you.

-Introductory Course Contents:

  • SharePoint 2010 Introduction
    1. SharePoint Versions
    2. Team Site Layout and Navigation
  • SharePoint List Basics
    1. List Templates
    2. Creating Lists
    3. List Columns
    4. Column Validation
    5. Calendars
  • Library Basics
    1. Library Templates
    2. Creating Libraries
    3. Managing Documents and Versioning

-Basic Course Contents:

  • Working with Lists and Library Views
    1. Default Views
    2. Custom Views
  • Working with Sites
    1. Site Templates
    2. Creating Sites
    3. Site Navigation
  • Page Content
    1. Wiki Library Pages
    2. Web Part Pages
    3. Working with Web Parts
  • Forms Library
    1. Creating a Forms Library
    2. Creating InfoPath Forms
    3. Publishing InfoPath Forms to SharePoint
  • Site Columns and Content Types
    1. Site Column Gallery
    2. Creating Site Columns
    3. Site Content Type Gallery
    4. Creating Content Types
  • Office Integration
    1. Excel Integration
    2. Outlook Integration
    3. Access Integration
    4. SharePoint Workspace
  • Managing SharePoint Site Permissions
    1. SharePoint Groups
    2. Assigning Permissions
    3. Permission Levels
    4. Permissions Inheritance
  • Participating in User Communities
    1. Configure User Profiles and My Sites
    2. Managing Colleagues and Team Members
    3. Managing My Content
    4. Using Tags and Notes

-Intermediate Course Contents:

  • Content Approval
    1. Enabling Content Approval
    2. Content Approval Workflows
  • Creating Custom Workflows with SharePoint Designer 2010
    1. Workflow Basics
    2. Custom List Workflows
    3. Workflow Actions
    4. Workflow Conditions
    5. Workflow Initiation Form
    6. Reusable Workflows
  • Working with Managed Metadata
    1. Creating a Term Store Group and Term Set
    2. Creating Metadata Columns in Lists and Libraries
    3. Publishing Content Types
  • Business Connectivity Services
    1. Business Connectivity Services Basics
    2. Creating an External Content Type with SharePoint Designer
    3. Creating a List from an External Content Type
  • Information Management Policy
    1. Information Management Policy Basics
    2. Define and Information Policy for a Content Type
    3. Defining Information Policy for a List

-Advanced Course Contents:

  • Content Organizer
    1. Activating the Content Organizer Feature
    2. Configuring Content Organizer Settings
    3. Configuring Content Organizer Rules
  • Document ID Service
    1. Activating the Document ID Feature
    2. Configuring Document ID Settings
    3. Linking Documents Using Their Document ID
  • Document Sets
    1. Activating the Document Sets Feature
    2. Creating a Document Set Content Type
    3. Adding a Document Set Content Type of a Library
  • SharePoint Server Publishing Infrastructure
    1. Activating the SharePoint Server Publishing Infrastructure
    2. Publishing Infrastructure Basics
    3. Creating Pages with Page Layouts
  • Configuring and Consuming Site Search Results
    1. Search SharePoint for Content
    2. SharePoint Search Center
    3. Search Scopes

 

OneNote 2013We offer a selection of different courses in Microsoft OneNote!! 

Look at the table below to see which levels are available for each version of OneNote:

Course
2003
2007
2010
2013
Introductory
Basic
Intermediate
Advanced

As each version is slightly different to the next, the content of each course changes slightly, but take a look at the suggested course content below and if there is something missing that you would like to know about, we can always add it to the course schedule.

As OneNote (often said to be Microsofts hidden gem) is not widely known or massively complicated, we have found that our 1 day introductory course is all that is required, hence why there is only 1 course type here.

 

Introductory course contents:

What is OneNote?

  • Launching OneNote and touring the interface
  • Opening, closing, and saving notebooks
  • Creating new notebooks
  • Creating, moving, and deleting sections and pages
  • Working with sub-pages
  • Creating a note on a page

Adding Content to Notes

  • Working with unfiled notes
  • Adding screen clippings and pictures
  • Adding audio and video files
  • Recording audio and video
  • Adding files

Formatting Notes

  • Using styles from the quick gallery
  • Using bullets and numbering

Viewing and Organizing Information

  • Organizing the user interface
  • Searching a notebook
  • Creating links to pages with wiki linking
  • Tagging notes
  • Working with sections
  • Using section groups

Interacting with Outlook

  • Inserting Outlook meetings
  • Sending page information by email
  • Working with Outlook tasks

Using Writing Tools

  • Working in Pen mode
  • Manipulating written notes and drawings
  • Converting handwriting to type

Using Stationery and Templates

  • Using templates
  • Saving as a template
  • Choosing a default template

Formatting Pages

  • Setting paper size and margins
  • Changing page background options
  • Adding a background graphic

Sharing Notebooks

  • Saving to other formats
  • Saving OneNote content to PDF or XPS
  • Creating a shared notebook
  • Inviting others and syncing notebooks

Collaborating on Notebooks

  • Knowing who wrote what with author indicators
  • Locating newly added content with highlighting
  • Seeing past versions quickly with versioning

Researching with OneNote

  • Automatically linking your notes to what you’re viewing
  • Using the Research pane
  • Translating text with the Mini Translator

 

 

Some Recent Work