• Those interested in CSULB's Crime and Intelligence Analysis Certificate program, CA POST Crime Analysis Core Course, or the CA POST Real Time Crime Centers course.
• Anyone who would benefit from additional Excel training specific for the role of a crime or administrative analyst
• Active analysts in various other fields who want to learn additional Excel skills

• 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

• Overview of Excel (1.5 hours)
• Building Spreadsheet Templates (1.5 hours)
• Entering and Organizing Data (2.5 hours)
• Basic Crime Analyst Formulas and Creating a Library (2.5 hours)

• Refresh - The role Excel plays in an analyst’s job (5 min)
• Functions to Manipulate Text (2 hours)
• Inserting Data into a Spreadsheet (1 hour)
• Creating Charts (1 hour)
• Analyzing Data (0.5 hour)
• Sorting Data (0.5 hour)
• Formatting Data (1.5 hours)
• Filtering Data (1.5 hours)

• Refresh - How to organize data and use available Excel tools (10 min)
• Forms – Enter and Search Data (1.5 hours)
• Pivot Tables (1.5 hours)
• Bringing in Data from Other Sources (1.5 hours)
• Troubleshooting (1.5 hours)
• Shortcut Keys (1.5 hours)
• Product Validations (1.5 hours)

No, unfortunately we do not offer financial aid or payment plans for this course. Full payment is due prior to the first day.

No, this course is not limited only to CSULB students.

Yes. Registration is open to anyone, whether you are a college student or an employee with a law enforcement agency.

No, this course is not eligible for college credit. However, you may earn Continuing Education Units (CEU’s) through the College of Professional and Continuing Education.

You will need a working computer and the latest versions of Microsoft Excel and Zoom. It is highly recommended to work with two monitors, as you will be completing exercises during the class session.