Excel for Public Safety by Police Technical

Excel for Public Safety by Police Technical

Learn how to use Excel for Public Safety at our event by Police Technical - come join us and boost your skills!

By Oklahoma Bureau of Narcotics and Dangerous Drugs

Date and time

June 12 · 8:30am - June 13 · 5pm CDT

Location

419 NE 38th Terrace

419 Northeast 38th Terrace Oklahoma City, OK 73105

Agenda

Uses in Law Enforcement - Telephone tolls; Financial Analysis; 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

Parsing - Separating data using Text to Columns

Best Charting practices - Bar, columnar, and pie chart usage; and more

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 3 analytical tools you must know - Sorting, filtering, & the magic of Pivo

About this event

  • Event lasts 1 day 8 hours

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.

Organized by

Oklahoma Bureau of Narcotics and Dangerous Drugs

Law Enforcement Training

Agency Contact: James Leone, Training Unit Captain (jleone@obn.ok.gov), and Jennifer Crilly, Training Director (jennifer.crilly@obn.ok.gov)

If you would like to request training for your unit/organization, please click here and fill in the request form.

FreeJun 12 · 8:30 AM CDT