Microsoft Excel for Law Enforcement (MS-E for LE) - Masterclass
When information and data is overloading you and you don't know what to do with it, Microsoft Excel can help ease the burden. Did you know that Excel can be used to...?:
- Understand the crime environment
- Identify hot spots
- Enhance investigations
- Analyze cell phone data
- Keep communities safe
What will you learn:
What will you learn:
In this IADLEST-NCP certified masterclass is specifically designed to teach you the fundamental and advanced functionalities of Microsoft Excel and how to leverage these for gathering, structuring, analyzing, and presenting large datasets. By the end of the course, you will be able to exploit large data-sets and manage your information, making it easy for you to make the most of data and generate reports and presentations at the strategic, operational and tactical levels. Start learning now.
Why and how data can be used in the law enforcement environment
The structure of essential functionalities of Microsoft Excel
How to create a case log spreadsheet for criminal investigations
How to work with large datasets to organize and present data
How to use Microsoft Excel to analyze telephone data
How to use Excel for storing and downloading data from the Internet
Excel’s powerful PivotTable and PivotChart functionality to gain insights about your data to inform and drive decisions and reporting
Criminal intelligence techniques to compare multiple data sources to reveal critical information
Analyze and map crime data
Frequently asked questions
What will I need for the course?
1. A desktop or a laptop
2. Microsoft Excel installed on your computer
3. Google Earth Pro (free) installed on your computer
How many sections are in the course?
The course is divided into eight sections.
Can I complete the course at my own pace?
The course is completely asynchronous and can be completed at one's own pace. Each course registrant will have access to the course for 2 years, allowing them to go back and review any section again during that time and at their own convenience.
Is this course certified?
Yes, this course has been awarded the IADLEST-NCP seal and counts towards five hours of in-service training in 36 States. You can find more information about the certification on the IADLEST National Certification Program website. https://iadlest-ncp.org/