Category Archives: Uncategorized

Dealing with difficult people at work

It’s not me it’s you! Here’s some tips for dealing with the trials and tribulations of working with difficult colleagues and clients. Don’t sweat the small stuff.  Pick which battles you really want to win.  Sometimes it’s easier just to … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Microsoft Excel – finding a week number

Although it is easy enough to work out the month or year of an Excel date, using the MONTH and YEAR functions, it is not as obvious to work out what week of the year a date falls in. However … Continue reading

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

Time Management – Turning off Microsoft Outlook e-mail notifications

Originally posted on ifonlyidknownthat:
If you are busy concentrating on writing a report, a proposal, etc, you need to concentrate on the task in hand, not constantly be distracted by an e-mail notification symbol becoming visible at the bottom right…

Posted in Uncategorized | Leave a comment

Microsoft Access – finding duplicate records

Originally posted on ifonlyidknownthat:
If you want to find duplicate entries in a field in a table or query, the easiest way to do this is to use the Find Duplicates Query Wizard. For example, you may wish to find…

Posted in Uncategorized | Leave a comment

Microsoft Excel – #### in a cell

Originally posted on ifonlyidknownthat:
You may have had the experience of think you are doing something wrong, because you see an Excel cell filled with hashes. In fact this is not an error at all, but instead means that your column…

Posted in Uncategorized | Leave a comment

Microsoft Outlook – greying out previous appointments

I was asked recently whether there is a way to show past appointments in Microsoft Outlook in a different colour to future appointments. From within the Calendar, go to the View tab, then in the Current View group, click View … Continue reading

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

Microsoft Excel – Mac keyboard shortcut for absolute cell references

If you are using a PC or Windows based laptop, you can make an Excel cell reference absolute (or fixed) by pressing the F4 function key on the keyboard after the cell reference. The equivalent if you are using a … Continue reading

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

Microsoft Excel – sorting or Charting Week1, Week2 etc

Someone I was training had a spreadsheet with one column showing Week 1 onwards and another column showing sales figures for that week. If you sort the information by another column and then sort by the week column again, you … Continue reading

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

Microsoft Excel – finding process date using working days from end date

If I have a date in which an order has to be sent and I know the number of working days that it takes me to process the order, I may want to find out when I need to start … Continue reading

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

Adding text to a formula in Microsoft Excel

Originally posted on ifonlyidknownthat:
You want to have text and the result of a formula in the same cell; for example the cell should say “Total Sales Made: ” followed by the result of the calculation to work out annual…

Posted in Uncategorized | Leave a comment