Your browser is not optimized for viewing this website.

More information »

Blackhawk Technical College

Filter by Category



Computers

in Professional Development

Intermediate Excel: Complex Functions

$9534

with Sue Dunphy

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

Advanced Excel

$9534

with Tina Aldrich

Calendar Next available session starts May 7, 2025 at 9 am

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.

Computer Basics: Email and The Internet-Monroe

$1370

with Robin McLeish

Calendar Next available session starts May 8, 2025 at 1 pm
Learn essential skills for navigating the online world. Explore how to effectively use web browsers, search engines, and online safety tips. Discover the fundamentals of email communication, including composing, organizing, and managing your inbox. This class is perfect for beginners looking to enhance their digital literacy and connect confidently online!




Forgot password?
Staff Log In