As requested, my invigilation timetable that I created in MS Excel. It is difficult to make one that would suit every school as every school is very different. This one works for my school. You […]
I used to use a macro I found online to duplicate a worksheet based on a list of names. It is very easy to do, using a macro, but I found an even easier way! […]
A great way to run a quick assessment or evaluation is to have your learners take a quiz that marks itself. You receive the marks immediately, can supply feedback and then release the marks for […]
You can work even faster in Excel by making use of these keyboard shortcuts! There are some shortcuts here I didn’t even know about and I am going to be using them so much more […]
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 […]
For those who could not attend the Macros in Excel workshop that I presented, you are in luck – I recorded the whole thing! The video and notes from the workshop are available to purchase […]
Here is an activity I made using a few of the skills our CAT learners need to know. It’s a secret message decoder! Basically, numbers correspond to letters based in two sets. The task is […]
We often use absolute cell references or named ranges. I find it easier to teach my students to name their cells or use named ranges instead as it makes it much easier to understand and […]
Moving data in Excel can happen in various ways. Sometimes we copy/cut and paste. Sometimes we move entire columns. Other times we just need to move a range of cells. The problem comes in when […]
The workshop below has come and gone, but don’t despair! See this post—> A new addition to CAPS is the use of macros, specifically in Excel. I will be presenting a 1-hour workshop to familiarise […]
© Matthew Hains