Simplifying How to Obtain, Review, and Present Financial Records

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:

Sponsoring Agency:

Oregon Department of Justice, Bend Police Department and OPOA

Date and Time:

Cost:

$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

Instructors:

Oregon DOJ Financial Crimes Team

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:

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

Attire: