Learn how to get the best out of Excel when working with communications data, ANPR, and other complex data files.
Comms data analysis is much more efficient and effective when the analyst has received instruction in using Microsoft Excel to quickly normalise and analyse data. This course has been designed by experienced communications data analysts.
Topics: Concatenating text / splitting text, Count and Countif functions, Vlookups, Pivot tables, Conditional formatting, Inserting columns and rows Simple and complex filters. Macros.