Ah yes, the obligatory link up to the upcoming Brazil 2014 World Cup – bet you didn’t expect to see one here, did you? Isn’t it nice when there’s a surprise at the end of the week? So, with no further ado, here is an Outlook holiday add-in to add the Brazil 2014 games relevant Read More
You may get the impression from some of my posts, such as this one, that I like to be well connected, and ‘always on’. That’s true, to a point. I think these days, being able to access your corporate mail whenever & wherever is being seen as increasingly useful, and often a necessary part Read More
We’ve all seen it – an email that comes out – perhaps someone erroneously replying to an entire distribution list, sparking hundreds of ‘did you mean to send this to the whole dist list’ replies, quickly followed by the obligatory ‘please stop sending me these mails’, ‘everyone – stop replying’ and of course the ‘I Read More
If you want to see your mailbox utilization, FileàInfo will show you the size of your mailbox, and your usage When your mailbox starts to get full, you may see a notification at the bottom of your screen on the status bar showing how full you are (a daily occurrence for many, I’m sure!) However, Read More
Follow this article to learn how to use this resourceful function to create a Conditional Weighted Average in Excel Read More
If you use Outlook, it’s a good idea to compress your Data files from time to time – especially if you’ve had an email clear-out. Even if you haven’t, it a good practice to follow As you receive more mail, your email Data File grows. Deleting mails itself, doesn’t generally reduce the size of these Read More
Today I want to do a quick page on using Hlookups in Excel. Hlookups work in much the same way as a Vlookup (H being Horiztonal Lookup rather than V being Vertical Lookup) but often people forget about it or afraid to use it, instead favouring a more complex approach to the problem. For Read More
Nice simple one today. The first thing you should ever do when granted access to any system, is change your password! Afterall, your IT policy probably a) requires you to and b) will hold you accountable for any misuse under your ID! This is simple in Teradata – you log in using your existing password, Read More
In this post, I’m going to talk about finding the difference between 2 dates in SQL. However, I’m going to cover it across multiple applications. The Problem Statement is simple: How many days are there between two dates? What we want is an integer value back of how many days there are. The solution will Read More
This post will cover a small, but really useful feature in Outlook (2010+, poss 2007). Ever been reading an email, seen someone’s name mentioned, and wondered who they were? Sure, you could type their name into the Address Book, it doesn’t take long. But, there is an even quicker way. Highlight the name. Right Click, Read More