Computer Tutoring Logo
Est. 2002
Menu Button

Excel Training Videos

Excel Online Training

From Pivot Tables to VLookup. These online trainig videos will give you a taste of what you can accomplish with the powerful tools in the Excel arsenal.

Ask us if you would like a video answering a problem you have: info@computertutoring.co.uk

Create a Pivot Table in Excel

You've heard about Pivot Tables from your friends and work colleagues. However you're not too sure as to what they are and how to use them. This online IT training video will show you how to create a pivot table.

Using Absolute References

You may have seen the dollar "$" symbols in Excel. Have you wondered what they mean and how using them can make your job easier. Find out how with our absolute references training video.


Using Conditional Formatting in Excel

You want a cell or a group of cells to change colour depending on a certain value. This particular exercise will show you how to use a formula to change the entire row to a specified colour. Then it will be easier for you to see.

Copying down a formula in Excel

You want to copy down a formula in Excel so that the formula applies to the cells beneath. This will save you repeatitively typing out the formula. This online IT training video will take you through the steps of accomplishing this.

Using VLookup in Excel Online Training

You have two list that you are constantly comparing. Wouldn't it be great if those lists were together. Or you need a result displayed in a cell based on another cells value. This online it training course will give an example of how to use the VLookup function.


Tables in Excel Online Training

From Excel 2007 a Tables feature was introduced. You may already be familiar with filters however Tables allow you to do more. From automatic format to a quick summary of data.

How to Calculate Between Worksheets

Having information on different Excel worksheets is great for organising data. However when it comes to consolidate the information there can be problems. This free Excel training video will show you how.

Operator Preference Training

Cast your mind back to your school days. This plus this multiplied by that and the answer comes out totally wrong. Or is it me? This online Excel IT training course goes through the mystery which is operator preference.


Excel IF Function

The Excel IF function will allow Excel to make basic decisions for you. For example should you want give you sales persons a bonus when they reach their target. Their bonus will be based on the actual sales they have made. In this instance the Excel IF function can return a calculation if the result is true.

Installing PowerPivot

How can PowerPivot help you manage millions of records? How can you create relationships between tables in Excel? First you have to installing PowerPivot. This online training sessions shows you how.

Greying out /Preventing cell access

This one was asked by a client who wanted to restrict the input of users based on what they have previously entered. For example if they entered Car in one cell then another cell is greyed out meaning you can't enter data.


How to do percentages on Excel

Are you trying to work out how much as value is as a percentage? This may seem complicated but this online training video will show you step by step on how to do percentages on Excel.

Copy and paste macro

Somebody else has created the code for you and you now have the task of copying and pasting the code into a new Excel file. To be honest though you're a little frightened. Well this video will help you out.

Countif 2 Criteria

Maybe you've use the countif function to count how many cells meet a given criteria. However what do you do should you want to count how many cells meet 2 different criteria. Then why not look at the countifs.


Pivot Table Slicer

Using slicer's in Pivot Tables are new since 2010. However should you want your slicer selection to appear on the sheet this is how you do it.

Building Data models with PowerPivot

Where do you start building a data model in PowerPivot? This training video will show you how to connect to a Microsoft Access database using PowerPivot in Excel 2013.

Creating Relationships in PowerPivot

When you import data, PowerPivot does it's best to pick up any relationships you have already within your data structure. But sometimes you just have to forge them yourself. This PowerPivot training video will show you how to create a basic relationship between two tables.


PowerPivot calculate function

Creating relationships in PowerPivot is one thing. Ensuring that the data is accurate is another. By understanding the Calculate function you can, among other things, view data from tables that aren't directly related to each other.

Sum by Month

A client wanted to know how you can use the AutoSum function to sum a range of figures to the previous month. This is the solution we discovered.

How to use Index Function

You may have heard of the Index Match function. But what about the Index function itself. This video explains the Index function.


Convert dot to comma format

How do you convert the european number format (e.g. EURO 3.567,00) to the UK format (e.g. £ 3,567.00)? This short training video will show you how.

Excel Index Match

Using the Match function in conjunction with the Index function makes a pretty powerful combination. This video will give you a basic example of how to use it.

Monthly Loan Payments

Use this handy function that will allow you to beat the sales people at their own game when they offer you a loan payment schedule that seems a little suspect.