This training is intended for U.S. Criminal Justice Practitioners. Please register using your agency-issued email.
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
for Microsoft 365, Excel for the web, and Excel
2021 are recommended. Earlier versions will be functional but will not
work with the section on arrays. A limited number of 365 Office.com
accounts are available for use during the training and will
be provided on a first-come, first-served basis.
cancel any class for any reason and without notice. NW3C is not responsible for
non-refundable travel accommodations lost or rendered moot as a result of a
This is a BYOD (bring your own device) course. You will use your own laptop computer for all in-class exercises.
The hands-on practical exercises are intensive, critical to understanding the material being taught, and required to successfully complete the class. If your computer hardware does not meet the mandatory requirements listed below, your experience in taking the class will be less than ideal and may also impact other students while the instructors take time to troubleshoot hardware and software problems.
Mandatory Operating System Requirements
•Operating system. Your computer must be running Microsoft Windows 10 or macOS v10.12 or later. Make sure your operating system is fully updated prior to class.
•Smartphones and tablets are prohibited.
Mandatory Software Requirements
• Google Chrome. The recommended browser to launch our virtual lab environment.
• Webex Meetings. Required to enter our live online training environment, Webex Training Center.
• Webex Chrome Extension. Required to launch our live online training environment, Webex Training Center, and works hand-in-hand with the Webex Meetings application.
*Your attendance at this course is conditional upon your compliance with CDC, state, and local guidance regarding COVID-19 prevention. While CDC, state, and local guidance is designed to reduce the rate of COVID-19 infections, nothing can eliminate your risk of contracting COVID-19 or one of its variants. By attending this class, you acknowledge that you understand and are assuming the risk of contracting COVID-19. Due to the rapidly changing nature of COVID-19 guidance, infection rates, and safety standards, this class may be rescheduled or cancelled on short notice.