Please note javascript is required for full website functionality.


Power Query: Unlimited Importing of Non-Delimited Text Files

10 March 2017

As a programmer, I was often asked to produce delimited versions of reports which could easily be picked up by Excel. Whilst it is possible to clean non-delimited files in Excel, it’s a laborious and repetitive process, which is why it made more sense to pay for a programmer to automate it.

VBA Blogs: Updating your Status (Bar) in Excel

10 March 2017

Last week, we talked about putting a message box into your VBA code. This week, we’re going to look at another useful way of giving information back: the Status Bar.

Power Query: M-Powered

8 March 2017

Welcome to our new Power Query blog. The built-in functionality of Power Query means that many tasks can be accomplished at the press of a button. But what if there isn’t a button for what needs to be done? Then it’s time to delve into M, the programming language behind Power Query.

A to Z of Excel Functions: The BITOR Function

3 March 2017

’m starting to get used to these functions now, well a BIT anyway (get it?)...

VBA Blogs: Using Message Boxes in Excel

3 March 2017

This week, we’re going to look at how to set up message boxes in Excel and VBA...

Power Query: Time for Refreshments

1 March 2017

Welcome to our new Power Query blog. So far I have shown that a variety of data can be extracted and loaded into queries and worksheets. Today I look at how to keep that data current by triggering automatic refreshes.

In the Black

27 February 2017

We have finally been mentioned on an issue of InTheBlack!

Monday Morning Mulling: February Challenge

27 February 2017

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.

Final Friday Fix: February Challenge

24 February 2017

On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!

Power Query: a World (Wide Web) of Possibilities

22 February 2017

Welcome to our new Power Query blog. I have already shown how to extract and transform data from CSV files, folders and Access database tables. Today, I look at a potentially huge source of data – extracting data from the web…