* Designates upcoming class dates listed
An introduction to Office 365 for users who have traditionally used standalone versions of Microsoft Office on their PC or laptop. As businesses turn to subscription-based software, Microsoft has catered to this by offering Office 365, which contains the favorites, such as Excel, PowerPoint and Word but includes new or updated apps to work, communicate and collaborate with colleagues, wherever you are. You will become familiar with the Office 365 interface and the applications within the plan including OneDrive, SharePoint, MS Office Products and Other Apps, Sway, Forms, OneNote, and Outlook.
Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience
After an introduction to Word’s window components, participants will learn how to use the Help system and navigate documents. They will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, and insert graphics.
Prerequisite: Word Basic or equivalent experience
Participants will work with styles, sections and columns and will use the Navigation pane to work with outlines. You will format tables, print labels and envelopes, and work with graphics. You also will use document templates, manage document revisions and work with Web features.
Prerequisite: Word Intermediate or equivalent experience
Participants will perform mail merges, create and use forms and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. They also will create macros, customize the ribbon and Quick Access toolbar, and work with XML documents.
Prerequisite: Basic Computer
Whether looking to enhance your basic skills with Word or learn new ones, this hands-on “tips and tricks” class is ideal. This class will cover and expand on the basics functions. Time will be available to ask questions.
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 2016, 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 custom templates.
Prerequisite: Excel Intermediate or equivalent experience
In this ILT Series course, students will further build on the skills acquired in the Microsoft Excel 2016 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.
Prerequisite: Excel Advanced or equivalent experience
This class is for users with or without a programming background. It introduces students to the capabilities of Excel’s Visual Basic for Applications. You will learn how to automate repetitive spreadsheet tasks, read and edit code generated in Excel’s Visual Basic Editor, write decision-making code using IF statements and Loops, as well as create interactive message and input boxes which prompt the user for more information. You also will learn how to make macros easily available via keyboard shortcuts, buttons, or by assigning them to Excel’s menus or toolbars.
Whether looking to enhance on your basic skills with Excel or learn new ones, this hands on “tips and tricks” class is ideal. This class will cover and expand on the basics functions. Time will be available to ask any questions.
After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields and records; sort and filter data; and set field properties and data-entry rules. Students will then learn to create queries, forms and reports.
Prerequisite: Access: Basic or equivalent experience
Participants will learn how to normalize data, manage table relationships and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
Prerequisite: Access Intermediate or equivalent experience
This course builds on the skills and concepts taught in Access Intermediate. Students will learn how to create crosstab, parameter and action queries; create macros; import, export and link database objects; create hyperlink fields; optimize, split and back up databases; password protect and encrypt databases; and set Access options and properties.
After an introduction to PowerPoint’s window components and Help system, students will learn to create, save, and rearrange presentations. Then they will format text, use drawing objects, work with graphics, and insert tables and charts. They will then learn to use templates and themes, slide masters, and transition effects. Finally, students will learn to proof, run, and print presentations.
Prerequisite: Microsoft PowerPoint Basic or equivalent experience
After an introduction to Prezi and the multitude of options available in creating presentations, students will learn to create a presentation using the basics of Prezi, edit and present mode, navigating a Prezi canvas, Prezi animations and transitions and other unique features. Finally, students will learn to proof, run and deliver a Prezi presentation.
Class covers Outlook 2016 Mail, Calendars, People, and Tasks. Manage incoming and outgoing email messages, work with attachments, and create folders. Customize and sort messages, create signatures and stationery, and manage junk mail. Schedule and edit appointments, events and meetings. Customize and print calendar views. Create and manage contact information and contact groups. Create and manage tasks, To-Do lists, and Notes.
Deciding which email platform to use can be frustrating and confusing. Experience the benefits and downfalls to each platform. When you leave class, you will have a new sense of confidence when choosing which email platform is best for your new or existing business.
Prerequisite: Basic Computer class and must have Outlook account
Outlook is an essential tool to help you manage contact information. Whether looking to enhance on your basic skills with Outlook or learn new ones, this hands on “tips and tricks” class is ideal. This class will cover and expand on the basics functions, such as email, calendar, and tasks. Time will be available to ask any questions not covered in the class.
Learn to create, organize and share notes and information with others. Gather pictures, audio and video recordings, projects, and presentations in an electronic notebook and share seamlessly with colleagues, family and friends. Topics include creating a notebook; entering, formatting, and organizing notes; creating templates; and integrating with other applications such as Word and Excel.
Let Evernote change the way you organize your personal and professional projects. Dive in: take notes, create to-do lists, manage your calendar, inventory, and save things you find online into Evernote. It will sync everything between your phone, tablet and computer automatically.
Please check back!
ways to register:
August-December 2020 Workforce Solutions Schedule
Send mail to:
Jack J. Huck Continuing Education Center
301 S. 68th Street Place
Lincoln, NE 68510-2449
Print a Non-credit Courses Registration Form
Send via fax to:
Get Driving Directions
Your Path to Personal & Professional Development