Technology

How to use the Excel Countif formula Want to know how many records of a certain type you have in an Excel spreadsheet? You need Countif

How to use Excel data validation Keeping an Excel spreadsheet with consistent values is easy thanks to Excel’s data validation feature

Transcend ESD400K review A compact and good-value SSD, but we’re disappointed with its small-file transfer speeds

How to use IFTTT recipes Create IFTTT recipes to automate practically everything on the internet or your smartphone

The best things to happen in tech 2014 2014 was a great year in tech, with plenty of things to celebrate

Soul Combat+ review The Combat+ is a great choice of headphones for exercising if you insist on wearing over-ear cans

BenQ W1070+ review The W1070+'s optional wireless isn't as good as the competition, but this is still a fantastic projector in its own right

ViewSonic VG2401mh review The ViewSonic VG2401mh is a terrific gaming monitor, but it's more expensive than its rivals and it lacks cable management

Top tech cock-ups 2014 2014 really wasn’t a very good year for some, as this list shows

Roccat Ryos MK Pro review The Ryos MK Pro is an expensive but hugely customisable keyboard for keen gamers

How to delete, not archive, Gmail messages on iPhone Fed up of only seeing an Archive option on your iPhone’s email? Don’t fret, we show you how to delete instead

Devolo dLAN 1200+ Starter Kit review Super-fast powerline networking adaptors, but we’d prefer three Ethernet ports

How to use Handoff on iOS 8 and Yosemite You can start a task on one Apple device and finish it on another with Handoff - we show you how to use it on iOS 8 and Yosemite