This one-day course provides foundational spreadsheeting knowledge and skills to enhance workplace productivity. The course covers basic navigation of Microsoft Excel by combining live demonstrations and hands-on exercises.
Work with multiple worksheets within a workbook
Hide, unhide, and protect worksheets
Adjust rows and columns
Use copy and paste options
Find, select, and sort data
This course introduces the problem of intellectual property theft and provides tools, techniques, and resources for investigating and prosecuting these crimes. A combination of lecture, discussion, and interactive exercises illustrates the potential dangers and economic repercussions of counterfeit products, as well as best practices and techniques for investigating IP theft. Students are provided with a state-specific folder that includes relevant statutes, sample organizational documents for IP investigations, and additional resources for investigators and prosecutors.
This course is presented in collaboration with the National Association of Attorneys General (NAAG).
Awareness. Types of IP crimes. The criminals who commit these crimes. Impacts and dangers.
Investigation. Online and traditional techniques. Working with brand experts and the private sector. Large amounts of evidence. Resources.
Statutes. Prosecutorial theories. State-specific discussion.
Hands-on experience. Work with real counterfeit products. Identify fakes with expert guidance.
This course builds on the concepts introduced in FC101 (FIPS) and FC105 (FREA), introducing investigators and prosecutors to emerging issues in financial crime. Topics include money laundering, analyzing large financial data sets, conducting effective interviews, and managing large amounts of financial evidence. This course consists of a mix of lecture, discussion, and hands-on exercises. Students conduct a mock investigation that includes interviews, data analysis, and the examination of various documents.
*Money laundering. Methods of laundering money. Tracing illegal funds. Emerging issues. FinCEN.
*Spreadsheeting skills. Spreadsheet architecture. Formulas and calculations. Pivot tables.
*Working with financial data. Benfords law analysis. Disentangling commingled funds.
*Hands-on experience. Work a mock financial case as part of an investigative team.
This course covers the acquisition, examination, and analysis of many types of financial records, including bank statements and checks, wire transfer records, and business records. Topics include recognizing and investigating common indicators of fraud, using spreadsheets to facilitate analysis and pattern recognition, and financial profiling. There is a strong focus on presenting financial evidence in multiple modalities: spreadsheet data outputs, graphic representations, and written/oral presentations.
*Introduction to analysis. Best practices. Finding patterns. Indicators of fraud. Presenting your findings.
*Financial records. Bank records. Business documents.
*Financial profiling. Methods of profiling. Reasons to create a profile. Creating a profile.
*Hands-on experience. Work a mock financial case as part of an investigative team.
In 2011, FBI agents were concluding a routine liaison visit with officials at DuPont Pioneer's offices near Des Moines, Iowa when one of the agents asked if company officials had any unusual activity recently. Specifically, they were looking for anything that may involve targeting the company's intellectual property (IP). The company official subsequently detailed a recent incident where an Asian male had been found digging in one of their grower fields. Grower fields operate like laboratories where companies can test their products. This happenstance piece of information from a routine public/private sector outreach meeting would eventually lead agents on cat-and-mouse surveillance operations across the Midwest. It took them on a deep dive into the biotechnology of proprietary corn breeding. The case was dubbed "Operation Purple Maze," which was a successful Economic Espionage/Theft of Trade Secrets cases involving the theft of bio-engineered corn seed. Omaha FBI SA Militello will discuss the liaison between the FBI and private industry and their techniques and processes related to suspected IP theft investigations.
Presented by:
Special Agent, Byron Militello, Omaha FBI Field Office, Des Moines Resident Agency
Join experts from NW3C and the National Network of Fusion Centers as they provide thoughtful and detailed answers to the intelligence analysis questions you submit. In this session, our panel has a wealth of experience with managing intelligence analysts and intelligence projects. This panel will provide perspectives from large and smaller intelligence units at the local and state law enforcement levels. Click here to submit questions regarding intelligence analysis skills, analyst and project management, information collection, or general comments of analytic tradecraft and the NW3C experts will provide answers during this live session.
Presented by:
Heaven Henwood, Law Enforcement Supervisor
Scott Faralli, Director
Devon Rhoads, Assistant Director
Justin Parker, Training Manager
NW3C does not share attendees' personally identifiable information with any third party without opt-in consent given during registration.
The content, views, and opinions expressed in this presentation are those of the individual presenters and do not represent official policy, opinions, or view of NW3C.
In this orientation webinar, CSG Justice Center and Bureau of Justice Assistance (BJA) staff provided newly awarded Justice and Mental Health Collaboration Program (JMHCP) and Connect & Protect grantees with an overview of BJA, the CSG Justice Center, the program budget, the JustGrants management system, and the performance measurement tool (PMT). Speakers included: Tammy Lovill, State Policy Advisor, JMHCP, Bureau of Justice Assistance, Office of Justice Programs, U.S.
In this orientation webinar, CSG Justice Center and Bureau of Justice Assistance (BJA) staff provided newly awarded Justice and Mental Health Collaboration Program (JMHCP) and Connect & Protect grantees with an overview of BJA, the CSG Justice Center, the program budget, the JustGrants management system, and the performance measurement tool (PMT). Speakers included: Tammy Lovill, State Policy Advisor, JMHCP, Bureau of Justice Assistance, Office of Justice Programs, U.S. Department of Justice; Aja C.
In this webinar, CSG Justice Center and Bureau of Justice Assistance (BJA) staff provided newly awarded grantees with an overview of BJA, the CSG Justice Center, behavioral health diversion and reentry strategies, the Justice and Mental Health Collaboration Program (JMHCP), Connect & Protect (C & P), and training and technical (TTA) assistance. Staff also gave critical context about people with behavioral health needs in the criminal justice system.
In this webinar, CSG Justice Center and Bureau of Justice Assistance (BJA) staff provided newly awarded grantees with an overview of BJA, the CSG Justice Center, behavioral health diversion and reentry strategies, the Justice and Mental Health Collaboration Program (JMHCP), Connect & Protect (C & P), and training and technical (TTA) assistance. Staff also gave critical context about people with behavioral health needs in the criminal justice system.