Tutorial

Creating Screen Capture Animated GIFs for Mac OSX Thumbnail

Creating Screen Capture Animated GIFs for Mac OSX

I regularly create short, animated GIFs of my computer screen to illustrate tutorial blog posts that I write. An animated GIF can be such a simple yet effective tool for web based tutorials but they can be a complete pain to create. I've recently come across a new and FREE piece of software that has [...]

Controlling the Raspberry Pi from an iPad Thumbnail

Controlling the Raspberry Pi from an iPad

After the frustrations of the first few days I am now coming on in leaps and bounds with the Raspberry Pi. Today I managed to set up my iPad so it can take control of the RPi. This means that the Raspberry Pi can be tucked away in corner, running headless while the iPad seizes [...]

Waterfall Charts and the X-Axis Thumbnail

Waterfall Charts and the X-Axis

Waterfall charts have become all the rage in the office of late. They are popping up all over. I suppose it is no surprise, it’s springtime and we are well into the planning process and a waterfall chart is the perfect way to demonstrate how a starting position either increases or decreases through a series [...]

Managing Version Control in Excel using Macros Thumbnail

Managing Version Control in Excel using Macros

If you work with spreadsheets that are regularly being updated and amended by multiple users then you will know something about version control. If you then add to this mix, the need to periodically distribute the updated spreadsheet for public viewing you will be more than well aware that Microsoft Excel isn't really designed to [...]

Excel Pivot Table or CrossTab to Flat List Thumbnail

Excel Pivot Table or CrossTab to Flat List

Excel to CrossTabI often find myself struggling to deal with data that has been rendered almost unusable by the data provider who has converted it to a cross tab format. Usually they think they are helping and have probably started with a nice flat list then spent ages formatting it so the data spreads out [...]

Outlook 2007 – Creating Search Folders for Combined Categories Thumbnail

Outlook 2007 – Creating Search Folders for Combined Categories

How to create a custom search folder in Microsoft Outlook 2007 that shows mail categorised in more than one specified category. A combined category search folder using the logical AND rather than the OR operator.

Instructions for Setting up Outlook 2007 for GTD Thumbnail

Instructions for Setting up Outlook 2007 for GTD

I’m moving to a new job soon and wanted to take the opportunity to set up the new email system in line with GTD (Getting Things Done) methodology.

Here’s my checklist for setting up the new system on Outlook 2007.
Most tips and code are taken from Simon Guest over at Simon Says but I’ve amended the code (very slightly) to suit my particular needs and naming conventions. For further details and descriptions please follow the links to his blog where I’ve listed them.

1. Create Folders at same level as Inbox

* @ACTION REQD
* @MEETINGS
* @READ
* @REFERENCE
* @PERSONAL
* @WAITING FOR

2. Create Macro for categorising and assigning email as task:

To create a new task from an email, select the email, run the NewTask macro, choose categories and at least one @CATEGORY, in my case @ACTION. Then you can choose to rename the subject title - this will become the new task.

Conditional Ranking in Excel – RankIF using SumProduct Thumbnail

Conditional Ranking in Excel – RankIF using SumProduct

I was hunting around for a RANKIF function yesterday so I could rank a load of hospitals in terms of their cost per procedure. Unfortunately RANKIF isn’t one of the available functions but I managed to achieve the same effect by utilising the SUMPRODUCT function. I wrote a SUMPRODUCT tutorial some time ago indicating how [...]

Excel CrossTab Table to Flat List

I had a query on my sumproduct tutorial that was effectively asking if I could work backwards from an excel crosstab or data table to get back to the simple flat list. Converting a table like this: Back to the data sheet like this: If you didn’t have to do this sort of task very [...]

Macros to Consolidate Worksheets

I’ve got a spreadsheet with tabs for each individual directorate. Within the tabs are tables with the same layout but different sizes (number of rows). I want to group together all the used data on each tab and create a single consolidated sheet of continuous data. Obviously I need a macro to copy and paste [...]