top of page

Simplifying Financial Records

How to Obtain, Review & Present Financial Records

  • From 125 US dollars
  • Independence Event Center, 555 S. Main St, Independence, OR 97351

11 spots left

Class Overview

Target Audience: Law Enforcement & Regulatory Specialists Sponsoring Agency: Oregon DOJ, Independence PD & OPOA Two-Day Couse: June 5-6, 2024, 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 – (Leila Gharani) - Registration Information: Kim Dorn,, 503-586-8828

Class Dates

Contact Details

4190 Aumsville Highway Southeast, Salem, OR, USA

bottom of page