This one-day course provides foundational spreadsheeting knowledge and skills to enhance workplace productivity. The course covers basic navigation of Microsoft Excel by combining live demonstrations and hands-on exercises.
Work with multiple worksheets within a workbook
Hide, unhide, and protect worksheets
Adjust rows and columns
Use copy and paste options
Find, select, and sort data
This intermediate spreadsheeting course uses Microsoft Excel to assess and organize data in an electronic format. The class is designed for learners who have experience using Excel and who want to increase their spreadsheeting knowledge and skills. Topics include text functions, absolute referencing, date and time functions, flash fill, handling formula errors, VLOOKUP, dynamic arrays, and data validation. The course combines live demonstrations, instructor-led exercises, and independent student exercises.
This course provides expert guidance in the skills law enforcement officers need to conduct successful online investigations. Topics include IP addresses and domains, an overview of currently popular social media platforms, best practices for building an undercover profile, foundational knowledge related to the dark web, and the use of the dark web as an investigative tool. Instructors demonstrate both open-source and commercially-available investigative tools for social engineering, information gathering, and artifacts related to social media; as well as automated utilities to capture information and crawl websites.
*Internet basics. IP address assignment; resolving domains and IP addresses; networking overview.
*Popular sites. Facebook, Twitter, KiK Messenger, Snapchat, Instagram, tumblr, and more.
*The dark web. Surface, deep, and dark web; how data flows through the internet. Who uses the dark web and how?
*Tor. How to access Tor; how Tor traffic works; how a Tor Hidden Service works; installing and configuring the Tor Browser Bundle.
Provide roadway safety training to your agency. Attend this 8-hour course where trainers will be given the resources and skills needed to teach the NLERSP training curriculum to other officers during academy or in-service training. Prerequisite: Trainers must complete the Roadway Safety for Patrol Officers course prior to attending this course.
Learn how to improve your safety on the roadways. This 8-hour course will discuss best practices and tactics to improve your safety during traffic stops, emergency response driving, all-weather driving, and roadway operations while outside of your vehicle.
Lead your agency in roadway safety. Attend this 4-hour workshop with other mid-level and executive-level officers where you will discuss policies, training, and technological innovations that can reduce the risk of officer-involved collisions and struck-by incidents.
Provide roadway safety training to your agency. Attend this 8-hour course where trainers will be given the resources and skills needed to teach the NLERSP training curriculum to other officers during academy or in-service training. Prerequisite: Trainers must complete the Roadway Safety for Patrol Officers course prior to attending this course.
Learn how to improve your safety on the roadways. This 8-hour course will discuss best practices and tactics to improve your safety during traffic stops, emergency response driving, all-weather driving, and roadway operations while outside of your vehicle.
Lead your agency in roadway safety. Attend this 4-hour workshop with other mid-level and executive-level officers where you will discuss policies, training, and technological innovations that can reduce the risk of officer-involved collisions and struck-by incidents.
Learn how to improve your safety on the roadways. This 8-hour course will discuss best practices and tactics to improve your safety during traffic stops, emergency response driving, all-weather driving, and roadway operations while outside of your vehicle.