The recent Provider Admin conference in East Hanover provided much food for thought.  Kim Champney and I from REACH had fun doing our Pivot Table demo.  We are still amazed at how easy it is to drill down through masses of Therap data downloaded into Excel to find pictures, patterns, outliers – and how easy it is for people to learn once they realize that Pivot Tables are for BEGINNERS!!!

Try this YouTube video to get an idea of how simple this tool is.

Video on how to Create a Pivot Table in Excel 2007 For Dummies

One other thing we learned at the Conference is that, depending on how your operating system and Excel are configured, you might have to save an Excel download from Therap, first, before you can use Pivot Tables. Don’t ask me why.