Courses

/Courses
Return to Courses

Excel for Public Safety

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! 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.

Agenda
Day One

  1. Uses in Law Enforcement - Telephone tolls; Financial analyses; Agency stats
  2. Navigation & Manipulation - Rows, columns, cells, ranges, worksheets
  3. Tools - Autofill, conditional formatting
  4. Simple formulas - Sum, Average, Median, Mode, Crime Rate and more
  5. Complex formulas - Date conversion to days of week, months of year
  6. Concatenating - Combining data stored separately


Day Two

  1. Parsing - Separating data using Text to Columns 
  2. Best Charting practices - Bar, columnar, and pie chart usage; proper use of data labels, legends, gridlines etc.
  3. Why you should never chart in 3-D
  4. Importing/Exporting - Linking data between products
  5. Data Validation - Creating pull-down lists to give forced options
  6. The three analytical tools you must know - Sorting, filtering, & the magic of Pivot Tables

Day Three (Optional)
1. Hands On Activities – Attendees develop their own materials in a structured hands-on environment.
2. Custom Development – Attendees work with instructor on existing case materials in need of support.