Microsoft Excel for Crime Analysis - Introduction Course

Microsoft Excel for Crime Analysis - Intro

About Course

Learn to format cells, work with formulas, create charts and graphs, work with pivot tables and slicers, and more!  This in-person hands-on course provides students with an introduction to using Microsoft Excel for Law Enforcement, a program most agencies already have.  Students will learn how to use Microsoft Excel to manipulate and analyze crime data, create charts and graphs, make a next hit forecast, calculate crime rates and percentage change, find patterns using pivot tables, pivot charts and slicers, and work with workbooks.  Students who complete this course are able to clean and manipulate large data sets, calculate the most common statistics used in analysis, use various tools and functions to find patterns in crime, make accurate crime forecasts, and create visually appealing tables.

Couse Outcomes

  • Ability to format visually appealing tables
  • Ability to calculate crime rates and percentage change
  • Ability to forecast a next-hit prediction for a crime series
  • Ability to analyze crime data for patterns
  • Ability to create pivot tables, pivot charts, and slicers
  • Ability to connect to direct connect to data
  • Ability to organize and clean data quickly

$450

  • Beginner Level
  • 3 Days (21 hours) Duration
  • Certificate of Completion
  • Step-by-Step Booklet Included
  • Taught in a Computer Lab

A course by

Audience

  • Crime Analysts
  • Students
  • Interns
  • Anyone interested in advancing their spreadsheet skills

Course Dates and Locations

Course Dates Hours Location Price Open?
Excel for Crime Analysis-IntroductionApril 23-25, 20258am to 4pm5801 E. Slauson Ave., Commerce, CA$450Yes - 2 Spots Left

Should I Join the Waitlist?

If a course is marked "Full-Waitlist Only", all slots are filled but not all payments are complete. If a student fails to pay, their slot goes to the waitlist in order of registration. A course marked "Full" means all slots are paid for. You can join the waitlist for full courses, but slots become available only if someone cancels, which could be very close to the start date.