Adding accented characters into your Excel workbook is commonly achieved by using the Insert –> Symbol menu options to select the character you want, however while this is fine for inserting the odd symbol every now and again, if you have to enter lots of different symbols then things can become very tedious indeed. Fortunately Microsoft have provided a […]
Microsoft Excel provides a very handy function called the ‘Info’ function which allows Workbook designers to give users various system information without a lot delving around in VBA etc. For this demonstration we will use the Info function to enter the directory path of the current workbook into a cell. Firstly you will need to […]
Because the standard Gregorian calendar used by the majority of the world doesn’t lend itself to date calculations (differing length months, and leap years to name but two examples), Microsoft have devised a special system for dates within Excel which makes it easy to incorporate calculations based on dates into your spreadsheets and Excel based […]
In Microsoft Office, the Excel undo list has a limit of sixteen entries, which for some power users can be too few but with a single registry hack, it can be changed to any number you like. The main body of this article explains how to alter the registry which if done incorrectly can cause […]
Here is a selection of some of the most often used keyboard shortcuts, along with a few you may have never used before, or even know existed! If you have any others that you would like to add, then please E-mail your tip to us, and we will include it with a credit to your […]
Like most programs, Microsoft Excel has certain terms and phrases that are specific to it. We have attempted to list as many of the terms you are likely to come across below. If you come across a word or phrase that you either don’t understand, or that you think should be in this glossary, please […]
Sometimes it can be useful to know which user is logged on to your application, maybe in order to check that they have the correct permission to use the application etc, or maybe unlock certain features that are only available to certain users. We have outlined some code below to help you achieve this, the […]
To use this tutorial you will need to have worked through Part 1 – click here to go to Part 1. Now that we have created our Form and Query, we now need to start a chain of events that will lead to the retrieval of data based on the Query. It is unusual, (and bad practice) […]