Excel Power Query is free and can be installed for Excel 2013 or Excel 2010. It is the golden nugget of hidden Excel features, so hidden in fact that many people have never even seen it. This video is created by Mynda Treacy, Microsoft Excel MVP, who in my opinion is the Queen of Excel Dashboards. In it she shows just two of the uses of this very powerful tool and shows you the complete power of reusing power query functions. Power Queries are like VBA but easy to create and just a powerful when working with datasets. Mynda is [More]
Excel provides many ways to count cells in a range that meet various criteria. This short video shows 7 ways to count in excel. It uses the functions COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. You can see at 00:50 of this video how to use the COUNT function. This function simply count cells in a range that contain number. Also, in 4:51 of the video, the count function was used in a filtered list/range. COUNTA counts all non-empty cells while COUNTBLANK counts the number of empty cells. COUNTIF was used in this video to count cells that contain a specific [More]
Suppose you want to adjust a project’s schedule date by adding two weeks to see what the new completion date will be, or you want to determine how long a single activity will take to complete in a list of project tasks. And you might be thinking now how you can do this as simple as possible…. …. and sometimes Excel Date’s seem a but of a mystery …. The DATE function is the solution. There are a lot of cool functions for dealing with dates in Excel. But this video shows you how to add Years, Months or Days [More]
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]
I think the IF statement in Excel is a perfect example of how a little knowledge in Excel can go a long way to making your life so much easier. And this helpful video will show you how to do it. By using the “IF” function of Excel, you can create an output based on the conditional statement you specified.  The IF function processes a logical test and delivers a specified value based on whether that test is true or false. To see how the function is inserted in the spreadsheet, you may jump to 1:01 of this video.  The video [More]
I use the TEXT function in Excel a lot to add numbers and dates into paragraph text. It is a little know technique and I often see people using cells instead and that quickly turns into a formatting nightmare. This video clearly shows how to use the TEXT Excel function and how to use it to embed data into paragraph text. Enjoy and try this out for yourself.
A nested IF statement is an IF statement that sits inside of another IF statement and this video shows you how to created a nested IF statement. I have to be honest here – in this video you will learn how to use the insert Function dialogue to insert nested functions and I did not know you could do.  In fact over the 5 years I have been teaching Excel to my classes I have told them this is not possible!  Opps I had better change that! It just goes to show you that no matter how long you have been using [More]
This is one of Mike Smart’s great Excel videos from his Expert Excel course and it teaches how to use the Excel IF statement in a very clear way. Mike’s course came out top in our recent reviews of Excel video courses and you can get three more free videos from him on our review page You can download the file used in this video from here
This video is one of Clayton Lock’s original videos and you can download the file used in this video. This video covers vital learning for anyone who wants to get started with creating VBA functions in Excel.    It starts by showing you how to create a simply Excel VBA function to display “hello world” on the screen and then goes on to show you how to do something far more useful with a function and return values to the cell that had the equation. This is longer than most videos on the site but I recommend you watch it all [More]
Left, Mid and Find are functions you need to master if you are going to extract text from cells in Excel.  This is especially useful for things like extracting first names, or address details. In this example you will see how to extract the text before a coma using the Excel FIND and the Excel LEFT statement.  Then it goes on to show you how to use the Excel MID statement.  Watch out for a #Value error using these functions if the text cannot be found – you may need to use an an ISerror() wrapper for the expression.  However [More]
In this video you will learn how to use the AND and OR functions in Excel.  These are usually combined within and IF statement but I like this video because he keeps them as stand alone functions and that this gives you the clearest view of how the AND and OR functions work in Excel. If you have found this useful please leave a comment below or click one of the social buttons on the right hand side.
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]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.