Articles
How to assign a shortcut key to the Explode Excel addin
Sorry 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 two more »
Create your own custom formatting shortcut in excel
Like 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 use a more »
Explode Excel Addin - download Latest 2008 version
After 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 right-click more »
The easy way to find and delete duplicates in SQL
Next 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
Casio 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, that's more »
- Getting ExifTool's move files to directories to work properly as Windows batch file
- How to easily & perfectly align your Stem
- How to remove bicycle tyre marks from painted walls
- What's your Robot name?
- Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi
- How to clean the lid and nozzle of your Camelbak Podium bottle
- How to enable and change the Remote IR GPIO pin in OSMC
- Split and extract the first 1000 (N) rows from a text-csv-data file in Windows
- My new scale for measuring oldness
- A datedif function for excel that calculates correctly
- Raspberry Pi 3 HDMI overscan settings and how to correct them
- Create custom Excel function using an array/range input
- SSL on a RaspberryPi - does it slow your site down?
- Remove Real VNC from RaspberryPi Pixel and install TightVNC
- Running a SSL certificated/authenticated HTTPS website over dynamic DNS