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 settingsRead More
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 meRead More
For many years, Office has followed a consistent colour scheme for its applications – Blue for Word, Green for Excel, Red/Pink for Access etc. And Outlook was always a yellow/orange colour. 2010 & 2007 2003 2000 ’95 Well, you get the idea. And the application itself would also follow this same yellow hue.Read More
Outlook is a great, powerful email Client – especially when hooked up to Exchange within a corporation – everything integrates very well. However, it’s easy for Outlook to get very cluttered with various panes for one thing of another – particularly if you’re using a laptop / small screen / low-res screen. This post willRead More
Nice & easy one today, but useful none the less. Screenshots are a useful way of sharing something on our screens, especially with the plethora of different systems that different parts of the business may use that you won’t all have access to. We all know how to take a screen shot – and weRead More
I wanted to do a a post on file security – particularly for Excel files, though much of it will apply to other Office files. There are a lot of misconceptions out there, and people thinking they’re securing their work / their company’s data, when they’re really not! I apologise in advance if it getsRead More
One of my all-time favourite Excel functions has been SUMPRODUCT – it’s versatility was endless, but was especially useful for when you wanted to SUM up some data with multiple conditions, such as sales of Pencils in the East region, perhaps. Using SUMPRODUCT, we’d have written something like this… This works well, but as anyone who hasRead More
Seeing as it’s coming up to Summer and many of us are taking time off, let’s take a moment to see how we avoid the issue of your mailbox getting clocked up because of those 10MB reports you get every day! This works for Outlook 2010. I’m not sure if it applies to 2007 orRead More
One of my favourite features that has been added in recent years, are the Excel Tables. Excel Tables, really, are just a way of formatting your data to make it easier to work with and manage – but despite it having been around since Excel 2007, they don’t seem to have had a huge uptake,Read More
