Your browser is not optimized for viewing this website.

More information »

Blackhawk Technical College

Filter by Subcategory



Professional Development

Basic Excel: Formulas and Functions

$88

with Sue Dunphy

Calendar Next available session starts Oct 15, 2025 at 1 pm

Gain confidence in creating basic formulas and functions with relative and absolute references. Understand operator precedence and how it affects formulas. Learn about the different parts of a function and how to create arguments to calculate values and cell references. Excel includes common functions that can be used to quickly find the sum, average, count, maximum and minimum value for a range of cells

Pump 1-Green County

Free
Calendar Next available session starts Oct 15, 2025 at 6 pm

Please note that this class meets Saturdays, 10/25, 11/1, and 11/15 from 8am-2pm

EMR Advanced

$5653
Calendar Next available session starts Oct 20, 2025 at 6 pm

Please note that the class on Monday, October 20 meets 8-10pm. 

Navigating Networking

$3074

with Lizzie Menz

Calendar Next available session starts Oct 22, 2025 at 11 am

Learn the skills needed to build and maintain a professional network. You will learn effective strategies for initiating conversations, leveraging social media, and nurturing relationships that can lead to career advancement. Through interactive exercises and real-world scenarios, you will gain confidence in networking situations and develop a personalized action plan to expand their connections.

What is Welding?

$80

with Andrew Stoever

Calendar Next available session starts Nov 1, 2025 at 8 am

Are you curious about welding and want to try it for yourself? During this 3 hour class you will be introduced to the world of welding by building a small project. The following is covered in this course: safety, different welding types, education and careers in welding, how to make basic welds using Gas Metal Arc Welding (MIG) and basic metal preparation and finishing.

Intro to MS Office-Janesville

$88

with Tina Aldrich

Calendar Next available session starts Nov 5, 2025 at 9 am

Learn the basics of Microsoft Word, PowerPoint, and Excel. Explore how to effectively format documents in Word, create engaging presentations in PowerPoint and how to format and use simple formulas in Excel.

Basic Excel: Formulas and Functions-Monroe

$88

with Robin McLeish

Calendar Next available session starts Nov 12, 2025 at 1 pm

Gain confidence in creating basic formulas and functions with relative and absolute references. Understand operator precedence and how it affects formulas. Learn about the different parts of a function and how to create arguments to calculate values and cell references. Excel includes common functions that can be used to quickly find the sum, average, count, maximum and minimum value for a range of cells

Intermediate Excel: Complex Functions

$88

with Sue Dunphy

Calendar Next available session starts Nov 19, 2025 at 1 pm

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.





Forgot password?
Staff Log In