Here is a great exercise to reinforce CONCATENATE, UPPER, RIGHT, LEFT, LOWER functions. Get your students to create their own password generator based on various factors. In the image below you can see how the […]

Excel Function of the Month – LEN

The Excel Function of the month is LEN

Excel Function of the Month – TIME

The Excel Function of the month is TIME

Excel Function of the Month – AND

The Excel Function of the month is AND

Well, it’s that time of year…EXAMS! I’m sure your students want to know what they need to know for the various applications. In addition to the CAPS skillset layout I created earlier this year, I […]

Create a password generator in Excel

Here is a great exercise to reinforce CONCATENATE, UPPER, RIGHT, LEFT, LOWER functions. Get your students to create their own password generator based on various factors. In the image below you can see how the […]

Excel Function of the Month – SUMIF

The Excel Function of the month is SUMIF

Excel Function of the Month – ROUND

The Excel Function of the month is ROUND

Using the Excel RANK function

I devised a worksheet to automatically calculate the points of our school ‘houses’ as part of a quiz competition we were having. Getting the results to tally was easy. Figuring out 1st, 2nd and 3rd […]

Excel Function of the Month – RANDBETWEEN

The Excel Function of the month is RANDBETWEEN