 |
01670 732139 |
 |
steve@itseasy.co.uk |
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
