This class is for final year apprentices who will, as journey workers, soon be responsible for passing on their skills to new apprentices.  Developed by the Bureau of Apprenticeship Standards, this 8-hour course teaches soon-to-be journey workers how to serve as a mentor and job coach, how to provide hands-on skill training, how to give positive and effective performance feedback, and explores the characteristics of a positive and diverse work environment. Please note that this is a Blackboard online course. If you are not a current/former student of Blackhawk Technical College you will receive login credentials 3-5 days after registering. 

Develop your understanding of how Excel uses logic with functions like AND, OR, COUNTIF, IF, and Nested IF. Perform calculations with SUMIF, AVERAGEIF, OR COUNTIF when a specific condition is met. Use VLOOKUP and XLOOKUP to search for specific information in a table. Find out how to name cells and ranges, and then use them in formulas. Learn how to link cells within worksheets and workbooks, and how to create 3D formulas across worksheets and workbooks. Locate errors by utilizing Auditing to find precedents and dependents related to a function. Enable the Watch Window to view out of sight cells. Use Data Validation to limit the type of data that can be entered into a cell and to create a drop-down list.

Learn how to use tables, pivot tables, and pivot charts to manage and analayze your data more effectively. Explore different ways to sort, filter, and subtotal data, as well as how to use VLookUp to search for specific information in a table. Learn how to utilize database functions within an Excel table and how to import an Acess database into Excel.

Become more familiar with what Excel can do in this introductory course. Learn how to create an Excel workbook, select and move around in a worksheet, format, work with simple formulas and functions, create tables and charts, and explore templates

This BLS course trains healthcare workers and other personnel to promptly recognize several life-threatening emergencies, give high-quality chest compressions, deliver appropriate ventilations and provide early use of an AED. 

This hands-on class covers key applications like Google Docs, Sheets, and Slides, empowering you to create, collaborate, and share documents effectively. Learn to organize your workflow using Google Drive, manage calendars with Google Calendar, and communicate seamlessly through Gmail and Google Meet.

This BLS course trains healthcare workers and other personnel to promptly recognize several life-threatening emergencies, give high-quality chest compressions, deliver appropriate ventilations and provide early use of an AED.