microsoft excel

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

Here is an idea I had and it proved to be a successful one. I gave my Grade 10’s an Excel activity to do in class. This time, I decided to try something different. I […]

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

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

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

I have been using Merge and Center for as long as I’ve known Microsoft Excel (many years!). Most of the time, it is the perfect solution to merging and centering data. Sometimes, however, it does […]

Each month I will create a new super-duper Excel activity that you can give to your students to practice with. I will cover the Functions needed as per CAPS requirements. There is a Questions worksheet […]

Each month I will create a new super-duper Excel activity that you can give to your students to practice with. I will cover the Functions needed as per CAPS requirements. There is a Questions worksheet […]