Monthly Archives: October 2014

Microsoft Project 2010 and Project 2013 – viewing the Critical Path

Originally posted on ifonlyidknownthat:
The critical path is the series of tasks that must be completed on schedule for a project to finish on schedule. A delay to any one of the tasks in the critical path will cause a…

Posted in Uncategorized | Leave a comment

IFERROR – Replacing error messages in Microsoft Excel with blanks

Originally posted on ifonlyidknownthat:
If you have to divide figures in one column by figures in another column, you may not want the error message #DIV/0 to appear if one of the figures in a second column is a zero.…

Posted in Uncategorized | Leave a comment

Better Business Writing Boosts the Bottom Line

Originally posted on ifonlyidknownthat:
On many occasions, bad business writing can fail to deliver – the tender may not be awarded, the board may become bored, the client may not commit to future work. The video below gives an insight…

Posted in Uncategorized | Leave a comment

Microsoft Word – Adding file path to header or footer

Originally posted on ifonlyidknownthat:
If you are sending a Microsoft Word document to a colleague you may want them to know where on the network the file is located. This information could be included in the footer, at the bottom…

Posted in Uncategorized | Leave a comment

KeyTips in Microsoft Office 2007, Microsoft Office 2010 and Microsoft Office 2013

Originally posted on ifonlyidknownthat:
If you are an excellent typist you may prefer to use the keyboard rather than keep stopping to use the mouse to select a ribbon button If you press the Alt key from any ribbon, KeyTips…

Posted in Uncategorized | Leave a comment

E-mailing straight from a Microsoft Office application

Originally posted on ifonlyidknownthat:
If you are in a rush to get an open document e-mailed out to someone, you do not need to go to Microsoft Outlook and locate it on the system and send it as an attachment.…

Posted in Uncategorized | Leave a comment

Communication Skills – Reading Body Language

Originally posted on ifonlyidknownthat:
How do you know whether someone you are talking to face-to-face is feeling uncomfortable? They may feel you are intruding on them, or you may be making them nervous. Tell-tale signs are: Tapping Rocking Leg swinging…

Posted in Uncategorized | Leave a comment

Microsoft Excel – referencing last row in a worksheet from another worksheet using OFFSET

What if you want a worksheet that references the last row in another worksheet which will update itself automatically as the number of rows in the worksheet changes? We can use the OFFSET function combined with a COUNTA function to … Continue reading

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

Conditionally formatting a row based on the value in one cell in Microsoft Excel

Originally posted on ifonlyidknownthat:
If we have a worksheet where we want to format a row based on the value in a cell, for example, we want to highlight all rows where the invoice date is more than 30 days…

Posted in Uncategorized | Leave a comment

Minute taking – what to record

Originally posted on ifonlyidknownthat:
When taking minutes only motions and resolutions should be taken down verbatim. The rest of the minutes should be an objective summary of what was said. If you are the minute-taker, you should record: All pros…

Posted in Uncategorized | Leave a comment