Ignoring a Conversation Chain of Emails in Outlook

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

Setting up Outlook & Lync on a Personal Computer

  If your companies IT policy allows it, you may wish to setup your corporate Exchange account on your personal computer / laptop copy of Outlook. You can then take it one step further, if you so wish, and configure Lync on the back of this. Every company has a different setup, so some settings Read More

Showing Your Outlook Mailbox Size on the Status Bar

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

Creating Access ‘Jobs’, and Triggering Them from Outlook

  In this post, I’m going to cover how to create a ‘Job’ in Access, and how to setup a reminder in Outlook, including a ‘Trigger from Outlook’ button. This post assumes you’re largely familiar with importing data into access (I’ll try and do a post on this some time, for those of you less Read More

Using SUMPRODUCT to create a Conditional Weighted Average in Excel

Follow this article to learn how to use this resourceful function to create a Conditional Weighted Average in Excel Read More

Compress Outlook Data Files

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

Using Hlookups to bring back results in Excel

  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

Add a Time Bar to your chart

Line charts are a great way of showing the trend of information over time. I often use them to show both the historic actual, but also the forward forecast. Sometimes, however, it’s not always clear looking at a chart where your ‘actual’ ends and your forecast begins. I like to add an indicator showing me Read More

Using RANK(), and ROW_NUMBER to Rank a field without ‘skipping’ numbers in SQL Server & Teradata

In this post, I want to cover off a little bit of RANK() usage in SQL, but then focus on how to use ranking to get a unique rank number for each row. I will cover both SQL Server and Teradata. RANK() is pretty simple to use, and works pretty much the same way in Read More

Changing Your Teradata Password

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

1 4 5 6 7 8 9