What is and how to use the Outline View in MS Word
When you first go into Word the default view is Print Layout. This shows you the size of the paper, margins and an indication of the font and size of text...
Counting work days without Bank holidays and personal days in Excel.
Carrying on from my previous tip on how to count days between two dates that are just week days. We need to investigate adding in personal days and bank holidays. If...
How to count only week days in Excel
My students are great at finding me new tips to write. This week I had one who wanted to count the number of days between two dates but without the weekends....
Finding the cell that contains just a space in Excel
I have many clients who have the same problem with importing data from other applications into Excel. All seems perfectly well until they start to analyse the data only to find...
Using Animation in PowerPoint Presentations
Hands up those of you who go to presentations and take notes on the design of the presentation. What works and what doesn’t? I guess most of you have not raised...
Linking spreadsheets in Excel 19
A while ago I wrote a tip on how to consolidate two or more spreadsheets together. It occurred to me that maybe some of you were not aware of the simple...
Change and keep column settings in Explorer 10
You would be amazed how many times I get asked this question. “How do I keep the settings of particular columns in Explorer for any future folders I create as a...
Determine what size the window of your app will be the next time you...
We all use more than one application at any time. Usually they open in full screen. This is not always what we want. Many of my students these days are lucky...
How to make a cell change colour of the background whilst typing in new...
In my training course the other day a student asked me how they could make Excel change the background of a cell when they typed in a new word. The simplest...
Using dates that automatically update in Excel
In a previous tip I showed you that you can input dates three different ways into a spreadsheet. One of them was the formula that allowed the result change every day,...