by admin | Sep 9, 2014 | Excel Functions | Useful, Excel | Case Studies
Got presented with an interesting dilemma recently. If you (or your children or any children you know) compete in anything there is usually an age cut off point. For example my son competes in music competitions and the cut off date for each year is 1st January i.e....
by admin | Sep 26, 2013 | Excel Functions | Useful, Excel | General
I recently got asked an interesting question via my YouTube channel from someone who wanted to set up a rota using Excel. However he wanted the rota to be coloured according to start time and end time so he could easily see how many people were on duty. So I decided...
by admin | Aug 27, 2012 | Excel Functions | Useful, Excel | Useful tricks
I was recently asked about generating random numbers in Excel – for example if you have a list of numbered questionnaires and you need to randomly check 20 of them, how can you use Excel to the generate random number required. Today I’m not going to use...
by admin | Jun 26, 2012 | Excel Functions | Useful, Excel | General, Excel | Intermediate Lessons
If you need to quickly copy formatting from one cell to another, the Format Painter tool in Excel is a gift. You can use it to copy formatting once or multiple times. This video shows you how. For example, if you have formatted a spreadsheet on Monday but can’t...
by admin | Jun 7, 2012 | Excel Functions | Useful, Excel | Intermediate Lessons
In this Vlookup tutorial we are going to look at how to use the Vlookup function. Essentially what this does is allow you to match up information from two lists and pull in matching information. An example would be if we have a list of part numbers and we want to pull...
by admin | May 14, 2012 | Excel Functions | Useful
The SumifS function is a new function that was brought in in Excel 2007. Essentially, it is an upgrade for the SumIf function in the sense that it allows you to sum numbers based on more than one criteria. I plan to do another post on this to show you how to use...
