Some of you may still remember the time, when we used computers, we had to do everything with just the keyboard. Yes, there were no pretty icons to select to do something for us. Or just click on something in a complex dialog box with a multitude of selections. We had to know special key…
I see loads of adverts for all sorts of loans that look so inviting. But wouldn’t you like to see what will be the amount you have to pay back if the rate of interest changes. One such way is to create a Data table in Excel. Using the PMT function to do the calculations.…
This may sound like a very easy subject for most but I do find that a lot of people still don’t know how easy it can be to create a chart in Excel. My first question to all of you is “Why do you want a chart?” the answer is simple “to make the multitude…
When I do a walk about day on clients sites, I come across many people who work with enormous spreadsheets. They have columns of formulas referring to several columns of data then another column of formulas referring to the next block of data and so on. I watch them laboriously hide columns they don’t want…
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…
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…