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: firstname.lastname@example.org
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
You may have heard of the Index Match function. But what about the Index function itself. This video explains the Index function.
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.
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.
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.