Harnessing the power of Microsoft Excel® to better manage data & improve investigations.
Course Overview
Microsoft Excel® for Public Safety™ is designed to help public safety personnel best utilize Microsoft Excel ® to successfully manage law enforcement specific data. Whether it is case specific data (e.g. telephone tolls, financials) or agency-wide data (e.g. arrest stats, fugitive lists, calls for service), it can be analyzed with just a few clicks using this powerful tool!
Who Should Attend
This course is intended for law enforcement personnel, which includes: any sworn officer, support staff, administrative personnel, Supervisors and Management. Attendees need only a basic understanding of computers and Excel®. No technical or analytical background is required.
Material Requirements
Students should bring a laptop with Microsoft Excel (version 2003 or higher). Additional materials (data sets) will be provided to students.
|
Agenda
Day One
- Uses in Law Enforcement - Telephone tolls; Financial analyses; Agency stats
- Navigation & Manipulation - Rows, columns, cells, ranges, worksheets
- Tools - Autofill, conditional formatting
- Simple formulas - Sum, Average, Median, Mode, Crime Rate and more
- Complex formulas - Date conversion to days of week, months of year
- Concatenating - Combining data stored separately
|
Day Two
- Parsing - Separating data using Text to Columns
- Best Charting practices - Bar, columnar, and pie chart usage; proper use of data labels, legends, gridlines etc.
- Why you should never chart in 3-D
- Importing/Exporting - Linking data between products
- Data Validation - Creating pull-down lists to give forced options
- The three analytical tools you must know - Sorting, filtering, & the magic of Pivot Tables
|
Joseph Brown
Joseph Brown is a Criminal Intelligence Manager with over 15 years of experience in the Law Enforcement field, specializing in technical solutions to analytical/investigative issues. Joseph has a data driven approach and has spent most of his career within the Crime Analysis, Digital Forensics, and Investigative fields. He has also taught for over 12 years in higher education in both the online and grounded formats. In addition, Joseph has trained dozens of personnel in his own analytical units and other agencies around the country.
One of Joseph’s primary goals is to push the field of Investigative Analysis/Crime Analysis to the forefront in Law Enforcement. With technology and data outpacing our ability to deal with it, it is paramount for individuals in Law Enforcement to take notice and learn to implement and utilize it in the proper way. The most important elements in a successful Analytical unit are the abilities, techniques, critical thinking skills, and technical prowess of the staff within them.
When Joseph is not working/teaching, he is focused on his family, his childhood hobby riding/racing motocross, and constantly learning something new.
Host: Thornton Police Department
Location: Fossil Ridge Public Safety Facility 13150 Quebec Street Thornton, CO 80601 Get Directions
Recommended Hotels:
| Name |
Full Address |
Contracted Rate |
|
| Holiday Inn Express |
12030 Grant St, Thornton, CO 80241 |
None |
View Hotel |
Return to Training Schedule