The overall aim of the Investigation Toolkit is to successfully convert different bank statements into a consistent format in Excel. This contains the following objectives: 

- To understand and practise using the 7 gridding steps on a variety of bank statements 
- To understand and practise using the 'Recognise Bank Statement' feature and save on conversion time 
- To be able to find out why errors occur in Excel and how to fix them
- To successfully upload a bank statement into Excel using the Data Loader feature

Training to get you up to speed on converting paper-based information into Microsoft Excel

Financial Investigation Toolkit: Toolkit Training (session 1/2) 

Question 1

What is the name of your organisation? 

The overall aim of the Financial Analysis Toolbar is to be able to merge different bank statements and analyse the multiple bank statements as a whole. This contains the following objectives: 

- To successfully merge 5 different bank statements into a master spreadsheet in Excel 
- To learn how to set up new rule files and batch rule files in pattern manager to categorise data 
- To practice using the easy pivot table feature to analyse data visually 
- To have a basic overview of the different quick reports available and an understanding on how to produce them 
- To learn how to match transactions and save time looking for trends within the data 
- To be able to calculate historical and adjusted inflation values with one click 
- To be able to convert currency with one click 
- To be able to redact/ permanently hide personal information within an Excel spreadsheet 

This session will guide you through the analytic tools available on the software

Financial Investigation Toolkit: Toolbar Training (session 2/2)

If you need to cancel your session, please email: training@altiaintel.com

Sign up to the Altia newsletter to occasionally receive news, promotions and event information. You can unsubscribe at any time.

Altia

From managing risk, right through to solving and prosecuting crimes, our intelligence and investigation tools help teams work together, improve their processes, get the most out of data and improve insight in order to drive results and change.

We look forward to meeting you in your training sessions. Find out more about us and the products that Altia has to offer. 

About us

We’d love to hear from you. Please use the form below or send us an email. 

Get in touch

Welcome to our online booking system where you can book your training sessions, complete your pre-training and find out more about what to expect on the day. If you have any questions, please visit our contact page. 

Welcome to Altia Training 

Financial Investigator: Bringing you a web accessible investigation toolkit with more powerful insight and interactive dashboards. Financial Investigator gives you access to valuable financial data all in one place.

Financial Investigation Toolkit: Financial analytics and analysis, combined with forensic accounting. Fully automate the process of converting paper-based information, and analysing it to identify entities, trends, relationships and investigative avenues.

Products 

Please click on the events below to complete your mandatory pre-training and find out more about what to expect on the day of your session.

Please use the timetable below to book yourself and your team in for training. You should always book your Toolkit training BEFORE your Toolbar training. 

If your team require temporary training licences for your sessions, please email training@altiaintel.com with at least 1 week's notice so that this can be arranged. 

Please note that other organisations may join onto your sessions unless otherwise requested. 


Welcome to Altia Training

Our events

Our events

Our events