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 all they need is a few bullet lists to keep the audience on the same road as the speaker. Complicated illustrations, photographs and graphs…
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 section of functions that calculates payments for loans. I use this function to demonstrate the fact that you need to know what you’re…
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 do see people in meetings trying to marry up two pieces of paper to align the information running from one to the other. Guess…
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 selection of templates that make your choices easy to create a wonderful and colourful presentation. Most large companies however do have a…
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 interesting and want to copy for my own presentations. I do find though that some companies do not make their presenters keep to a…
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 imported data from external applications where, for example, people’s names are merged into a single. It used to be a pain to do this…
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 wrong case. What you wanted in lower case is in upper and vice versa. I find it amazing that no one has told you…
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 Folder only seems to be causing confusion for people with the Quick Access Toolbar. For me, do like the fact that folders you access regularly…
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 how to place pictures and use the word wrap tool for images in my last tip. I would like to introduce you to the…
Last week I showed you how to create columns of text in Word for a newsletter type of document. Today I shall show you how to place pictures into this text and make the ‘story’ more appealing to read. The saying is “a picture paints a thousand words” so use that to your advantage. Embellish…