Select Page

## Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Like many of my blog posts this came from a request from an attendee at one of my classes. She wanted to get a better understanding of how to clean up unwanted spaces in Excel – that’s the Trim() function. She also wanted to learn how to combine multiple...

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