Duplication in PowerPoint
How many times do you create a pretty box or object in PowerPoint and need to have exactly the same again and again and again. Possibly in different sizes or angles...
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...
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...
Using Numbering in Word
This topic may sound so simple but unfortunately Microsoft Word is becoming more and more automated and things “just happen” and we don’t know why. I had a class not so...
Need to change the data in a cell from lots of characters to just...
My students come to me with all sorts of questions. One that seems to come up every so often is how to easily change the length of a piece of data...
How to change case in Excel
You may well know that in Word you can change the case of your text very easily. What was originally all in lower case you can change to All upper or...
Calculating number of workdays between two dates where weekends are not Saturday and Sunday
A recent tip of mine showed how to calculate the number of working days there are between two dates. Also where there are bank holidays involved. Today I shall investigate the...
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....