Formatting Data Tables with Excel

Written By: S. Marc Testa, Ph.D.
Published On: 09/27/2013

One very effective way to turn reports around faster is to use an Excel-based template for scoring or formatting. Though computerized scoring programs (e.g., WAIS-IV Scoring Assistant, Q-Local) make scoring a protocol easy, there may be an additional need to format the output.

This screencast demonstrates how to use Excel to “grab” data scored by a scoring program (in this case the Calibrated Neuropsychological Normative System-Software Portfolio; CNNS-SP) and to generate a figure that can be used during a team discussion or pasted into the body of the final report itself. The particular template demonstrated in the screencast is used in a dementia clinic and allows for great efficiency in a fast moving clinical situation.

Anyway, enjoy the magic show!


Similar Pages

Contact

twitter facebook

© 2012 - 2018 Neuropsych Now


Licensed under a Creative Commons Attribution-NC-ND 4.0 International License

Privacy · Terms