Harnessing the power of Microsoft Excel® to better manage data & improve investigations.
Course Overview
Microsoft Excel® for Public Safety™ is designed to help public safety personnel best utilize Microsoft Excel ® to successfully manage law enforcement specific data. Whether it is case specific data (e.g. telephone tolls, financials) or agency-wide data (e.g. arrest stats, fugitive lists, calls for service), it can be analyzed with just a few clicks using this powerful tool!
Who Should Attend
This course is intended for law enforcement personnel, which includes: any sworn officer, support staff, administrative personnel, Supervisors and Management. Attendees need only a basic understanding of computers and Excel®. No technical or analytical background is required.
Material Requirements
Students should bring a laptop with Microsoft Excel (version 2003 or higher). Additional materials (data sets) will be provided to students.
Agenda
Day One
- Uses in Law Enforcement - Telephone tolls; Financial analyses; Agency stats
- Navigation & Manipulation - Rows, columns, cells, ranges, worksheets
- Tools - Autofill, conditional formatting
- Simple formulas - Sum, Average, Median, Mode, Crime Rate and more
- Complex formulas - Date conversion to days of week, months of year
- Concatenating - Combining data stored separately
|
Day Two
- Parsing - Separating data using Text to Columns
- Best Charting practices - Bar, columnar, and pie chart usage; proper use of data labels, legends, gridlines etc.
- Why you should never chart in 3-D
- Importing/Exporting - Linking data between products
- Data Validation - Creating pull-down lists to give forced options
- The three analytical tools you must know - Sorting, filtering, & the magic of Pivot Tables
|
Peggy Pingel
Peggy Pingel is the Analyst for the ID Theft/Financial Fraud and Cyber Crime Unit at the Colorado Bureau of Investigation. Her main duties are investigative support for the cases in the unit. The cases range from standard credit ID theft to business ID theft, business e-mail compromise and wire fraud all the way to organized crime groups stealing mail and using the information for synthetic identity fraud. This unit has filed multiple successful cases and obtained convictions under the Organized Crime statutes.
Prior to starting at CBI, Peggy was a mortgage loan officer. With a total of 35 years in mortgage banking, she worked her way through nearly every position within the mortgage company. Her last 15 years were spent as a loan officer. Her responsibilities were analysis of all aspects of an applicant’s financial situation. This included taxes, bank statements, cash flow, assets, and liabilities.
It was her mortgage expertise that was her ticket to the CBI as they were participating in a Mortgage Fraud Task Force in 2011 when she started. This allowed her to be a contributing part of the team while she learned the criminal justice side.
Because of her sales background, Peggy has always contributed to the community outreach at CBI. She has done training for high school students, real estate groups, community service groups and senior associations. This outreach is designed to assist these groups in identifying and therefore not falling for current scams and how to keep their information safe.
Peggy is a Certified Fraud Examiner, a Criminal Intelligence Certified Analyst and a Certified Economic Crime Forensic Examiner.
Host: POLICE TECHNICAL
Location: Online Seminar 647 Ohio Street Online Seminar, 47807 Get Directions
Recommended Hotels:
No recommended hotels provided.