## Awesome Excel tip #6

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 work with functions and formulas. This shortcut is so super-easy and quick, it makes naming a range of cells a … Read moreAwesome Excel tip #6

## Awesome Excel tip #5

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 data already exists in the area we are moving the selected data to. This cool method shows how you can … Read moreAwesome Excel tip #5

## Macros in Excel – Workshop by Matt Hains

A new addition to CAPS is the use of macros, specifically in Excel. I will be presenting a 1-hour workshop to familiarise teachers with this new addition and get them equipped to use macros and teach them to their learners. Workshop details When :  Saturday, 9th February 2019 Where : Saheti School, Civin Drive, Senderwood, … Read moreMacros in Excel – Workshop by Matt Hains

## An idea in teaching Excel functions for Grade 10

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 work, I could get a few people working together with me online and we could maybe make a cool functions … Read moreAn idea in teaching Excel functions for Grade 10

## Awesome Excel tip #4

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 open rows and columns at the click of a button!

## Simple macros in Excel Part 2 of 2

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 the application will play when we want it to. We can attach macros to buttons, shapes, images or keyboard shortcuts.

## Simple macros in Excel Part 1 of 2

This is part one of 2 of macros in Excel. In this part we basically set the platform using RANDBETWEEN and conditional formatting . Nothing fancy here but it’s a nice exercise, similar to the colouring-in with Excel activity I made a while ago. I’d like you to create the file yourself while going through … Read moreSimple macros in Excel Part 1 of 2

## Colour by numbers, using Excel

Here is an activity I designed for working with a few elements in Excel. Skills covered: Conditional formatting cell addresses ranges copy/paste drag and fill data validation fun! I made a block of 100 squares. All squares have conditional formatting applied so that when a certain number is typed in, the square (cell) changes colour. … Read moreColour by numbers, using Excel

## Awesome Excel tip #3

Data validation in Excel is very powerful and very useful for helping users work with data in cells or ranges of cells. Instead of putting a comment on a cell (which pops up even if you are not working on that cell), consider using a message feature instead! When on the cell you want the … Read moreAwesome Excel tip #3

## Excel : Merge Across Quick shortcut

Made in response to a question by a teacher in our Facebook group to see if there was a keyboard shortcut for the ‘Merge across‘ feature or if a macro would need to be recorded. I found a shortcut involving accessibility keys, it’s close enough…I think!