Cross Functional flowchart and data graphics

This video explains how to create a cross functional flowchart and data graphics in Microsoft Visio. The tutorial demonstrates how to add basic shapes from the stencil and connect the shapes manually to avoid swim lanes being dragged all over the place. The video covers how to use shape graphics and how to edit shape graphics. The shape graphic is triggered by data in the shape data box. The final section of the video explains how to define shape data.

Overview

This video explains how to use a Cross Functional flowchart in Microsoft Visio. The tutorial demonstrates how best to add shapes from the Visio stencil without over sizing the swim lanes.

Data Graphics

The video explains how to use data graphics to gave a visual indication within the flowchart shapes. There are several options that may be used, icon sets and text for example.

The process is quite simple, select a shape data field or add a new one, then create the shape graphic based on the shape.

Swim Lanes

The swim lanes on the default cross functional flowchart can grow to accommodate shapes if they cross over swim lanes. The shapes that are added manually do not seems to effect the swim lanes in the same way, if connectors are added after the shape is added and not with the automated shape builder. I find it best to position all the shapes across the swim lanes and then go back to add the connectors. It may be a bit longer but i have found that it is quicker in the long run.

Online courses are available at http://www.itseasytraining.co.uk classroom based courses are available at http://www.itseasy.co.uk/courses/visio-training/ Classroom based courses can be delivered onsite with our laptops or at our Gateshead site at Metropolitan House,  Longrigg,  Road,  Swalwell,  Gateshead,  NE16 3AS

How to use PowerPivot in Microsoft Excel

PowerPivot in Microsoft Excel

How to use PowerPivot in Microsoft Excel. This tutorial explains how to create a relationship between two Excel tables, which have been formatted as tables, using the PowerPivot tab. The video explains how to use the Manage options in PowerPivot and how to link the tables using the diagram view.

Check out online courses at http://www.itseasytraining.co.uk

Overview

This section explains how to add relationships between tables using PowerPivot in Microsoft Excel.

Two tables that will be linked
Two table to start with

In the above example there are two small tables of data which I am going to join using the PowerPivot window. When I add the two tables to the data model, they will formatted to Tables. You can rename the tables on the sheet tabs, or use named ranges.

Saving a table to the data model
Save each table to the data model

First step is to add each table to the data model.

check the my table has header option
Check the my table has header option

Make sure that you check the My Table has Headers option.  The following screen is displayed, cancel this screen to add the other table.

Manage table

When you add the second table, you will see a second tab appearing in the PowerPivot window.  You can name the tabs if required.

You may notice that you can import data from this window as shown before. We are now going to create a Pivot table based on these two tables. Select the Pivot table button and select where you want the Pivot Table to sit. You can also select the Pivot table option from the Manage window. The Manage windows allows you to select quite a few different Pivot table and chart options.

pivot table range

You will notice that both tables added to the data model now appear in the Pivot field window.

Pivot table window through the PowerPivot tab

I am going to link these two tables via the department field.  I can do this through the normal Pivot table tools tabs, but I find it a lot easier to use the PowerPivot window and the Diagram view option, because it is more visual

Relationship window

Drag the department field from one table to the department field in other table, when you release the connection is made. Once the relationship is created you can use field from both tables as shown below:

final linked relational table

I have department and surname set to row from one table and manager set to column from the other table.  Salary is the summary field.

Excel courses can be found at http://www.itseasy.co.uk/courses/excel-training/

Online courses can be found at http://www.itseasytraining.co.uk

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/

PST files in Microsoft Outlook

Overview

The tutorial explains how to create PST files in Microsoft Outlook and how to add folders to the PST file to help manage Inbox storage issues. This video also explains how to use the Quick steps feature to move emails into folders automatically in Microsoft Outlook. Online courses at http://www.itseasytraining.co.uk

Security

Some companies restrict the use of PST files in Microsoft Outlook because of security issues. It should not be a problem if the PST files are stored on a secure network drive and not on the C drive. The benefits far out weigh the costs in my view. You have the ability to manage your email content and section it off into folders and even other PST files if required. I use about four or five PST files in my own Outlook, I have nothing in my Inbox at all. I do not tend to use folders attached to my inbox anymore, I just use PST files and the Quick step tool to move emails into them.

Archive

You can add archive settings to each PST file in the same way as you can any folder or mailbox in Outlook. You can also add a password to PST files to stop others adding them to their Outlook without permission and gaining access to your emails.

Contact us

Course details for Outlook training are at http://www.itseasy.co.uk/courses/outlook-training/ on,line training courses are at http://www.itseasytraining.co.uk

Email us for course dates and venues. We have ten laptop, so the training can be delivered anywhere in the UK . Our main training venue is in Gateshead just behind the Ikea building about 100 metres from the A1. We provide free parking and lunch if required.

The Microsoft Outlook course is a one day course which covers all the main elements in Outlook, such as calendar appointments, email sending receiving and managing, tasks, shared tasks, folder options and formatting views. Full details are shown on the via the above link.

email steve@itseasy.co.uk or phone 020 8798 3474 or 01670 732139

Microsoft Word Basics

This video explains how to change font in Word, how to increase font in Word and how to use the hidden text feature. The tutorial also explains how to use the show hide feature and strike through
Online courses at http://www.itseasytraining.co.uk

This is an example of the first session on the Microsoft Word course. http://www.itseasy.co.uk/courses/word-training/

Microsoft Project Tips and Tricks

Microsoft Project tips and tricks, this video explains how to use the Paste Special feature in Microsoft Project to link data in to an Excel file. The tutorial also explains how to create a master project files using the Sub Project button and the Paste Special option. An explanation of how to link tasks between projects is also given. Online courses at http://www.itseasytraining.co.uk

Using the paste special feature enable users to send Microsoft Project files to Excel users and update them live so people without the Microsoft Project software can still be involved. Check out other videos on YouTube https://www.youtube.com/user/ITsEasyTraining1st

Check out course details at http://www.itseasy.co.uk/courses/project-training/

Custom Fields

This video explains how to create custom fields in Microsoft Project. The tutorial covers creating lookup fields, IIF functions and DateDiff functions. The video also explains how to use the graphical indicators and save a modified Gantt chart view table as a new table.

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

Baselines

This video explains how to save a baseline, how to run reports and design your own custom reports in Microsoft Project. The tutorial shows how to insert columns change the default tracking table and update tasks using the tracking table. The video demonstrates how to view different baselines and select other baseline views. Online courses at http://www.itseasytraining.co.uk

Network Diagram

This tutorial explains how to use the Network view, the task usage view, resources usage view, how to create a work contour and how to create you own view in Microsoft Project. The video also explains the Team Planner and the Timeline views. Online courses at www.itseasytraining.co.uk

Hot tips and time savers

This tutorial explains how to save time in Excel and therefore save money. The video covers some of the more common key commands and features such as flash fill, inserting columns, selecting data sets, time commands, saving shortcuts and instant charts.


Online courses at www.itseasytraining.co.uk