Create a Pivot Table in Excel
You've heard about Pivot Tables from your friends and work colleagues. However, you're not too sure what they are and how to use them. This online IT training video will show you how to create a Pivot Table.
You've heard about Pivot Tables from your friends and work colleagues. However, you're not too sure 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 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.
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.
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.
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.
Beginners tutorial on creating a summary sheet in Excel. Make good use of the SUMIF function and the UNIQUE function in Excel to make a simple sheet of summary data in Microsoft Excel.
Tutorial showing how to use SUMIF in Excel across multiple sheets. Step by step instructions along with a breakdown of how, exactly, the funciton works. Test yourself out with a quiz to see how much of this Excel tutorial your remembered.
In this tutorial you will see how to use Power Query to clean up messy Excel Data for quick analysis. Then see how to use that cleaned data to make interactive dashboards.
This short tutorial will show you how to remove blank rows from an Excel spreadsheet. Hopefully this will sort out the issue of blank rows in your spreadsheet life.
See how to append multiple files in a folder into one files in Excel. Use Power Query to combine or append files so that you never have to copy and paste data into the spreadsheet again. That's right! This tutorial will show you how to accomplish this automatically.
Do you need an accountant? Questions that you may ask as a small business user. Interview with Ian Shipley from Prentis & Co.
Dynamically highlighting rows as you type is fantastic for visualisations. Use this step-by-step tutorial to see how to create a textbox that dynamically (automatically) highlights rows as you type. It also includes wildcards.
Unlock the secrets of leap years with our easy-to-follow tutorial! 🌟 Learn how to craft a perfect Excel formula to determine if a specific date falls within a leap year. 📅 But that's not all! You'll also master the art of counting the number of leap years between any two dates. 🚀 Don’t miss this chance to become a leap year pro. Dive in now!
Explore the secrets of Excel with our engaging Power Query tutorial!🧮 Perfect for beginners, this video simplifies data cleaning, teaching you to remove blank rows effortlessly. 💻 Discover Power Query's magic and transform your datasets into pristine, analysis-ready forms. Click now to master precise data management and analysis with Power Query.
Understand how to handle merged cells in Excel using Power Query. First you will see a common reason as to why people merge cells. Then you will see the consequences. Finally, you will use Power Query to tackle the problem of merged cells.
Transpose, Unpivot or pivot. What would you use and in which situation. This tutorial shows how to use Power Query and the transpose, pivot and unpivot tools to get data ready for a pivot table. Step by step instructions along with a free tutorial video should get you up and running.
Explore more about Excel with our free training videos. If you have any suggestions for videos you'd like to see, please email us at info@computertutoring.co.uk. We're always looking to improve and provide the content that you need!
We use cookies (the digital kind!) and similar tech to personalise your experience, keep the website running smoothly, and analyse its performance. Fancy the details? Check out the Cookie Policy to learn more. Click manage cookies to manage the details.
I know this is a pain, but in order to view the videos you first need to check the "Enable Access to Training Resources" consent box to view the videos. Click Accept All to acknowledge this change.
On the other hand maybe you simply want to browse our courses.
Come on! At least let us not forget yourr choice not to use cookies.