Session 4: Using filters to analyse account statements

Learning goals: Filters allow you to find exactly the information you are looking for in a large data set.
Duration approx. 10 minutes.
Prerequisits: Sorting deposits and debits

Session 3: Sorting deposits and debits

Learning goals: Sorting tables is a basic function of Excel which allows you to quickly show the highest amounts of incoming and outgoing money.
Duration approx. 15 minutes.
Prerequisits: Prepare the analysis

Session 2: Prepare the analysis

Learning goals: In this session you will prepare the documents we are going to analyse to protect them from accidental changes.
Duration approx. 10 minutes.
Prerequisits: None

Session 1: Introduction

Learning goals: Benefits of analysing financial data using Excel
Duration approx. 5 minutes.
Prerequisits: You know how to use the course

Session 1: Intro: Why to use Source and Application?

Learning goals: See the benefits the "Source & Application" method offers
Duration approx. 10 minutes.
Prerequisits: none

Session 14: Visual reports

Learning goals: Visually presenting your information helps to clarify data describing multiple relationships among people, organizations and/or other entities. A chart will allow you to identify gaps, leads and present a graphic representation of a case.
Duration approx. 20 minutes.
Prerequisits: Session 13: Reporting

Session 13: Written reports

Learning goals: The aim of this session is to equip the analyst with the tools to present intelligence findings effectively. In the first part of the reporting session participants learn to present the results of an analysis in a clear written report.
Duration approx. 20 minutes.
Prerequisits: Module 4: Evaluation, collation, analysis

Session 12: Analysis

Learning goals: Learn that a good understanding of the information collected so far is the basis to find gaps and to analyse the information. Create premises that lead to an inference. Construct the argument that supports your inference.
Duration approx. 35 minutes.
Prerequisits: Session 11, Collation of information


Subscribe to RSS