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 […]
The Excel Function of the month is LEN
The Excel Function of the month is TIME
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 […]
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 […]
The Excel Function of the month is SUMIF
The Excel Function of the month is ROUND
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 […]
The Excel Function of the month is RANDBETWEEN
© Matthew Hains