Microsoft Excel for Crime Analysis - Intermediate Course
About Course
Extend your Excel skills with our intermediate Excel course for Crime analysis. Clean data faster and easier with our tips and tricks. Validate your data with rules to eliminate dirty data. Optimize your analysis by using lookups and advanced formulas. Learn how to create a dashboard within Excel, forecast trends with our advanced statistical model, use macros to automate tasks, and find patterns with conditional formatting. We also cover advanced charting for insights into your data, shortcuts to make your tasks faster, and ways to obtain quick statistics. We show you how to quickly and efficiently analyze data so you can respond to requests for crime statistics, call for service response times, and other department requests that may come your way. This course is packed with great information to help you streamline your workflows, optimize your efficiency, and minimize the time spent cleaning data and finding patterns. It's time to level up your spreadsheet skills!
Prerequisite: Completion of Microsoft Excel for Crime Analysis - Introduction Course or approval from instructor.
Couse Outcomes
- Ability to validate data
- Ability to clean data quickly and efficiently
- Ability to create a crime dashboard
- Ability to use conditional formatting
- Ability to forecast a trend using advanced statistics
- Ability to use macros in Excel to automate tasks
- Ability to use advanced formulas
- Ability to create advanced charts such as aoristic temporal charts, sparklines, and combo charts
$450
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 - Intro | August 12-14, 2026 | 8am to 4pm | 5801 E. Slauson, Commerce , CA | $450 | Yes |
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.