Learn how to get the best out of Excel when working with communications data, ANPR, and other complex data files.

1 day
£425.00 excl. VAT

1 day, 09:00 AM - 05:00 PM

Online

Session information

Sessions

Session 1
09:00 GMT - 17:00 GMT
1 day
    • £425.00 excl. VAT

    Description

    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.