Log in

Simplifying How to Obtain, Review, and Present Financial Records

  • August 22, 2023
  • 8:15 AM
  • August 23, 2023
  • 5:00 PM
  • Keizer Police Department, 930 Chemawa Rd NE, Keizer, OR 97303
  • 11


Registration is closed

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:

** Sworn Law Enforcement Only **

Sponsoring Agency:

Oregon Department of Justice, Keizer Police Department and OPOA

Date and Time:

August 22-23, 2023, from 8:15 a.m. to 5:00 p.m. (8:00 a.m. check-in)


$125 OPOA Members

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

Training Location:

Keizer Police Department

930 Chemawa Rd NE

Keizer, OR 97303


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.
Covid Information: Covid procedures will be followed.

Class Requirements:

  • Familiarity of Excel is REQUIRED

  • Laptop with Excel 2016 or newer

  • Laptop power cable

  • Mouse

  • Extra monitor or screen (if available)

  • LE Credentials must be displayed while in the building

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