One of the coolest tricks in Microsoft Excel is the ability to use it to calculate complicated matrix functions. While this isn't a totally mainstream use, if you've ever needed to work with matrices ...

A Python program for creating Excel percent matrices on how complete your data is. This program works by reading a set of Excel files, putting together a single report on how complete the data fields ...