Tag Archives: Microsoft

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

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

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

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

How Annoying is the Microsoft At Home RSS Feed?

Posted on January 27, 2010 by Ross (Admin)

I’m using Microsoft Outlook 2007 and I think it’s a great piece of software. It has a built in RSS feed reader. Typically I use Google Reader but as that can’t handle authenticated feeds I’m using Outlook for all of … Continue reading →

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

MS Excel – Convert Percentage To Number

Posted on July 25, 2008 by Ross (Admin)

I have spent most of today throwing data around in MS Excel. One of the things that I have had to do is to convert percentages into real numbers. In excel percentages are stored as fractions, for example 50% is … Continue reading →

Posted in MIG, Maxima, Maxima Information Group, Microsoft, Office, Work | Tagged , , , , , | 5 Comments

Latest ETL Tool – MS Excel

Posted on July 25, 2008 by Ross (Admin)

I have spent all day in MS Excel. I receive excel spreadsheets in a “fairly” fixed format. I need to get this data into Business Objects Xcelsius via another spreadsheet that stores historical records and keeps the data in a … Continue reading →

Posted in MIG, Maxima, Maxima Information Group, Microsoft, Work | Tagged , , , , , , | 2 Comments