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.
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
Mandatory Operating System
• 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
Chrome. The recommended browser to launch our virtual lab
• 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.
• Dual monitors. You
will need one monitor to join the online classroom, view
presentations, see the instructor’s shared screen, and interact with the instructor(s). The second
monitor is needed to join and complete hands-on practical exercises. Not being
able to see both interfaces simultaneously will make it difficult,
if not impossible to successfully complete hands-on practical exercises. Large
screen monitors, trying to run the two different interfaces split screen, will
NOT work. Multiple computers can also work as a substitute to having multiple
• Hard-wired, high-speed
Internet connection. A wireless Internet connection may be sufficient,
however, a wired connection will improve latency and buffering, and will also
provide better connection speeds and stability overall.
• Speakers. We recommend a
headset, headphones, or earbuds to eliminate feedback and echo if using your
If you have
any questions regarding the mandatory minimum hardware requirements, please