EXCEL TECHNIQUES FOR LAW ENFORCEMENT
72 views
Skip to first unread message
Glen Mills
Aug 10, 2011, 12:48:56 PM8/10/11
to Masspolice, Masspolice, maca-l
----- Forwarded message -----
To: "Glen Mills" <gam...@bpd.org>
Subject: EXCEL TECHNIQUES FOR LAW ENFORCEMENT
To: "Glen Mills" <gam...@bpd.org>
Subject: EXCEL TECHNIQUES FOR LAW ENFORCEMENT
EXCEL TECHNIQUES FOR LAW ENFORCEMENT
Hosted by the NE Chapter of IALEIA
September 26-28, 2011
Excel is one of the most powerful analytical tools available to law enforcement and it is usually sitting right on your computers' desktop. In this class Leonard Leedy will cover basic Spreadsheet functions, Pivot Tables, Auto Filters, and numerous “tricks” acquired from his 20 years of training people how to use this powerful tool. Learn how to break down 10 or 20 thousand records in just 5 mouse clicks and provide meaningful analytical reports to your agency. Are you a more experienced user doing the same thing over and over in Microsoft Excel? Would you like to learn how to automate those repetitive tasks? Mr. Leedy will also cover how to create Macros that automate those tasks, modifying the ‘Quick Access Bar' in Excel 2007 & 2010, and creating Custom Menus in Excel 2003 & 2010 (unavailable in 2007 version).
WHO SHOULD ATTEND: Law Enforcement Officers, Intelligence Analysts, Crime Analysts
TUITION: $200.00 per person, or $150.00 per person for agencies registering more than one person (Includes student manual). Class Limited to 30.
TO REGISTER: See Instructions below
INSTRUCTOR: Lenny Leedy
Leonard has twenty-five years of varied Law Enforcement experience including Uniform, K-9, SWAT, Vice and Narcotics. He retired in June 1999 and now is:
• An instructor and course developer for the Federal Law Enforcement Training Center.
• An instructor and course developer for Multijurisdictional Counterdrug Task Force Training He instructs in Analytical Investigative Techniques I & II, Intercept of Secure Communications, Conspiracy Investigations, and Drug Task Force Investigations at St. Pete Junior College since 1995.
• An authorized reseller for Law Enforcement Investigative software developed by ACISS Systems.
• He was the course developer and primary instructor for Basic Analytical Techniques for Law Enforcement (BATLE) I and II for the Northeast Counter Drug Training Center at Fort Indiantown Gap PA.
• Adjunct Instructor for the University of Tennessee.
• Owner of Law Enforcement Consulting Inc.
During the last 13 years of his career he worked in the Vice & Narcotics Unit, assigned to the Strategic Investigative Squad. His primary responsibilities involved managing all DNR's and the computerization of the Vice and Intelligence Units. He also was responsible for Technical Surveillance Equipment installation. He specialized in the Collection and Analysis of Computerized Data. He has developed many automated data analysis functions. He was the System Administrator for the ACISS software that completely automated the Intelligence, Vice and Narcotics sections.
Leonard has a BS degree in Marine Science from the University of West Florida. He also has Certificates from St. Petersburg Junior College for:
• Internetworking Support Technician
• Webmaster
He received an Law Enforcement Instructor Certification from the State of Florida Commission on Criminal Justice Standards and Training.
LOCATION: NESPIN, 124 Grove St., Ste. 105, Franklin, MA 02038
DATE: September 26-28, 2011
TIME: 8:30 a.m. to 4:00 p.m.
Registration Form
REGISTRATION IS REQUIRED
Please register only if you are very confident you can attend. Failing to show up for training once you are registered may cause others to miss this important opportunity. If you are unable to attend, please notify us as soon as possible so that your seat can be filled by another student.
Name______________________________________________Rank_______________________
(Please print legibly)
Agency_______________________________________________________________________
Address______________________________________________________________________
City/State/Zip__________________________________________________________________
Telephone #____________________________________________________________________
*Email Address:_________________________________________________________________
(mandatory) (Please print legibly)
COST: $200.00 or $150.00 payable to IALEIA/Kerry McCartney
Payment due by September 16, 2011
(Meals and hotels are attendees' responsibility)
CONTACT: Rick Flood, Training Coordinator at 800-343-5682 x 217, or Cara Graham, NE IALEIA Chapter President, at x207.
REGISTER VIA: Fax: 508-528-5184
Mail: 124 Grove St., Ste. 105, Franklin, MA 02038
E-mail: Trai...@nespin.riss.net
*You will be notified by E-mail if you are in the class. For security reasons, only those individuals having a confirmed advance registration will be admitted to the training. Departmental identification will be required at check-in.
----------------------------------------------------------------
Please do not reply to this e-mail as it is an unmonitored alias.
Hosted by the NE Chapter of IALEIA
September 26-28, 2011
Excel is one of the most powerful analytical tools available to law enforcement and it is usually sitting right on your computers' desktop. In this class Leonard Leedy will cover basic Spreadsheet functions, Pivot Tables, Auto Filters, and numerous “tricks” acquired from his 20 years of training people how to use this powerful tool. Learn how to break down 10 or 20 thousand records in just 5 mouse clicks and provide meaningful analytical reports to your agency. Are you a more experienced user doing the same thing over and over in Microsoft Excel? Would you like to learn how to automate those repetitive tasks? Mr. Leedy will also cover how to create Macros that automate those tasks, modifying the ‘Quick Access Bar' in Excel 2007 & 2010, and creating Custom Menus in Excel 2003 & 2010 (unavailable in 2007 version).
WHO SHOULD ATTEND: Law Enforcement Officers, Intelligence Analysts, Crime Analysts
TUITION: $200.00 per person, or $150.00 per person for agencies registering more than one person (Includes student manual). Class Limited to 30.
TO REGISTER: See Instructions below
INSTRUCTOR: Lenny Leedy
Leonard has twenty-five years of varied Law Enforcement experience including Uniform, K-9, SWAT, Vice and Narcotics. He retired in June 1999 and now is:
• An instructor and course developer for the Federal Law Enforcement Training Center.
• An instructor and course developer for Multijurisdictional Counterdrug Task Force Training He instructs in Analytical Investigative Techniques I & II, Intercept of Secure Communications, Conspiracy Investigations, and Drug Task Force Investigations at St. Pete Junior College since 1995.
• An authorized reseller for Law Enforcement Investigative software developed by ACISS Systems.
• He was the course developer and primary instructor for Basic Analytical Techniques for Law Enforcement (BATLE) I and II for the Northeast Counter Drug Training Center at Fort Indiantown Gap PA.
• Adjunct Instructor for the University of Tennessee.
• Owner of Law Enforcement Consulting Inc.
During the last 13 years of his career he worked in the Vice & Narcotics Unit, assigned to the Strategic Investigative Squad. His primary responsibilities involved managing all DNR's and the computerization of the Vice and Intelligence Units. He also was responsible for Technical Surveillance Equipment installation. He specialized in the Collection and Analysis of Computerized Data. He has developed many automated data analysis functions. He was the System Administrator for the ACISS software that completely automated the Intelligence, Vice and Narcotics sections.
Leonard has a BS degree in Marine Science from the University of West Florida. He also has Certificates from St. Petersburg Junior College for:
• Internetworking Support Technician
• Webmaster
He received an Law Enforcement Instructor Certification from the State of Florida Commission on Criminal Justice Standards and Training.
LOCATION: NESPIN, 124 Grove St., Ste. 105, Franklin, MA 02038
DATE: September 26-28, 2011
TIME: 8:30 a.m. to 4:00 p.m.
Registration Form
REGISTRATION IS REQUIRED
Please register only if you are very confident you can attend. Failing to show up for training once you are registered may cause others to miss this important opportunity. If you are unable to attend, please notify us as soon as possible so that your seat can be filled by another student.
Name______________________________________________Rank_______________________
(Please print legibly)
Agency_______________________________________________________________________
Address______________________________________________________________________
City/State/Zip__________________________________________________________________
Telephone #____________________________________________________________________
*Email Address:_________________________________________________________________
(mandatory) (Please print legibly)
COST: $200.00 or $150.00 payable to IALEIA/Kerry McCartney
Payment due by September 16, 2011
(Meals and hotels are attendees' responsibility)
CONTACT: Rick Flood, Training Coordinator at 800-343-5682 x 217, or Cara Graham, NE IALEIA Chapter President, at x207.
REGISTER VIA: Fax: 508-528-5184
Mail: 124 Grove St., Ste. 105, Franklin, MA 02038
E-mail: Trai...@nespin.riss.net
*You will be notified by E-mail if you are in the class. For security reasons, only those individuals having a confirmed advance registration will be admitted to the training. Departmental identification will be required at check-in.
----------------------------------------------------------------
Please do not reply to this e-mail as it is an unmonitored alias.
Reply all
Reply to author
Forward
0 new messages