Select Page

## Calculating correct age for competitions with a cut off date

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....

## Conditional Formatting | Creating a rota that formats according to time

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...

## GENERATE RANDOM NUMBERS IN EXCEL | USING RAND BETWEEN FUNCTION

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...

## FORMAT PAINTER – EXCEL (OR HOW TO QUICKLY COPY FORMATTING FROM ONE CELL TO ANOTHER))

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...

## VLOOKUP IN EXCEL

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...

## SUMIFS FUNCTION| SUMIF MULTIPLE CRITERIA PART 1 – TEXT AND NUMBERS

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...