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.

Upcoming Classes

View Training Schedule
Fort Bend County District Attorney\'s Office
Richmond, TX
December 17, 2018 (2 days)
Kathleen Murphy
Register Now
North Salt Lake City Police Department
North Salt Lake, UT
November 26, 2018 (2 days)
Kathleen Murphy
Register Now
POLICE TECHNICAL
San Diego, CA
September 27, 2018 (2 days)
Metre Lewis
Register Now
Rutgers Police Department
New Brunswick, NJ
September 24, 2018 (2 days)
Georgia Cook
Register Now
Western States Information Network (WSIN)
Sacramento, CA
August 13, 2018 (2 days)
Ashley Englefield
Register Now
Dearborn Police Department
Dearborn, MI
July 16, 2018 (2 days)
Kathleen Murphy
Register Now