
Mail merge with authentic data
Here is a mail merge activity I made using a recordset of 10 000 people. It includes using MS Word, label template, MS Access and MS Excel. I have included a basic marksheet as well. […]
Here is a mail merge activity I made using a recordset of 10 000 people. It includes using MS Word, label template, MS Access and MS Excel. I have included a basic marksheet as well. […]
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! […]
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 […]
I was just thinking if something like this would work. Just a thought, an idea on how I could reinforce the teaching and practice of functions with the Grade 10’s. If enough people think this could […]
Hiding cells and unhiding cells to view particular sorts of data for calculations can be a real pain. But with grouping and toggling between open and closed states, it becomes super easy to close or […]
This is part 2 of 2 of macros in Excel. Here we actually create the macros and assign them to buttons. A macro is nothing more than a recorded set of keystrokes or instructions that […]
© Matthew Hains