Blog


How to assign a shortcut key to the Explode Excel addin

How to assign a shortcut key to the Explode Excel addinSorry to bore you with yet another Explode addin post, but I think this is worth it on a couple of fronts. Assingning a shortcut key to the explode plug-in makes more awesome - being able to devle into those dependants even quicker. Also seeing as as my initial explode post is one of my most read posts, I know you'll all lap it up. There are   more »



Create your own custom formatting shortcut in excel

Create your own custom formatting shortcut in excelLike with most things in life, the longer you do something for the more you get set in your ways. Excel is no exception and if I'm a sucker for anything it's number formatting. Maybe it's the accountant in me, but I think negative numbers are easier to read and look far more stylish wiht a bracket around them. Then if you are going to   more »



Explode Excel Addin - download Latest 2008 version

Explode Excel Addin - download Latest 2008 versionAfter many months struggling with my favorite excel explode addin, I've finally discovered the solution to my issues. The problems started after I arrived at a new job - the computers were super locked down and they had Office 2010. I had problems installing the addin and even when it was working there was no 'Explode..' option on the   more »



The easy way to find and delete duplicates in SQL

The easy way to find and delete duplicates in SQLNext in my series of helpful SQL code is duplicates, I seem to always be having issues with duplicates. This annoys me immensely as all of the issues comes from other peoples data I have to work with. No problem I hear you say, google is awash with ways of how to delete them. Trouble is these are all based on blindly deleting superfluous rows   more »



The most accurate watch in the world Casio F108W

The most accurate watch in the world Casio F108WCasio F-108WH-2AEF Sharing the same accuracy specs of the infamous F91W, the F108W sporting a slightly larger workings and casing puts out a  It is a bold claim,  My test started on the 16th June 2014 and finished 19th July 2015. Each time I synchronised it with eBay time. The result - the watch gained 4mins 15secs in that time,   more »



Share page

Subscribe to newsletter

Search Posts

Back to top