Harnessing the Power of Microsoft Excel to Better Manage Data & Improve Investigations
Course Overview
Microsoft Excel® for Public Safety™ is designed to help public safety personnel best utilize Microsoft Excel ® to successfully manage law enforcement specific data. Whether it is case specific data (e.g. telephone tolls, financials) or agency-wide data (e.g. arrest stats, fugitive lists, calls for service), it can be analyzed with just a few clicks using this powerful tool!
Who Should Attend
This course is intended for law enforcement personnel, which includes: any sworn officer, support staff, administrative personnel, Supervisors and Management. Attendees need only a basic understanding of computers and Excel®. No technical or analytical background is required.
Material Requirements
Students should bring a laptop with Microsoft Excel (version 2003 or higher). Additional materials (data sets) will be provided to students.
Agenda
Day One
- Uses in Law Enforcement - Telephone tolls; Financial analyses; Agency stats
- Navigation & Manipulation - Rows, columns, cells, ranges, worksheets
- Tools - Autofill, conditional formatting
- Simple formulas - Sum, Average, Median, Mode, Crime Rate and more
- Complex formulas - Date conversion to days of week, months of year
- Concatenating - Combining data stored separately
|
Day Two
- Parsing - Separating data using Text to Columns
- Best Charting practices - Bar, columnar, and pie chart usage; proper use of data labels, legends, gridlines etc.
- Why you should never chart in 3-D
- Importing/Exporting - Linking data between products
- Data Validation - Creating pull-down lists to give forced options
- The three analytical tools you must know - Sorting, filtering, & the magic of Pivot Tables
|
Nicole McKendree
Nicole McKendree is a seasoned law enforcement analyst and instructor with over a decade of experience spanning patrol, criminal intelligence, and analytical training. She currently serves as a Criminal Intelligence Analyst for the Arkansas Department of Corrections within the Arkansas State Fusion Center, where she focuses on gangs, fugitives, high-risk offenders, and intelligence support for local and national law enforcement partners.
Nicole’s career began in uniformed patrol with the Conway Police Department and Pulaski County Sheriff’s Office, where she later became the agency’s first full-time Crime Analyst. She went on to serve as Senior Intelligence Analyst with the Arkansas State Police, leading tactical, strategic, and administrative analysis projects, producing threat assessments, and providing operational intelligence for major events and investigations.
An accomplished educator, Nicole teaches through Police Technical, specializing in Microsoft Excel for law enforcement, mapping, critical thinking, and i2 Analyst’s Notebook. She also serves with the National Criminal Justice Training Center of Fox Valley Technical College, expanding her reach to public safety professionals nationwide. In addition, she founded Consultalytics to provide analyst training, consulting, and mentorship, helping agencies optimize their data-driven decision-making.
Nicole holds a Master of Science in Criminology – Homeland Security from Texas A&M University–Commerce and a Bachelor of Science in Sociology–Criminology from the University of Central Arkansas. Her credentials include IBM i2 Analyst’s Notebook certification, Basic Analyst Certification, DDACTS Analyst Certification, and Basic Peace Officer Certification. She has been recognized with honors such as the NNFC Southern Shield Analyst of the Year and the NARCAN Life Saving Award.
Passionate about empowering public safety professionals, Nicole combines her operational experience with advanced analytical skills to deliver engaging, practical, and results-oriented training that prepares students to excel in real-world law enforcement and intelligence environments.
Host: POLICE TECHNICAL
Location: Online Seminar 647 Ohio Street Online Seminar, 47807 Get Directions
Recommended Hotels:
No recommended hotels provided.