Tips – How to collect information from a data file and create a sentence...
You may work with data files all the time and get frustrated that the information you need to produce a report is held in several different cells. You need to write...
Tips – Using Shortcut keys in Excel – General shortcuts
When windows and GUI was in its infancy my students were really against learning any key strokes to perform any function in any application. Today, some 20 years on, my students...
Setting defaults for Word Documents
Do you get really frustrated that every time you want to create a new document in Word, you have to select the text, the font and all the other settings your...
Soft Returns for Word Documents Explained
What is a soft return? It conjures up some lovely images of warm duvets and soft beds to crawl into and sleep.
I’m afraid it's not that at all. I’m talking about...
Tips – Editing the word wrap around images with white backgrounds
Placing images into your text is a great idea as this breaks up the block of text that sometimes overwhelms the reader. You have already (I hope) read my tip on...
Create a Shortcut key for the strikethrough effect in Word
I had a student approach me the other day who asked if there were shortcut keys to change a highlighted word into bold or underlined or even italic. And could you...
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...
Changing Numbered paragraphs in Word to letters or bullets
People number their paragraphs in a document for various reasons. In previous tips I explored numbering paragraphs, continuous numbering and starting from 1 again. Do read those in conjunction with this...
Tips – setting up a meeting in Outlook Calendar
Just because you have been using a pc for a number of years, doesn’t mean you know everything there is to know in each and every application. My students who come...
Setting what number, the paragraph numbering should start in Word
In my previous tip, I showed you how to set the numbering for paragraphs. In this tip I am going to explore how to set the numbering to either start from...