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]
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.
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]
This video introduces you to the OFFSET command in Excel.  99% of people have not heard of the OFFSET command and the other 1% are often left wondering what you can do with such an odd function. Smart tables and graphs are the OFFSET command best uses and this video shows an excellent use of the command linked to a scroll bar on the spreadsheet.  We have tagged this video as advanced as there are some concepts in here that may confuse beginners but I would recommend you go ahead and watch just to get an idea of what Excel [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.