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
|
Ashley Englefield
Ashley Englefield is a 18 year veteran with law enforcement agencies in Northern California. Prior to becoming a Police Officer Mr. Englefield was a United States Marine and served in the infantry. Mr. Englefield obtained a Bachelors degree in Information Systems from California State University Sacramento.
After his time in the patrol division, Mr. Englefield joined the Detective division and worked as an investigator in the narcotics, gangs, fugitive apprehension, and eventually the homicide division.
During his time as a Homicide Detective Mr. Englefield gained expertise in conducting investigations into cell phones, cell phone records, and many aspects of internet related technologies.
Mr. Englefield completed a Masters degree in Criminology at the University of Cambridge (UK), and resides in California.
Host: POLICE TECHNICAL
Location: Online Seminar 647 Ohio Street Online Seminar, 47807 Get Directions
Recommended Hotels:
No recommended hotels provided.