Register

/Register
Return to Training Schedule

Excel: Advanced Topics

Early $375.00 ENDS JANUARY 18
Regular (1 Months Left) $400.00 ENDS MARCH 18
Late $425.00 ENDS APRIL 18

Host: POLICE TECHNICAL
Location: Online
Dates: April 18, 2023 - April 19, 2023
Times: 10:00 AM - 2:00 PM CT
Fee: $400.00

Course Description
Instructor
Travel Information

Expanding on the power of Microsoft Excel® to better manage data & improve investigations.

Course Overview

Advanced Microsoft Excel® for Public Safety™ is designed to further public safety personnel’s Excel skills to aide in law enforcement data managing and analysis. The basic Excel skills learned in the prerequisite offered by Police Technical, Microsoft Excel® for Public Safety™, will be broadened. You’ll learn more formulas to expand your analysis capabilities, timeline tools, and power tools for querying and charting.

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 a basic understanding of computers and Excel®; course prerequisite Microsoft Excel® for Public Safety™ recommended but not required. 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

  1. Navigation & Manipulation Tools – Status bar and other add-ins
  2. Importing from a Pre-Existing Database – Import from Access, Word, Text, and others
  3. Complex Formulas – Dates and Times and If Statements
  4. Common Errors – What am I doing wrong?
  5. Timelines in Excel – Visual of the WHENs


Day Two

  1. More Complex Formulas – VLOOKUP and statistics
  2. Macros Creation and Manipulation – Automation techniques
  3. Power Querying and Power Pivots – Asking questions and getting answers
  4. Printing in Excel