Matthew's Blog
50 keyboard shortcuts for Excel
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 […]
excel tips
Matthew's Blog
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 […]
Matthew's Blog
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 […]
Matthew's Blog
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 […]
Matthew's Blog
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 […]
Matthew's Blog
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 […]
Matthew's Blog
Awesome Excel tip #1
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 […]