The most powerful tool in Excel is the Pivot Table. They summarize data from a list of columns or from a database and are an easy way to create a digital dashboard. In case you've never created a Pivot Table before here is a quick video about how to do it. I'll post some other examples later about summarizing date's and data further but the following video is a good starting point if you're new to the idea.
Ian Furst http://www.waittimes.blogspot.com
"Health 2.0 is participatory healthcare characterized by the ability to rapidly share, classify and summarize individual health information with the goals of improving health care systems, experiences and outcomes via integration of patients and stakeholders."
DISCLAIMER: Any cases presented or examples given are completely fictitious or are compellations of many situations I’ve been in. They come from my imagination and in no way depict any real patient or person I’ve ever met. All opinions are my own and not the opinion of any of my coworkers or people that I work with. I am not your doctor/surgeon so do not use any information here for your own care. This is just a blog of random thoughts on health care not individual advice.