Intermediate Excel Skills for Law Enforcement Inspections and Auditing Excel-201

Course Description:  
Learn intermediate Microsoft Excel skills for law enforcement inspections and auditing to enhance your knowledge and improve your effectiveness while adding value to your position and your organization. Microsoft Excel is the industry-leading spreadsheet software program, a powerful data visualization and analysis tool used by most government organizations. This course is based on law-enforcement-related scenarios and is designed to give you an intermediate mid-level working knowledge of Excel specifically for Law Enforcement related inspections and auditing engagements. Excel functionality is introduced using easy-to-understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them. This class is the second in a series of Excel classes designed for law enforcement inspections and auditing professionals.

 

Excel-201 Course objectives: Who should take this course?

 

If you are competent in using Excel for the following tasks, take this course! If not, take the 101 course. What is covered in the intermediate 201 course
  • Use basic ribbon functions
  • Create your own easy-to-use spreadsheets and workbooks from scratch and understand how they work!
  • Format cells, columns, and rows
  • Use number and data formats
  • Create and edit tables
  • Sorting / Filtering data
  • Creating drop-down menus
  • Create and format tabs
  • Printing and auto-fill options
  • Combining data from multiple cells
  • Combining data from multiple sheets
  • Formulas and Functions
  • Data Subtotals
  • Custom sort
  • Conditional formatting
  • Random Sample
  • Stratified Sample

 

This class is for law enforcement professionals (sworn and non-sworn)

  • With some experience with Excel (see chart above)
  • Interested in or responsible for law enforcement business related-controls, compliance, and quality assurance activities
  • Interested in leveraging Microsoft Excel for inspections and auditing to make your job easier

Sessions will include an Excel template and step-by-step written instructions for all class exercises. The computer used during class must have a camera and microphone for WebEx online sessions and Microsoft Excel software. Participants should have Excel 2016 or higher installed on their computer prior to attending this workshop.

Click here for Course Availability.