Event Calendar
Prev MonthPrev Month Next MonthNext Month
Virtual Conference: EXCELerate Your Reports
Tuesday, June 25, 2024, 1:00 PM EDT
Category: Training

Join us for the first session in this year's FREE Virtual Conference!

EXCELerate Your Reports

  • When? June 25th, 2024 @ 1300 ET
  • How much? FREE for all attendees
  • Register here!
  • This webinar WILL be recorded.
Most crime analysts must generate regular reports for their agencies. The reports usually contain information about their crime rates, district/boundary information, and key metrics for Command Staff and city management. Many of these reports are tedious to create and involve a multi-step process of pulling data from a RMS system, copying the data into Excel, and running pivot tables of formulas to calculate the data. This course will teach analysts how to set up a Microsoft Access database that they can put their data into. Then, we will practice creating a report template with automatically updating formulas that pull from the Access database created. The bulk of the class will focus on how to create and update the formulas for their own use cases. This creates a report that will be automatically refreshed on a regular basis (whenever the analyst updates the data), and can be easily exported into a polish, completed format. Analysts will also leave with reports templates that they can customize for future use.

Seating is limited to the first 500 attendees. For further details on recording, certificates/CEUs and other registration info, please visit this page. Registration is now open!

If you have questions about the webinar program, please view our FAQs page or email [email protected].

Contact: [email protected]