Tips – Fill Series in Excel Spreadsheets
In an earlier tip I explained how to use the Autofill feature in Excel. It is a wonderful time saving tool. Now I will explain the Fill Series feature where numbers and dates...
Tips – Using Outline View in PowerPoint
Many times I have been asked what the quickest way to create a simple presentation in PowerPoint is. People sometimes do not have the time to create complicated slide designs and...
Tips – PMT in Microsoft Excel 2016
Yes gentlemen! you too can have PMT. Especially if you are in finance and need to do calculations for loans and the such. This is a function found in the Financial...
Tips – How to create repeated headings in Excel when printing
This is a topic that comes up practically in every training session. There are so many of you who do not know that you can even do this. And yes I...
Tips – Directing where you want to save your Presentation Templates
Following on from my last tip on how to create a template in PowerPoint here I am going to discuss where to place it on your network.
Microsoft products come with a...
How to create a template and then use it regularly.
When I sit in a presentation, I take note of how it is presented and what it looks like. Has the speaker for instance created something new that I find both...
Tips – How to use Flash fill in Excel
Over the past 25 years I have constantly been asked how to easily extract single words out of multiple words in a cell in Excel. This is normally because people receive...
Tips – Change case in MS Word 365
I’m sure many of you get so very frustrated when you have typed a lot of text then look up at the screen to see that it's been typed in 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 – Editing the word wrap around images with white backgrounds
Placing images into your text is a great idea as this breaks up the block of text that sometimes overwhelms the reader. You have already (I hope) read my tip on...