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.

Celebrate the season by creating a variety of festive baked treats perfect for sharing with family and friends. In this hands-on class, participants will learn baking techniques, decorating tips, and creative presentation ideas while preparing a selection of holiday cookies, breads, pastries, or other seasonal favorites. Designed for bakers of all skill levels, this course provides practical skills and recipes to help participants bring homemade holiday traditions to their own kitchens.

NOTE:  For Blackhawk Instructional Faculty and Staff
Designed for faculty and staff with foundational AI experience, this strand focuses on practical applications that improve efficiency, creativity, communication, and instructional effectiveness. Participants will build confidence using AI tools to support everyday teaching and professional responsibilities.

NOTE:  For Blackhawk Instructional Faculty
Move beyond Canva basics and discover advanced features that enhance instructional materials, presentations, videos, and student-facing resources. Participants will develop engaging visual content while exploring strategies for improving communication and learning experiences.

NOTE:  For Blackhawk Instructional Faculty
This assessment-focused strand provides faculty with guided support for key curriculum and assessment processes to prepare for Assessment Day. Through hands-on activities and practical examples, participants will walk through the four assessment day activities while strengthening their ability to analyze outcomes data, maintain assessment documentation, and prepare for program review activities.