Your browser is not optimized for viewing this website.

More information »

Blackhawk Technical College

Filter by Category



Computers

in Personal Enrichment Courses

Intro to MS Office-Janesville

$9534

with Tina Aldrich

Calendar Next available session starts Feb 26, 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 forumlas in Excel.

Google Workspace Basics-Janesville

$7137

with Tina Aldrich

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

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.

Intro to Excel

$9534

with Sue Dunphy

Calendar Next available session starts Mar 26, 2025 at 1 pm

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 workseet, format, work with simple formulas and fuctions, create tables and charts, and explore templates

Computer Basics-Janesville

$1370

with Tina Aldrich

Calendar Next available session starts Apr 2, 2025 at 10 am

Learn a variety of topics essential for using a computer including navigation, using the basic funtions of a Windows operating system, creating and managing files and folders, and utilizing popular software applications. No prior knowledge of computers is required.

Computer Basics-Monroe

$1370

with Robin McLeish

Calendar Next available session starts Apr 3, 2025 at 1 pm

Learn a variety of topics essential for using a computer including navigation, using the basic funtions of a Windows operating system, creating and managing files and folders, and utilizing popular software applications. No prior knowledge of computers is required.

Basic Excel: Formulas and Functions

$9534

with Sue Dunphy

Calendar Next available session starts Apr 9, 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

Intro to Excel-Monroe

$9492

with Robin McLeish

Calendar Next available session starts Apr 17, 2025 at 1 pm

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 workseet, format, work with simple formulas and fuctions, create tables and charts, and explore templates

Intermediate Excel: Complex Functions

$9534

with Sue Dunphy

Calendar Next available session starts Apr 23, 2025 at 1 pm
1 additional session on Apr 30, 2025

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