You are probably familiar with the Index Match function. What about Index Match with multiple criteria. In this free Excel training course you will see how to use the Index Match function as an array function allowing you to check data columns for multiple criteria.
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.
Here's the answer to the Transpose Function question I had in the previous video. In fact this tutorial has all you need to solve the Not Applicable and the zero error that's often displayed when you use this function.
Get the basics of formatting an Excel spreadhseet.
Tutorial showing how to use data validation to prevent duplicate entries.
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 free 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 free excel 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 have been around since 2010. But I bet even if you've heard of Pivot Tables you're not making the best use of Slicers. This free Excel video with give you some idea of the power of slicers.
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 Excel training 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 free online Excel training 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.
Just what on earth can you do with the Index Match function? If you have viewed the Index Match video and you want another example of how you might use it then look no further. This video will show you how to use Index Match to find out which product you have sold the most of.
The OR formula, especially when nested inside an IF function, can be a powerful ally to anyone who needs to clear data for some reason or another. See how you can give a bonus to sales teams based on their performance.
You have two lists that you need to compare and retrieve information. But, you don't have a unique identifier for each row. This free online Excel tutorial will show you how to use Index Match with multiple criteria to display that information.
The MID function in Excel really needs to be used in conjunction with the FIND and the SUBSTITUTE function to get any value from it. Find out how in this comprehensive video.
Find unique values in a formula in Excel 2010, then use those values to create a Pivot Table. In this video you employ the SUM, IF, FREQUENCY and MATCH functions to calculate distinct values. The values can then be applied for usage within a Pivot Table. If you are using Excel 2013 or later you might want to check out the other Video doing it the easy way.
See how to sort data values within groups inside a Pivot table. Allows you to see what the best selling product is.
The SUMIF function is a great way to filter results of an autosum. Say for example you wanted to find out how much you spent on Cheese? The this is the function for you.
This Excel training video will show you not only how to use the COUNTIF function on a basic level. It takes advantage of the greater than symbol so that you can use this COUNTIF function in conjunction with dates.
Here you go! A little more straight-forward than using a formula but still a really effective way of changing a comma to a dot in Excel.
The NUMBERVALUE function in Excel can make it really easy for you to convert a dot to a comma, or a comma to a dot. I don't know why I didn't show you this earlier, however, this tutorial will show you how.
Tutorial showing you the value of using Data Tables for WhatIf Analysis in Excel 2016. You will also see how to bring in a VLOOKUP, Name Ranges a drop down list all wrapped up in a beautiful OFFSET function to create a dynamic drop-down list. You'll certainly pick up a few tips inside.
Here we go! 3 ways to transpose data in Excel. From the basic copy and paste to the OFFSET function. If you need to constantly change data from rows to columns then this is the free Excel online training video for you.
Custom Views is a great way to get you get your spreadsheet working for you. Flip between different filter and sheet views using this tutorial.
See how you can use Flash Fill to speed up data entry. Split up names, correct incorrectly formatting dates. Once you've used Flash Fill, you'll wonder how you did without it.
Do you have to purchases a complex accounts system for your plastering business? No you don't. All you need is a spreadsheet, 15 mins and this tutorial video.
Getting your accounts accurate is one thing, making them look pretty and easy to read is another. This free Excel tutorial will show you how to format your accounts spreadsheet in Excel.
See how to calculate VAT in Excel. Working out either the Net from the Gross or the Gross from the Net is much easier and quicker than you could imagine.
This Excel accounts tutorial will show you how to add multiple rates of VAT into the same spreadsheet. You will also see how to predetermine figures with dropdown lists and create a running total.
This tutorial video will show you how to work out how much money your business made last month? You'll also see how to work out what you spent on something along with how much money your business made in a quarter.
See how to quickly create a Pivot Table from your accounting spreadsheet. Learn how to make your Pivot Tables easy to update and change the numbers to currency. See how to control two Pivot Tables at the same time.
See how to create a financial year formula, a financial quarter forumla and a custom list to make a Pivot Table from your accounts order by the financial year. Even if your financial year begins the 6th April.
See how to use Calculated Fields with Pivot Tables. As a result you will be able to write formulas within Pivot Tables. Work out the profit made then write a formula for the percentage.
How do you use Conditional Formatting within a Pivot Table? Is it the same way as you would normally use conditional formatting in a spreadsheet? Well if you don't know the answer and you need to conditionally format data in a Pivot Table check out this training video.