Creating a form for data entry

Have you ever created a Workbook in Excel as part of a business process and defined how you wanted people to enter the data just to find that they disregard your method and just put the information anywhere. This can be frustrating but will involve you being the one...

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...