Basic Excel Skills for Law Enforcement Inspections and Auditing Excel-101
Course Description:
Learn the basics of Microsoft Excel for law enforcement inspections and auditing to enhance your skills 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 a basic 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 first in a series of Excel classes designed for law enforcement inspections and auditing professionals.
Excel-101 Course objectives:
Participants learn the most common Excel functions and build a solid understanding of the software and learn how to:
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 date formats
Create and edit tables
Sorting data (alphabetically and numerically)
Filtering data
Creating drop-down menus
Create and format tabs
Utilize basic math functions
This class is for law enforcement professionals (sworn and non-sworn)
With limited or no experience with Excel
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.