* Designates upcoming class dates listed
Prerequisite: Basic Computer Class (OFFT‑3502) or equivalent experience
Get started with Access 2019. You will learn the basics of tables, queries, forms, reports.
Prerequisite: Access Basic or equivalent experience
You will learn how to promote quality data input; improve efficiency and data integrity, table usability
and form presentation; and create advanced queries and reports.
Prerequisite: Access Intermediate or equivalent experience
Learn to import and export table data; use queries to manage data; create complex reports, forms and
macros; use VBA to extend database capabilities; and manage, distribute and secure a database.
Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience
After an introduction to spreadsheet terminology and Excel’s window components, participants will learn
how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text,
values, formulas, and pictures, and they will save workbooks in various formats. Students will also move
and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. We
will cover simple functions, basic formatting techniques, and printing. Finally, students will create
and modify charts, and learn how to manage large workbooks.
Prerequisite: Excel Basic or equivalent experience
This ILT Series course will teach students how to work with large worksheets in Microsoft Excel 2019, and
use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting
techniques, such as applying special number formats, and using workbook styles and themes. In addition,
students will learn how to create outlines and subtotals, and how to create and apply cell names. They
will sort and filter data, and create and format tables. They will learn how to save workbooks as Web
pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how
to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track
changes in a workbook. Finally, students will customize the Excel environment, and create and modify
Prerequisite: Excel Intermediate or equivalent experience
In this ILT Series course, students will further build on the skills acquired in the Microsoft Excel 2019
Basic and Intermediate courses. They will work with advanced functions and formulas, as well as lookup
functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and
will use advanced data filtering. They will apply advanced chart formatting options, and create more
complex charts. They will work with PivotTables and PivotCharts, export and import data, and query
external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and
how to create scenarios. Finally, they will run and record macros, and explore VBA code.
OneNote is an electronic version of a paper notebook, where you can capture notes, thoughts, ideas,
scribbles, and reminders, share them with others, and sync with other devices. You will discover how to
categorize your information, learn to create folders, format text, use drawing objects, work with
graphics, use Instant Search, and how to share with other OneNote users.
ways to register:
July-December 2022 Workforce
Send mail to:
Jack J. Huck Continuing Education Center
301 S. 68th Street Place
Lincoln, NE 68510-2449
Print a Non-credit
Send via fax to:
Get Driving Directions
Your Path to Personal & Professional Development