Monthly Archives: September 2015

Microsoft Excel – totalling or averaging a column containing an error value

Posted on September 28, 2015 by jdonbavand

If one of your cells in Excel has an error value then using the Autosum button to total or average the numbers in the cells will also result in an error. I could get round this using the IFERROR function … Continue reading →

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

Microsoft Word – moving paragraphs and bullet points

Posted on September 20, 2015 by jdonbavand

When they want to move a paragraph further down in a Word document most people cut and paste. Similarly with bullet points. However, there is another way which doesn’t leave extra spaces between paragraphs or extra bullet points. Select the … Continue reading →

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

Microsoft Excel – inputting mobile numbers in a specific format

Posted on September 17, 2015 by jdonbavand

I was recently asked how to get mobile numbers in the format XXXX XXX XXX in an Excel worksheet. The answer is leave the column in which the mobile numbers are to be input formatted as General. Go to the … Continue reading →

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010 | Tagged , , | 2 Comments

Microsoft Excel – changing time from 1400 to 14:00

Posted on September 6, 2015 by jdonbavand

Sometimes we are given a column of times in a worksheet but they don’t look formatted as we went them to be, e.g. 1400 instead of 14:00. If the times are as shown in column A above, we need to … Continue reading →

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