Log in

*Cancelled* Simplifying How to Obtain, Review, and Present Financial Records

  • October 17, 2023
  • 8:15 AM
  • October 18, 2023
  • 5:00 PM
  • Bend Police Department, 555 NE 15th St, Bend, OR 97701
  • 20


Class Title:

Simplifying How to Obtain, Review, and Present Financial Records

Please Note: This class will feature intermediate level Microsoft Excel skills.  However, those with solid basic skills can still attend.  See Class Requirements below.

Target Audience:

Law Enforcement

Sponsoring Agency:

Oregon Department of Justice, Bend Police Department and OPOA

Date and Time:

October 17-18, 2023, from 8:15 a.m. to 5:00 p.m. (8:00 a.m. check-in)


$225 OPOA Members

$250 Non-members  (Includes 1-year OPOA membership for qualified applicants) 

Training Location:

Bend Police Department

555 NE 15th St

Bend, OR 97701


Oregon DOJ Financial Crimes Team

DPSST Category: Investigations, General

Brief 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.

Contact Information:

Kim Dorn at (503) 586-8828 or training5@opoa.info.

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 Courses:

  • 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


Business casual.

Upcoming events

Oregon Peace Officers Association
4190 Aumsville Highway SE | Salem, OR 97317

Email:  opoa@opoa.info
Powered by Wild Apricot Membership Software