Overview

Target Audience: Law Enforcement & Regulatory Specialists Sponsoring Agency: Oregon DOJ, Lincoln City PD & OPOA Two-Day Course: May 15 - 16, 2025 from 8:15am - 5:00 pm daily Non-member cost includes 1 year of OPOA Membership for qualified applicants. Course Overview: Instructors will lead students in hands-on training in Microsoft Excel to review bank records from a real elder financial abuse case. Students will learn tips and tricks in Excel to maximize the evidence in their financial investigations as well as learn how to present their findings to a prosecutor with simplified summaries of the financial records. Obtaining Financial Records: * Methods to locate financial accounts * Identifying the correct legal process to obtain financial records * Templates of subpoenas, search warrants, and other forms will be provided Review Financial Records: * Import records into Microsoft Excel using Bankscan * Normalizing/categorizing transactions on the accounts to better under spending patterns as well as identify illicit activity Presenting Financial Records: * Incorporating data from Excel into police reports * Using data to create valuable exhibits (Pivot Tables, graphs, charts, etc.) Instructors will also discuss nuances in elder financial exploitation cases and support services offered to law enforcement by DOJ investigators and analysts. Class Requirements: Familiarity of Excel is REQUIRED Laptop with Excel 2016 or newer Laptop power cable, mouse, extra monitor or screen (if available) Class Prep Course: NW3C Basic Level Spreadsheeting Skills Class – Virtual Classroom 06/21/23 Excel Campus – www.youtube.com/@ExcelCampus Xelplus.com (Leila Gharani) - www.youtube.com/@LeilaGharani Registration Information: Kim Dorn, training5@opoa.info