Computer Classes

UW-BSC Continuing Education offers a variety of non-credit computer courses for students and community members.

Fall 2014 Computer Classes

 

USING EXCEL AS A DATABASE

Go to Registration Page

Instructor: Terri Nee-Holtz
Excel has many great features that allow users to create and maintain a large database. Once data is entered, you can update, sort, search, filter/retrieve subsets of data, summarize data by inserting subtotals, and create reports. Make important data stand out by setting up conditional formatting. This feature will change the formatting of all cells that meet the condition. Learn to import and export Excel data with other Microsoft applications. Exported data may be linked so the original and the exported file are updated together.

Friday, November 7 • 12:30-3:30 pm
Campus Library, Computer Lab
Fee: $39

USE EXCEL TO ANALYZE AND PREDICT

Go to Registration Page

Instructor: Terri Nee-Holtz
Once your worksheet is created, it can be difficult to find a formula error. Use the feature Trace An Error to identify the formulas and cells that are causing the error. Here are some of the features this class will cover:
a) What-If Analysis with Goal Seek: Allows you to explore the impact of changing different values in a worksheet.
b) Create and chart a One-Variable and Two-Variable Data Table: Useful to determine the impact of different values. IE Impact different interest rates and the length of mortgage on the calculated monthly payment.
c) Scenario Manager: Each scenario includes a scenario name, input or changing cells, and values of each input cell. The number of scenarios you can create is unlimited.
d) Pivot Tables and Charts: An interactive table used to group and summarize a range of data or an Excel table into a concise, tabular format for easier report and analysis.

Friday, November 21 • 12:30-3:30 pm
Campus Library Computer Lab
Fee: $39

FINDING WHAT YOU NEED IN THE INFORMATION AGE

Go to Registration Page

Instructors: UW-Baraboo/Sauk County Academic Librarians
In these days of information overload, learn from academic librarians how to sort through the mass of information available. This class will help you discover resources you didn’t know you had access to, and also help you become more efficient and confident when searching for information on the Web.

Tuesday, October 28 • 5:00-6:30 pm
Campus Library Computer Lab
Fee $19