CONTINUING EDUCATION

Read more

In this course, learners build on intermediate Microsoft Access skills. They investigate complex reports, switchboards, macros, mail merge and data normalization. Upon successful completion of the course, learners will be able to apply advanced concepts to useful database design and to skillfully analyze database content and design using a variety of database tools.

Instructor Arlene Roche
Thursdays - 11/12/20 & 11/19/20
4:00 pm - 8:00 pm
Room 110 - iMET Center

Hide

Read more

In this course, learners explore basic features of Microsoft Access. They examine tables, forms, reports, and queries. Database management vocabulary is introduced, and learners practice its use. Upon completion of the course, learners will be able to create and navigate a simple database and develop simple queries.

 

Instructor Arlene Roche
Saturdays - 10/3/20 & 10/17/20
8:00 am - 12:00 pm
Room A210 - Kensosha Campus

Hide

Read more

In this course, learners build on basic Microsoft Access database skills. They examine data validation, database relationships, and the design and purpose of more complex queries and forms. Learners practice using calculations in tables, queries, and forms. Upon completion of this course, learners will be able to build a report using conditional formatting, build a navigation form to help users find their way around a database, and present data using basic macros to automate common tasks.

 

Instructor Arlene Roche
Saturdays, 10/24/20 & 11/7/20
8:00 am - 12:00 pm
Room A210 - Kenosha

Hide

Read more

In this course, learners explore basic features of Microsoft Excel. They examine spreadsheet terminology and editing. Learners explore Excel formatting functions and the features to create simple charts. Learners practice using spreadsheet printing options, page setup options, and a variety of shortcut techniques. Upon completion of the course, learners will be able to create, edit, and navigate a basic spreadsheet and create simple charts associated with a spreadsheet.

 

Instructor Arlene Roche
Saturdays, 11/14/20 & 11/21/20
8:00 am - 12:00 pm
Room A210 - Kenosha Campus

Hide

Read more

In this course, learners explore basic features of Microsoft Excel. They examine spreadsheet terminology and editing. Learners explore Excel formatting functions and the features to create simple charts. Learners practice using spreadsheet printing options, page setup options, and a variety of shortcut techniques. Upon completion of the course, learners will be able to create, edit, and navigate a basic spreadsheet and create simple charts associated with a spreadsheet.

 

Instructor Arlene Roche
Wednesdays - 10/7/20 & 10/14/20
8:30 am - 12:30 am
Room S241 North Building- Elkhorn Campus

Hide

Read more

In this course, learners build on basic Microsoft Excel skills. They examine advanced text formatting options. Learners investigate order of operations, differentiate between absolute and relative references, and practice using formulas and functions to perform calculations. Learners explore basic Excel functions (logical, date and time, statistical) used to analyze and manipulate data. Upon completion of the course, learners will be able to perform a variety of intermediate level spreadsheet functions to format, manipulate, and analyze data.

 

Instructor Arlene Roche
Wednesdays - 10/21/20 & 10/28/20
8:30 am - 12:30 pm
Room S241 North Building - Elkhorn Campus

Hide

Read more

In this course, learners build on basic Microsoft Excel skills. They examine advanced text formatting options. Learners investigate order of operations, differentiate between absolute and relative references, and practice using formulas and functions to perform calculations. Learners explore basic Excel functions (logical, date and time, statistical) used to analyze and manipulate data. Upon completion of the course, learners will be able to perform a variety of intermediate level spreadsheet functions to format, manipulate, and analyze data.

 

Instructor Arlene Roche
Thursdays - 10/1/20 & 10/8/20
4:00 pm - 8:00 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners build on intermediate level Microsoft Excel skills. They explore the purpose and function of three-dimensional (3D) and external references. Learners apply sorting, filtering, grouping, and subtotaling features to spreadsheet data and its validation. They examine more advanced logical functions used to test for the presence of and various combinations of data (if, and, or). Learners consider special formatting features that enhance tables and charts. Upon completion of the course, learners will be able to analyze, manipulate, organize, and visualize data.

 

Instructor Arlene Roche
Thursdays - 10/15/20 & 10/22/20
4:00 pm - 8:00 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners build on intermediate level Microsoft Excel skills. They explore the purpose and function of three-dimensional (3D) and external references. Learners apply sorting, filtering, grouping, and subtotaling features to spreadsheet data and its validation. They examine more advanced logical functions used to test for the presence of and various combinations of data (if, and, or). Learners consider special formatting features that enhance tables and charts. Upon completion of the course, learners will be able to analyze, manipulate, organize, and visualize data.

Instructor Arlene Roche
Wednesdays, 11/4/20 & 11/11/20
8:30 am - 12:30 pm
Room S241 North Building- Elkhorn Campus

 

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to investigate the process of finding specific values within a data set. They examine Excel's lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE) and practice applying them to specific scenarios. The simplicity and flexibility of Excel's XLOOKUP function is presented. Upon completion of the course, learners will be able to use reference functions to search for specific information in a data set and use it to retrieve, combine, and categorize data.

 

Instructor Arlene Roche
Thursday - 10/29/20
6:15 pm - 8:15 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to investigate the process of finding specific values within a data set. They examine Excel's lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE) and practice applying them to specific scenarios. The simplicity and flexibility of Excel's XLOOKUP function is presented. Upon completion of the course, learners will be able to use reference functions to search for specific information in a data set and use it to retrieve, combine, and categorize data.

 

Instructor Arlene Roche
Wednesday, 11/18/20
10:30 am - 12:30 pm
Room S241 North Building - Elkhorn Campus

Hide

Read more

In this course, learners use advanced Microsoft Excel skills to analyze complex data. They examine how to build PivotTables that summarize large data sets and how to apply conditional formatting and filtering to the PivotTables they create. Learners investigate how to create a visual representation (PivotChart) of a PivotTable , and they explore the relationship between them. Upon completion of the course, learners will be able to summarize, visualize, and analyze complex data and present it in an effective and efficient, interactive visual format to meet the needs of business planners.

 

Instructor Arlene Roche
Thursday - 10/29/20
4:00 pm - 6:00 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners use advanced Microsoft Excel skills to analyze complex data. They examine how to build PivotTables that summarize large data sets and how to apply conditional formatting and filtering to the PivotTables they create. Learners investigate how to create a visual representation (PivotChart) of a PivotTable , and they explore the relationship between them. Upon completion of the course, learners will be able to summarize, visualize, and analyze complex data and present it in an effective and efficient, interactive visual format to meet the needs of business planners.

 

Instructor Arlene Roche
Wednesday, 11/18/20
8:00 am - 10:00 am
Room S241 North Building - Elkhorn Campus

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to automate a task or set of tasks. Using Visual Basic for Applications (VBA) available in Excel, learners develop custom actions designed to streamline data and spreadsheet-related tasks. They practice planning, recording, editing, running, debugging, and saving a macro of their creation. Upon completion of the course, learners will be able to design, create, edit, and save custom actions that enhance the efficiency of spreadsheet tasks.

 

Instructor Arlene Roche
Thursday - 11/5/20
4:00 pm - 8:00 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to automate a task or set of tasks. Using Visual Basic for Applications (VBA) available in Excel, learners develop custom actions designed to streamline data and spreadsheet-related tasks. They practice planning, recording, editing, running, debugging, and saving a macro of their creation. Upon completion of the course, learners will be able to design, create, edit, and save custom actions that enhance the efficiency of spreadsheet tasks.

 

Instructor Arlene Roche
Wednesday, 11/25/20
8:30 am - 12:30 pm
Room S241 North Building - Elkhorn Campus

Hide