You won’t believe it but yes I have seen many people actually use a highlighter pen to write diagonally across a document that it is a draft or a copy rather than trying to create a watermark which looks far more professional. A watermark can be used for a number of things. Your logo for…
Tables in word are quite diverse. You have now read (I hope) my other three tips on tables. Create a simple table, draw a table, insert an Excel spreadsheet and now Insert a Quick table. What is a Quick Table Microsoft have created four sets of ready to use tables for your convenience. They are…
This tip is the third in a series of four tips about different ways of creating a table in Word. I have already shown you how to insert a simple table from the Insert tab, draw a table and now I’m going to explore the excel table. Or rather how to insert an Excel…
I often see people struggling with tables in Word. They create a table by inserting it. There is nothing wrong with that. But what they then need is different sized cells or columns down the table and they spend a long time merging cells and highlighting and dragging boundaries. Nothing wrong with that at…
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…