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


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

Online courses can be found at

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


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

PST files in Microsoft Outlook


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


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.


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 on,line training courses are at

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 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

This is an example of the first session on the Microsoft Word course.

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

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

Check out course details at

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


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

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

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

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