Conditional Formatting and Dropdown Menus

How to create a menu of options that when selected will change the colour of the cell. For example, selecting Cancelled from a list should change the cell background colour to red to indicate clearly to the user that the project or course etc. has not been given the...

Day to Day Shortcuts for Excel

Excel Tips and Tricks I have compiled a list of shortcuts that I use regularly on a day to day basis. These handy shortcuts should have you navigating and formatting your worksheets in no time at all. They require a bit of practice, but it’s definitely worth it....

Quickly Transpose Tables

Changing the Layout of Excel Tables Have you ever found yourself creating a table in excel and then realising later that its structure should have been layout differently. In other words, have the column headings appear as row headings or visa versa. Well, the...