Excel for Public Safety Course

Course ID 14-006
Course Topic Excel for Public Safety
Course Start September 15, 2014
Course End September 16, 2014
Course Time 8 am- 4 pm
Course Days Monday, Tuesday
Course Hours 16.00
 

Instructor(s)
Location Northwest Indiana Law Enforcement Academy 
Class Max
# Registered
Course Description

Registration for this course will NOT be done on the NILEA website, follow the link to register.

Course Description

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.

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

This is a HANDS-ON class, bring your with your current version of the program already installed.

 
Course Materials  
Member Tuition $350.00 
Non Member Tuition $350.00 
 

Northwest Indiana Law Enforcement Academy
705 East 4th Street
Hobart, Indiana 46342
Phone: 219-940-3405
Fax: 219-940-9432
Training Provider #: 35-1679834