Microsoft Visio Basics | Getting started

Microsoft Visio Basics

Read More


10 Most Used Excel Functions

These are the 10 most used Excel functions. This video covers the following Excel functions: Sum, SumIF, Count, CountA, CountIF, IF, AND, Vlookup, Index and Match. 10 Most Used Excel Functions These are the 10 most used Excel functions: Use the Sum function to add up lists. The average function can be used to work

Read More


Mail Merge

Merge to a letter These videos explain how to create a mail merge document in Microsoft Word. There are three videos in total, a basic example of a mail merge using letters, envelopes and labels. This video is followed by an advanced mail merge example. In the second video you will learn how to use

Read More


Access Form controls

How to use the form controls in Microsoft Access

Read More


Microsoft Excel Maps

Excel Maps and 3D Maps

Read More


Access courses

Access courses for update queries

Read More


Relational database in Microsoft Access

How to create a relational database

Read More


Access Reports

How to create reports in Microsoft Access

Read More


Microsoft Training Courses

Overview The Microsoft Office , Project and Visio buttons displayed below link to the course outlines for classroom based courses. If you wish an online course go to http://www.itseasytraining.co.uk You can assess your knowledge levels by completing the Excel document here Check Skill Level Once you have completed the document email to info@itseasy.co.uk You can book

Read More


Microsoft Access database table design

How to create a Microsoft Access database part 2

Read More


Access database

Access database

Read More


Street Map in Visio

Visio street map

Read More


Lookup Images in Microsoft Excel

How to lookup images in Microsoft Excel

Read More


Database Functions in Microsoft Excel

Database function in Microsoft Excel

Read More


Visio brainstorming diagram

Visio protection and charts

Read More


Visio linked data

This video explains how to create a flowchart using the Visio linked data wizard, pulling the data from Microsoft Excel into a Visio flowchart diagram. The video also explains how to import data from Microsoft Project in to a Visio timeline diagram. The tutorial covers how to edit data graphics in Microsoft Visio and how

Read More


Visio Reports

Visio reports

Read More


How to create a Floor Plan using Microsoft Visio

Visio floor plan

Read More


Visio Gantt charts

How to use Microsoft Visio Gantt charts

Read More


Synchronised shapes in Microsoft Visio

How to create an organisational chart and use synchronise copies

Read More


Cross Functional flowcharts in Microsoft Visio

How to create a cross functional flow chart

Read More


How to use PowerPivot in Microsoft Excel

How to use PowerPivot in Microsoft Excel

Read More


Microsoft Visio basics

How to use Microsoft Visio basic shapes and format them

Read More


PST files in Microsoft Outlook

How to create a PST files and use quick steps in Microsoft Outlook

Read More


Microsoft Word Basics

How to case and use the hidden text feature in Microsoft Word

Read More


Microsoft Project Tips and Tricks

Microsoft Project Tips and Tricks

Read More


Custom Fields in Microsoft Project

How to use customs fields and functions in Microsoft Project

Read More


How to set a Baseline in Microsoft Project

How to save a baseline, update tasks and create reports in Microsoft Project

Read More


Network Diagram in Microsoft Project

How to use other views in Project

Read More


Hot tips and time savers in Microsoft Excel

Hot tips, save money save time

Read More


Microsoft Project Resource Pool

How to use the resource pool and resource leveling

Read More


Adding resources to Microsoft Project

Adding resources in Microsoft Project

Read More


Microsoft Project linking tasks

Microsoft Project link types

Read More


MS Project Gantt charts

This tutorial explains how to create a task list in MS Project and format the Gantt chart, timeline and calendar. The video also explains how to add project fields to the print output and embed documents into tasks. Training at www.itseasy.co.uk Online courses at www.itseasytraining.co.uk

Read More


Microsoft Excel Intermediate course

This tutorial overview explains what is covered on the Intermediate Excel course at www.itseasy.co.uk or www.itseasytraining.co.uk (online courses). The video demonstrates the use of Names and Named ranges in Excel, how to use Conditional formatting in Excel. How CountIf and Subtotals can be used. The video also explains the IF function and Vlookup. A large

