Determine if a file is open in Excel or Google Sheets
We currently use a mixture of Excel and Google Sheets. Not ideal, but it’s important that any output I create can behave with both platforms, there are inherent differences in the platforms. Some of these differences simply can’t be accommodated for. Others, however, can be worked around From time to time, I need my document
Using Ranking Functions in Excel
Master the available options in Excel for ranking you data, including the updated Rank.Eq functions.
Showing a Picture Based on the Value of another Cell in Excel
In this walk-through ,I will show you how to use Excel to make a specific image show depending on a cells value, or by having a drop-down list
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
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
Defer/Delay Outlook Email Delivery
This is one setting I think everyone should use – it defers the sending of an email in Outlook, giving you some options when you realize you sent your boss the mail you meant to send to your colleague (probably because it was about your boss) I’m not sure when it was introduced, but I
Most Read Articles
