Financial Analysis using Excel

Course start dateSaturday, 9 May 2020

For most investigators, Excel is the tool of choice for analysing financial information. This course equips you with the skills to efficiently organise and analyse large datasets, including banking records, invoices, phone records, and commercial transactions.

What You Will Learn

Take your skills to the next level by mastering how to:

Protect your data from accidental changes
Use simple functions to identify unusual transactions
Unlock the power of filters to quickly find relevant data
Use subtotals to instantly summarise financial information
Create interactive summaries with PivotTables

Additionally, you will gain insights into common patterns of illegal use of bank accounts, allowing you to further refine your financial data analysis techniques.

Course Format

Self-paced: Learn at your own convenience.
Structured sessions: Designed to build on each other—start with Session 1 for the best experience.
Recommended device: Laptop or desktop for optimal learning.

Who Should Take This Course?

Financial investigators
Intelligence analysts
Law enforcement officers
Compliance officers
Anti-money laundering (AML) professionals

Prerequisites

Basic knowledge of Excel is recommended but not required.

Duration

9 sessions, approximately 3 hours of learning time

Languages

English, Español, Português, Український, български, Srpski, Shqip, Românesc, Vietnamese

Enrolment options

Self-paced eLearning

Course name Financial Analysis using Excel

For most investigators, Excel is the tool of choice for analysing ...