Excel: How to find and count duplicate values in two lists
Use COUNTIF in Excel to quickly count how many values in one list appear in another.
blogdc2cdd77b62
How to fix conflicting changes in Evernote
Do you see something like this in your Evernote note? Conflicting modification on 28 January 2016 at 12:30:23 It means that you were using more than one device to edit your note, and you made changes…
How to speed up online video playback
If you watch a lot of online video, as I do in order to stay up to date on the latest technologies, you might find it useful to speed up the video so that you…
Email accounts are being hacked! Make sure your password is strong!
Over the last few weeks I’ve been getting a large number of spam emails from various friends who have had their email accounts hacked. The password has been guessed, and the attacker has sent emails…
Easiest way to comply with UK Cookie law on websites (PECR)
Thanks to the good old EU and it’s charming directives, UK law now requires websites to show a warning to the user if they are using cookies. This is the Privacy and Electronic Communications Regulations (PECR), and there’s…
How to Fix: Scansnap ix500 scanner won’t power on
If you can’t turn on your scanner, here’s a way to fix it. Disclaimer: Nothing here should be harmful to your scanner, but you do it at your own risk! The Scansnap ix500 is a…
A “fan” of simplicity
This blog post from Digital Amit is an oldie-but-goodie on a quick lesson in simplicity. This could be a useful story for you to tell when motivating your teams to keep it simple! It compares…
The Agile BA: Agile Business Analyst Course
I found a very good course for Agile Business Analysts, called The Agile BA. As the homepage says, there’s 150 minutes of learning material (comprising 62 videos in 7 modules) and 30 quiz questions (with…
Fun and useful tools from Google that you might not have seen
Here’s a few genuinely useful things that you might not have realised you can do with Google. Here’s the ones I think will be most useful or fun for you: Set a timer, optionally full-screen:…
Problems coordinating your project? Try a short daily stand-up meeting.
This article is very back-to-basics, but I think many people would still benefit from applying it. So here goes! I was chatting to someone recently who’s involved in a project with lots of different departments within…