Law enforcement investigators, prosecutors, and forensic examiners are
having to process increasingly larger datasets to find evidence relevant to their
investigations. In response to search warrants companies often respond with records in
.csv, .tsv and other delimited formats which can be difficult to interpret.
However most law enforcement have a tool that can make life much easier when
faced with large data sets. Microsoft Excel is perhaps one of the most
underrated forensic and investigative tools.
Excel enables user's to sort, organize,
filter, simplify, normalize and format data. User's can convert between time
zones, or quickly find information that appears most frequently. Data can be
conditionally formatted to highlight the most important information.
This course is designed to teach investigators, prosecutors and forensic examiners who have a basic understanding of Excel the tips, tricks and tweaks that will make their investigations more efficient and more effective.