Monthly Archives: August 2014

Microsoft Word – creating table columns of equal width

Often when you create a table within Microsoft Word the first column of the table has the largest amount of text in it: Type of item sold April May June Encyclopaedias and reference books 25 43 54 Novels 250 321 … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | Leave a comment

Finding someone’s age from their date of birth

Originally posted on ifonlyidknownthat:
Using Excel and need to find someone’s age from their date of birth? There is a function not readily documented by Microsoft, called DATEDIF, which will do just that. Say the person’s date of birth is…

Posted in Uncategorized | Leave a comment

Pinning files to the recently used list (Office 2007 and 2010)

Originally posted on ifonlyidknownthat:
When you click the Office button in Office 2007, you will see a list of recently used files. To keep a file in the list indefinitely, click on the pin to the right of the filename.…

Posted in Uncategorized | Leave a comment

Left Caps Lock on by mistake in Word or PowerPoint?

Originally posted on ifonlyidknownthat:
Have you ever inadvertently left Caps Lock on in either Word or PowerPoint, and have a length of text that has upper-case letters instead of lower-case ones and vice-versa? If you are using Office 2007,  Office…

Posted in Uncategorized | Leave a comment

Displaying all the formulas in an Excel worksheet

Originally posted on ifonlyidknownthat:
To quickly display all formulas in a worksheet, press Ctrl + ` (the button to the left of the number 1 on the keyboard). This enables you to check for consistency. If you have inherited the…

Posted in Uncategorized | Leave a comment

Freezing headings in an Excel worksheet for easier scrolling

Originally posted on ifonlyidknownthat:
I don’t know about you, but I find it a great nuisance if I scroll down an Excel worksheet and cannot see the column figures as I often can’t remember to what the data refers. You…

Posted in Uncategorized | Leave a comment

Bringing slides from another presentation into Microsoft PowerPoint

Originally posted on ifonlyidknownthat:
When people have to include slides from another presentation in PowerPoint, they often copy and paste the slides from one presentation to another and then have great problems with the formatting. If you are using Office…

Posted in Uncategorized | Leave a comment

Removing blanks from credit card entries in Microsoft Excel

I was asked recently how to get rid of blanks in credit card entries within an Excel worksheet, e.g 1000 2000 3000 4000 should read 1000200030004000. The way I did it was select all cells in the Credit card column, … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Project – Resource Contouring

If you assign a person to a 10 day task at 25% of their time, Microsoft Project assumes that they will do the task at 25% of their time throughout the duration of the task. What happens if you know … Continue reading

Posted in Microsoft Project, Microsoft Project 2013, Microsoft Project 2016 | Tagged , | 1 Comment