Microsoft Excel to Enhance Analytical Support

In this interactive course participants learn how to leverage Microsoft Excel to conduct intelligence analysis and progress intelligence operations.

2 day course

Learning Outcomes

Functionality icon

Functionality

Know the core functionality of Microsoft Excel

Formulae icon

Formulae

Utilise a range of formulae and functions in order to format, organise, and manipulate operational datasets

Pivot tables icon

Pivot tables

Know how to use pivot tables to analyse a range of data including communications data

Vlookup icon

Vlookup

Utilise Microsoft Excel VLOOKUP functionality

Analytical icon

Analytical

Utilise Microsoft Excel as an analytical tool to assist operational decision making

Reporting icon

Reporting

Present complex datasets in a clear and concise manner using the reporting capabilities of Microsoft Excel