Analyzing and Reporting on Juvenile Justice Data with Microsoft Excel Recording Available
If you missed the webinar on using Microsoft Excel to analyze and report on your juvenile justice data, you can view it here.
Watch the recording to see how to quickly and easily answer questions about your juvenile justice data like “How many youth came through the detention center last year, and what were their ages, genders, and races?”
Some juvenile case management systems are difficult to generate this type of data from without involving the IT department or waiting for weeks. During the webcast you will see ways to improve your information analysis capabilities using simple techniques in Microsoft Excel, register for this 45-minute webcast to sharpen your skills or learn new ones to create comprehensive data that can inform policy and decision-making.
During this webcast, Handel’s President and CEO, Even Brande, will review Excel features that include:
- Sorting data
- Filtering data
- Pivot tables
- Creating graphs
Sorting the data allows you to display your data in the order that you want and that will provide the most insight when reviewing.
Filtering the data allows you to remove any of the items from the report that are not pertinent to what you wish to ascertain from your reports.
Learn about Pivot tables which cross-reference data in a matrix where the data runs in a column and compare it to data row. Pivot tables produces targeted statistics on select member or client demographics.
Finally, use this data to create eye-catching charts and graphs that bring you numbers to life.