Hidden Gems #14: Dig for knowledge in your Excel data

You no doubt store lots of raw data in Excel spreadsheets. Then you probably use Functions to simplify and automate calculations in those spreadsheets. Now you have even more information. And you have probably spent plenty of bleary-eyed hours scanning it. This month, I’m on the trail of a raft of Excel Functions specifically designed…