About this Event
Are you good with Microsoft Excel but want to become an expert user, especially as it applies to law enforcement scenarios? Maybe you want your LE career to shift towards an investigative division, crime center, or senior analyst role. Regardless, if you want to improve your LE Excel skillets, register for this course so you can develop, hone, or maintain your expertise analyzing investigative and crime situations faced by law enforcement practitioners, from detectives to chiefs and everything in between.
We'll visualize datasets and learn how to answer popular questions detectives need answered pertaining to cell phone records, tower data, and bank records.
We’ll show how to analyze big-picture crime data so LE executives become fluent in and understand, with more depth, the crime patterns and trends affecting the community.
Most officers and investigators are stripped of, or left without, sophisticated computer software because of pricy annual subscriptions. However, Microsoft Excel offers extraordinary functions to help crime fighters analyze and visualize complex data. Come see how during this two-day course.
If time permits, we might even demonstrate or survey how to structure and manage datasets such as lead tracking and caseloads. We might even preview how to structure relationship data more in-depth for importation into link analysis visualizers like i2.
INSTRUCTOR: James Ward has been an intelligence analyst for over 20 years and has: convinced a district attorney to accept M**der charges based on pinpointing togetherness using geospatial data from Excel, helped persuade a defense attorney to take a plea resulting from cell phone analysis, analyzed bank and other records related to terrorism investigations, uncovered serial rapists, and helped numerous investigators solve other data analysis problems and following money trails--all in Excel.
TAKEAWAYS: Learn data analysis techniques in order to:
- Analyze phone records
- Analyze bank records
- Analyze cell tower data
- Visualize Excel location data geospatially
- Discover hidden trends or linkages
IMPORTANT: Some state agencies require webcams for their police officers to obtain educational credit . This course will be a live online training course via Zoom (instructions on how to join will be e-mailed upon registering for the course). Check with your state if they have particular requirements for you to obtain LE credit when attending. Texas, for example, requires webcams.
SHOULD I TAKE PART 2 IF I HAVEN'T TAKEN PART 1 YET? Part 2 is suitable for those familiar with Excel basics. If you’re starting from scratch, start with Part 1 to learn the essentials. However, if you’ve used Excel for a year, know basic functions, and learn quickly, you may directly join Part 2. It’s designed to be beneficial regardless of sequence, but beginners are encouraged to begin with Part 1 to avoid feeling overwhelmed.
HOW MUCH DO TICKETS COST? Prices vary from $319.99 to $419.99. From the flyer's webpage, click the orange Get Tickets button to see the current pricing time period.
GROUP DISCOUNT? Yes! If a department registers ten or more employees in a single order, input promo code GroupDiscount to get 10% off the purchase.
WHAT TO BRING? Since this course is taught online via Zoom, you must have access to a device with an internet connection and Microsoft Excel (video participation is mandatory for some LE agencies). A monitor (preferably two but one is okay), keyboard, and mouse are required. Headsets are highly recommended. The entire course is hands-on with excel scenarios for students to follow-along in order to practice and gain proficiency. Mac users will be able to participate in most exercises as well. A cell phone is not an appropriate medium to attend this course.
ACCREDITED? Yes. James is a accredited through the U.S. Department of Homeland Security and Texas Commission on Law Enforcement as a certified instructor. Check with your state's law enforcement training division if you seek educational credit.
WHO CAN (AND CANNOT) ATTEND? You can register if you are a police officer, detective, analyst, or an employee of the prosecutorial criminal justice system (no non-government, public sector employees, or private defense firms). Furthermore, the following eligibility criteria is required. And if you believe you may qualify for a waiver, please contact the instructor. The above eligible attendees must be an employee of a state or local (not federal) government agency who is not 1) seeking official action from, 2) or doing business with, 3) or conducting activities regulated by U.S. Immigrations and Customs Enforcement, 4) or having interests that may be substantially affected by the performance or nonperformance of James Ward's duties with ICE.
WHERE? The training event will be held online via Zoom.
See you at the training event!
Event Venue
Online
USD 319.99 to USD 419.99