How to create a form for data entry in Excel

How to create a form for Data Entry in Excel 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...

Day to Day Shortcuts for Excel

Day to Day Shortcuts for Excel Day to Day Shortcuts for Excel . 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...

Quickly Transpose Tables

Quickly Transpose Tables Quickly Transpose 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....

How to create your own formula in Excel

How to create your own formula in Excel The range of formula within Excel is great. Most of the day to day functionality that you need is there but if you find that you need to do a different calculation that is not built in then you can create what is called a User...