### 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 […]

### 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 […]

### 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 […]

### 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 […]

### 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. […]

### 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 […]

### 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. […]

### CAT Training for Access & Excel

The Gauteng Department of Education presented teacher training in term 3, covering the most complicated concepts in Access & Excel. The training files and videos are available online. Please note there are also offline downloadable […]

### Excel : AND, IF, RANDBETWEEN and conditional formatting

Part of a file I am working on. Here is a great one to do with your students. Set up a range of fixed Lotto numbers. The student must randomly generate numbers. If the numbers […]

### Awesome Excel tip #2

A nice quick way of applying a function or formula to a whole range in one go, and not even having to drag any cells down or across! Step 1 : Select the range you […]