Keyboard shortcuts in Excel – Referencing and Selections (4 of 8)
Here is another list of shortcuts you can use in Excel. Once again I stress that it is only a shortcut if you learn it and not just print off the...
Tips – Quick Access Folder in File Manager in Office 365
Hands up who doesn’t like the new way in which the MS Office Quick Access folder - which used to be called Favourites works now. Changing the name to Quick Access...
Tips – How to create a pick list in Excel
When I went to a local "Pick your Own" recently it came to me that pick lists are important to all, and can make life more simple. Inputting new data in...
Tip – Setting up Time Zones in Outlook
Microsoft Outlook is great tool in the business office. There are many parts to it, one of which is the calendar to hold appointments and invite people to meetings. I use...
Using the Keyboard to access tabs in Windows.
Do you get frustrated by a naughty mouse? Does your mouse die on you? How do you continue to work without a mouse or touchpad on a laptop?
To some, this is...
How to create a signature in Outlook
Outlook has been with us a very long time. Some of the people that I train have been using it for many years. Despite this, I still find people who do...
Tips – Creating and editing the custom dictionary in Word
We all, I am sure, end up mistyping words especially when we are in a hurry. There are many more reasons for not typing correctly but I won’t go into that. We...
Using a list of choices to input data in Excel.
It can be so frustrating when you look over a database of information to find that how data was input can limit your ability to report on the data. This is...
Using the SUMIFS function in Excel
There are lots of wonderful features in Excel now to make reporting on data easy and fun. But sometimes all you really need is a simple function. There are hundreds of...
Borders for your Word Documents
Do you need a border to enhance the look of your document and make it more inviting and professional? You don’t need an expensive design software. You can do this in...