Tips – Using Outlining in an Excel spreadsheet
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...
Tips – How to create a Watermark in Word
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...
Tips – Inserting Quick Tables in Word
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...
Tips – Inserting an Excel spreadsheet into Word
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...
Tip – Drawing Tables in Word
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...
Tips – Using the ISNA function in Excel
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...
Tips – How to protect parts of your spreadsheet
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...
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...