Read More


SumIF charts in Microsoft Excel

This tutorial explains how to create a chart on two axis and how to create a Dial chart and a Waterfall chart and a column chart that has the SumIF function and the date function driving the data. Training at www.itseasy.co.uk online courses at itseasytraining.teachable.com

Read More


Visio Timeline

his tutorial explains how to create a timeline in Visio and how to add milestone and interval markers. The video explains how to move milestone around and how import data from a Microsoft Project file and finally how to send a Visio timeline in to MS Project Training at www.itseasy.co.uk

Read More


IF Statements

Three conditional statement used in Excel

Read More


Data Analysis in Microsoft Excel

Data analysis tools

Read More


Hyperlinks in PowerPoint

Automate PowerPoint

Read More


Index Function with Match

better than vlookup

Read More


Named cells and ranges in Excel

Watch a Tutorial to explain Named cells, Ranges in Excel 2019 This tutorial explains how to create named cells and named ranges in Microsoft Excel 2019. The video covers how to create names and common mistake people make when doing so. The tutorial explains how to refer to names in formulae and how named ranges

Read More


Microsoft Project from start to finish

How to use Microsoft Project

Read More


Visio Flowcharts

Flowchart in Visio This video explains how to create a simple flowchart in Microsoft Visio. The tutorial explains how to add shapes and how to connect shapes. The video also shows how to use the connector tool to add additional connecting lines. How to add text to a connector line. How to use the off

Read More


Are scripted courses coming to an end?

I have often wondered why so much effort is put into the aims and objectives of a training sessions, or what you will learn statements.  In my experience it is very difficult to decide what someone else will learn in a set period of time.  Some people will achieve everything listed in the objectives and

Read More


How to create Pivot table calculations in Microsoft Excel

How to use pivot table calculations    

Read More


Pivot table grouping dates

How to group dates in Microsoft Excel Pivot tables  

Read More


Pivot table charts

How to add pivot table charts

Read More


Pivot tables grouping

How to use the pivot tables grouping feature in Microsoft Excel

Read More


How to use a Pivot table in Microsoft Excel

How to create a simple Pivot table in Microsoft Excel 2014

Read More


How to change working time in Microsoft Project

How to change working time in Microsoft Project 2013

Read More


Basic IF function in Microsoft Excel

Basic IF.  This video explains how to create a basic IF function in Microsoft Excel.  The video tutorial uses named ranges to explain how best to design and create an IF statement.

Read More


Nested IF

Nested IF statement

Read More


Excel Training IF and And Function

How to use an IF and And Function in Microsoft Excel Training courses with IT’s Easy Training

Read More


Microsoft Project Training

How to link tasks in Microsoft Project.  Microsoft Project Training provided in groups or on a one to one basis.  Consultancy also available on request.

Read More


Grouping Sheets in Excel

This video explains how to group sheets together in Microsoft Excel, which enables users to quickly add data formatting to multiple sheets.

Read More


How to use the Data Tables Feature

This video shows you how to use the Data Tables feature.  You will learn more detailed uses on the Intermediate Excel course.

Read More


Using the Scenario manager in Microsoft Excel

This video shows how to use the Scenario manager. There are many other uses besides the one shown, email for course details

Read More


How to use the Grouping feature in Excel

How to use the Group and Outline feature in Excel

Read More


Linking texts boxes in Microsoft Publisher

How to link text boxes in Microsoft Publisher. The following video shows how to use the link text box tool to create a flow through several linked boxes. The same procedure can be used in Microsoft Word.

Read More


How to use Time calculations in Excel

This video shows an example of using the Date Time format with calculations to display hours difference when it is either less than 24hrs or greater than 24hrs.    

Read More


How to use Vlookup in Microsoft Excel

This video show how to use the Vlookup Function

Read More


Testimonials


“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA




“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group




“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services