Excel provides many formulas for finding a particular string or text in a list or array.  In this video, you will learn how to use the MATCH function. Excel defines MATCH function as “Returns the relative position of an item in an array that matches a specified value in a specified order”. In simple plain language Match function searches for a value in a defined range and then returns its position. You will definitely love this video as it not only shows how to compare 2 lists but also demonstrate 2 ways how to handle errors when the comparison finds [More]
Pivot tables are one of the most powerful and most underused features in Excel. The interface has been reworked in Excel 2007/2010 and this video show how to create a Pivot table in Excel 2010. What you will see in this video is that pivot tables are quick and easy to do and use no Excel equations at all. I added this video on the because it is only 5 minutes long and it shows two really cool features of pivot tables – the first is that it groups date data by day month year automatically and the second is [More]
This video shows you how to use the COUNTIF function in Excel. This functions is very useful when trying to work out how many values fall into a particular category. The example uses a list or people’s names and then adds an equation to find out how many people have paid their bill and how many people are still to pay. COUNTIF is very useful if you are looking to make a spreadsheet that works for every user that uses it, however if you are look for simple counting functions then you need to check our pivot tables as these [More]
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.