FC200 Intermediate Level Spreadsheeting Skills: Assessing and Organizing Data  (2 Days)


Live Online Training
Tue 04/11/2023 - Wed 04/12/2023
8:00 AM - 4:00 PM Pacific
Class

This training is intended for U.S. Criminal Justice Practitioners. Please register using your agency-issued email.

Course Description
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.

Recommended Skills 
Excel 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.

Cancellation
NW3C may 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 class cancellation.


Computer Requirements
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 later 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.
• Microsoft. You will need Microsoft Excel for this course.

Mandatory Hardware Requirements
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 monitors.
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 microphone.

If you have any questions regarding the mandatory minimum hardware requirements, please contact liveonline@nw3c.org.

Class Fee: $0
Class Full

This class is no longer open to new registrations. Please check back for alternate dates/times.

Register for class