Excel for Crime Analysts

Certificate Program

The Excel for Crime Analysts course equips students with essential knowledge, skills, and techniques to effectively utilize Microsoft Excel for crime analysis. Through comprehensive, step-by-step training, participants will learn basic and advanced Excel functionalities including creating and using templates and formula libraries, designing charts, and formatting data based on specific requirements of crime analysis.

Take this course to build a strong foundation of critical Excel skills that are indispensable for crime analysis.  Completing this course will significantly boost your readiness for CSULB’s Crime and Intelligence Analysis program, making you a more competitive candidate for roles in the Crime and Intelligence Analyst profession. 

We strongly recommend enrolling in this course before starting the Crime and Intelligence Analysis program to ensure you have the necessary Excel expertise to excel in your studies and future career. The specialized Excel skills you learn are also valuable for analysis in various other fields.

This course is certified by the California Commission on Peace Officer Standards and Training | CA POST CCN: 5270-41460.

  • How to apply computer skills specifically to crime analysis
  • How to create products that include administrative and strategic analysis
  • Descriptive statistics and how to present them to different audiences
  • How to calculate mean, median, mode, and standard deviation
  • How to create data entry forms, pivot tables, and charts
  • How to validate data and create validation criteria
  • Classes are fully online
  • Provides an understanding of common errors, solutions, and shortcuts in Excel
  • Prepares students for further crime analysis education
  • This course consists of three online sessions for a total of 24 hours
  • Online classes include synchronous live lectures & asynchronous coursework