Category Archives: Free IT Training Resources

Microsoft Visio basics

This video explains Microsoft Visio basics. The tutorial explains how to add shapes from the stencil to your diagram and how to use the following tools: The connector tool, the text tool, the text block tool, the connection point tool and the pointer tool. The video also explains how to format shapes and group shapes. You will learn how to use tabs and paragraph format options.

Online courses at http://www.itseasytraining.co.uk

Overview

I find one of the most frustrating issues with Microsoft Visio is the connector tool and the pointer tool. Basically what happens when you use any of the tools in the tools block on the ribbon, they do not automatically reset to the pointer tool. The consequences of this are multiple text boxes and or orphan connector lines.

This video explains how to use the connector tools as mentioned above but it also demonstrates connecting different types of shapes and shows what happens when you have no connection points. Visio basics is a must if you want to understand how Microsoft Visio works. It will help you as you get in to the other diagrams and start to develop your skills. You will understand why certain shapes behave in a certain way.

I find that a lot of people add additional text boxes instead of using the shape text features. This can cause confusion if someone else wants to edit the diagram. Keep it simple and use the tools available. Try this, instead of adding additional text boxes use the text block tool to move the text box off the shape, as shown in the video. The course run by IT’s Easy Training is a one day classroom based course either at our Gateshead site or on your site with our laptops.

The course overview can be seen at http://www.itseasy.co.uk/courses/visio-training/

Resource Pool

This tutorial explains how to create a resource pool and how to resolve resource over allocations with resource levelling and setting overtime.

Online courses at http://www.itseasytraining.co.uk

Adding resources

This video explains how to create a resource list in Microsoft Project using the resource sheet and how to add resources to tasks using the assign resource feature. The tutorial also explains how to edit resource information by changing the Cost table settings, the Working time settings and how to embed documentation such as Word or Excel files.

Project links

Start to start, finish to finish, start to finish, finish to start

This MS Project tutorial explains how to link tasks in Microsoft Project and the four task types. The video explain how to add lead time and lag time and how to split tasks. Towards the end of the tutorial task constraints and deadlines are covered. Training at www.itseasy.co.uk Online courses at www.itseasytraining.co.uk

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

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 part of the tutorial focuses on Pivot tables, timeline, charts and slicers, including calculations. The final part is the use of the SumIF function and charts to produce a dynamic chart.

On-line courses are at www.itseasytraining.co.uk check them out.

SumIF charts

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

Hyperlinks in PowerPoint

This tutorial explains how to create an Index slide that links to all the other slides via the hyperlinks feature in a presentation. The video also explains how to link to an external file such as Excel or Word. The tutorial covers creating hotspot areas in the slide master that allows presenters to quickly move around a presentation without the audience being aware of the movement triggers. Training at www.itseasy.co.uk

Index Function with Match

This tutorial explains how to use the Match function to see if a number appears in a list or not. The video explains how to use the ISNA function and the IF function to display New number or Same rather than just N/A . The second part of the video demonstrates how to use the match function with the Index function to provide dynamic intersection from a data list. Match and Index work together to provide a dynamic lookup. Vlookup refers to the first column in a data set. Match and Index can refer to any column not just the first Training at www.itseasy.co.uk