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]
This video clearly explains how to use two very simple Excel features to produce a very powerful technique.  Using the autofilter and status bar is a trick not to be missed and although this video demos the feature in Excel 2003 it works even better in Excel 2007 as the status bar allows you to have multiple statistics visible at the same time. You can download the file used in this video by clicking on this link This is an original Improve Your Excel video and we hope you have enjoyed it.  You can download all 47 of the original video series [More]
In this video we look at creating a DO LOOP in Excel VBA.  The DO LOOP arrangement allows the section of code between the DO command and the LOOP command to be repeated until a specified condition is true.  As the majority of VBA code you write will repeat a process for several lines of data getting to grips with this command will help you write clearer code. The example in this video is easy to follow and easy to replicate for yourself – so once you have watched the video have a go at getting it to work for [More]
This video contains everything you need to know to have confidence with Excel Dates.  if  you sometimes find dates turn into long numbers or you have never tried to find the the difference between two sets of dates then this video is for you. The video initially talks about how Excel handles Dates internally and why it stores them as numbers.  It then goes on to tell you how to write equations to find the difference between two dates. On the way it also introduces you the ### problem in Excel and the shortcut key for entering today’s date into [More]
This video introduces you to how to write code to work with sheets in VBA and shows you a few tricks with renaming, selecting and hiding sheets. Make sure you stay on the video until about 3.30 mins in as the video introduces you to the veryhidden property of a sheet.  I use this property a lot as it stops people unhiding them in the Excel interface. The video finishes by showing you how to select sheets with VBA. I hope you enjoy this video on Working with sheets in VBA – if you have found it useful or have any questions [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 is a smart video that shows you a great hidden features in Excel but in the process also introduces some great shortcut keys and processes. When I reviewed this video I had to pause it a one place as I had a “is that true?” moment and needed to open one of my spreadsheet to check it worked with my data – it did! It is a very short video and I will be using Ctrl A almost everyday from today onwards as I am always looking at large chunks of data in Excel! As always – please let [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]
This video is a brief tutorial on how to use the vlookup() function in Microsoft Excel. It uses Excel 2007 in this video but everything he talks about will work with Excel 2003 and Excel 2007 and 2010. The tutorial is designed for beginners and works at a nice slow pace.
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.