Going through my many Excel Functions that I use I remembered one that I think you’ll like. It helps to find data that you need to work on and highlights it in a different way to using Conditional Formatting which I showed you some time ago. The function in question is called ISNA. It can be…
I’m always amazed that people do not protect their spreadsheets when they are used by many different people in their company. When I walk round a company to help people at their desks, I find so many of them complain that the spreadsheets they worked long and hard over have been changed. They now don’t…
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 can be used in various ways. I often get people asking if there is any way that Excel could deliver the dates for the…
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…