Author: Oliver Jobson
-
Working with case sensitive Salesforce Account IDs in Excel
If you manipulate data in excel and want to use the salesforce ID field value as a unique key to move and match data between work sheets then you will quickly discover that normal vlookups can cause huge problems… We can get around this by encoding each salesforce ID in to a number string. Embed from Getty Images…
-
Nick Trueman – Domestic Appliance Specialists, Sales & Repairs in Moreton in Marsh
Tel: 01608 652061 Mob: 07976 894868 Email: [email protected] I couldn’t find these details anywhere when our washing machine broke, so I will leave them here and hopefully they will be useful to someone. Update: looks like he’s now online with his own website here.
-
Guide: Converting MP4 to WMV video files on a Mac (for free)
The free and quick way to convert MP4 to WMV (or MP4 to WMV) video files on a mac ffmpeg will be your friend here. It’s a command line tool, but don’t be scared – just follow these steps: Install Macports by downloading the OS X Package Install file and following the instructions from the…
-
Fix: Windows iTunes Audio Config error: no sound-card, Server
TLDR – no sound card on my windows 10 media server stops iTunes loading properly with windows because of an error message. Here, I show how installing a simple virtual sound card/device gets around this problem. The problem: I run a virtualised, ‘headless’ server environment at home. Because it is headless there is no local…
-
Unequipped for content marketing
‘Content is the most important thing Marketeers can do, and yet we are unequipped to take it from a skills and sourcing level.’
-
Service provisioning woes…
“Hi, I ordered the new, premium router and I think I’ve received the normal one?” “Ok I’ll just check for you…” (Not sure how he was going to check what I’m holding in my hand… “Ok sir, I’ve had a look and you’ve definitely been sent the correct router.” “Have I?” “Yes.” “I don’t think…
-
Barclaycard Customer Service: room for improvement?
I lost my Barclaycard. Embed from Getty Images I’m typically not a forgetful person and I don’t loose things. Ever. Well, almost. But for some reason in the last year I’ve had a complete mare with my Barclaycard. Before this year, I’d only ever lost a couple of cards in my whole 32 years. In…
-

Shortcut: how to zoom in and out in Excel, Word 2016 for Mac
I used to be able to quickly zoom in and out in Excel 2012 for mac. I think I created a custom keyboard shortcut to do this in the old version of excel by using the ‘cmd’ and ‘+’/’-‘ keys ( setup in the OS X Keyboard preference panel), but after upgrading to Office 2016 this…
-

How to: VNC to Ubuntu from Mac client over SSH Tunnel
I’ve configured VNC for ubuntu on a couple of occasions and it’s always taken me far longer than necessary. This time, after having a server compromised recently I wanted a more secure way of connecting to VNC from remote locations so here I will also explain how to setup an SSH tunnel for the VNC…