Category Archives: Work

Add Reminders To Outlook Appointments

Posted on December 17, 2012 by Ross (Admin)

photo credit: Andrew Coulter Enright If like me your Outlook calendar can get a bit hectic and others can add meetings to your calendar sometimes you end up simply “reacting” to your schedule and jumping from one appointment to the … Continue reading →

Posted in Microsoft, Misc, Office, Productivity, Technology, Work | Tagged , , , , , , | Leave a comment

Stay Focussed – Stay OUT of Outlook!

Posted on October 18, 2012 by Ross (Admin)

One of my main productivity “sinks” is continually monitoring Outlook to see if any mails have arrived. I have a rule set up that notifies me if an “important” email lands but for this to run, outlook needs to be … Continue reading →

Posted in Microsoft, Office, Productivity, Technology, Windows | Tagged , , , , | Leave a comment

Multiple Excel Text Boxes With Common Content

Posted on June 29, 2012 by Ross (Admin)

I have just had to place a textbox object onto 17 worksheets within the same excel workbook, each text box containing the same commentary text. Type it once and then copy the text box and paste, job done. Of course … Continue reading →

Posted in Microsoft, Office, Windows, Work | Tagged , , , , | Leave a comment

Oracle SQL Developer and Commas

Posted on October 13, 2011 by Ross (Admin)

Just found an interesting feature in SQL Developer 3 I created a dataset that contained two columns of numbers that I wanted to quickly get into excel. I choose, export in CSV format to clipboard so that I could quickly … Continue reading →

Posted in Oracle, Work | Tagged | Leave a comment

Microsoft Office–VBA Editor Keeps Opening

Posted on October 7, 2011 by Ross (Admin)

For weeks now I have had the mild annoyance that the VBA code editor for various Excel spreadsheet’s appear to be opening at “random”. I finally tracked it down to me unlocking my PC. If I have excel running then … Continue reading →

Posted in Microsoft, Office, Windows, Work | Tagged , , , , | Leave a comment

Changing Excel Cell Values To Uppercase

Posted on August 23, 2011 by Ross (Admin)

A nice quick tip, I had lots of cell values in a mixture of cases that should have been uppercase. Create a macro: sub MakeUpper() for each myCell in Selection   myCell.Value = UCase(myCell.value) next myCell end sub Add a … Continue reading →

Posted in Microsoft, Office | Tagged , , , , | Leave a comment

Update All Fields In MS Word

Posted on April 19, 2011 by Ross (Admin)

Sometimes you find a feature in a product that is just blatantly missing. One of those in Microsoft Word is the ability to update all the fields in the document with the latest value in a field. I use both … Continue reading →

Posted in Microsoft, Office, Work | Tagged , , , , , | 1 Comment

Running – Dashboard – Marcothon

Posted on December 3, 2010 by Ross (Admin)

I’m building up for my running challenges of 2011 and breaking in my new treadmill so I am slowly building up my miles. On incentive is the Marcothon group on FaceBook, the basic premis is to run for either 3 … Continue reading →

Posted in Fitness, Running, Xcelsius 2008 | Tagged , , , | Leave a comment

Favourite Shortcut Keys – Outlook

Posted on August 9, 2010 by Ross (Admin)

photo credit: laffy4k If you look at the left hand menu you will see the items: Mail Calendar Contacts Tasks etc These can be quickly accessed by using the following shortcut keys: (Ctrl+1) – Mail (Ctrl+2) – Calendar (Ctrl+3) – … Continue reading →

Posted in Microsoft, Office, Technology | Tagged , , , , , | 2 Comments

Google Calendar Sync – Auto Run

Posted on April 16, 2010 by Ross (Admin)

A nice quick hint. I kept forgetting to start Google Calendar Sync when I started Outlook. I don’t always start Outlook when I start my laptop and I’m not always online when I run Outlook so puting it in my … Continue reading →

Posted in Microsoft, Office | Tagged , , , , , | 11 Comments