Microsoft Excel for Law Enforcement (MS-E for LE) - Excel 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:

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.

Write your awesome label here.

THE MASTER CLASS

Boost your confidence, master the field, become a nationally certified professional. Learn to use Microsoft Excel data analysis tools, walk into a job and be a rockstar from day one. The skills you need to become a data crime fighter!

Write your awesome label here.

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/