ITS Classes - Nov/Dec

Free learning opportunities for UNMC students, faculty and staff and UNMC-Physicians Staff. Classes are located in the 8th floor of the McGoogan Library, room 8011 Wittson Hall, unless noted otherwise.

If you need training on basic personal computing, windows or other software not listed, check out self-study tutorials at www.unmc.edu/its/training.htm or contact Kim Laursen at 402-559-5674 for additional resources. Customized classes for departments and groups can also be arranged.

Please don't be a "no show" or late arrival. Email csttrain@unmc.edu to cancel your registration or send a co-worker in your place. Sessions with fewer than five may be cancelled or tutorials may be substituted.

* Required

LastName
*

This is a required question

Firstname
*

This is a required question

Email Address
*

This is a required question

Department
*

This is a required question

Dept Zip

This is a required question

Phone
*

This is a required question

Staff/Student/Other
*

UNMC Employee/Faculty

UNMC Physician Staff

UNMC Student

Other

This is a required question

Microsoft Mini Sessions (Beyond the Basics)

Enhance your basic knowledge of Microsoft applications. Share your own “tricks” in these fall mini-sessions get a special treat! Sessions will be hands-on in the ITS training room, however if over 20 sign up, we’ll locate a larger room for a shorter presentation session. . Should have some experience working with applications. See descriptions on Class Schedule at www.unmc.edu/its/training.htm

Word Graphics 11/13 from 10-11:30 a.m.

Excel Charts 11/26 from 1-2:30 p.m.

Designing a Database 11/29 from 2-3 p.m.

Word Mail Merge 12/5 from 10-11:30 a.m.

Outlook Tips and Shortcuts (DATE CHANGE- 12/19 from 1-2:30 p.m.

This is a required question

Access 2007/2010 Table Basics

Create and work with tables, search, sort, filter data, freeze and hide columns, create table using templates and from scratch,learn about field properties, import/link Excel worksheets with Access. Prerequisite: Experience working with Excel recommended. ITS is also offering Designing a Database mini-session (listed above) which will be useful for those needing to create a new database.

12/4 from1-4 p.m.

This is a required question

Access 2007/2010 Queries Part 1

Part 1 discusses basic query design using one table and various criteria examples. Prerequisite: Access Table Basics or equivalent experience.

12/11 from 2-4 p.m.

This is a required question

Access 2007/2010 Queries Part 2

Part 2 includes several examples of more advanced queries - joining multiple tables, grouping data and working with calculations and creating action queries. Prequisite: Access Queries Part 1 or equivalent experience.

12/18 from 2-4 p.m.

This is a required question

Access 2007/2010 Forms / Reports

Contact Kim Laursen at klaursen@unmc.edu if you would like training on Access Forms or Reports

11/7 from 10 a.m. - 12 p.m.

This is a required question

Access 2007/2010 Reports

Learn how to create a variety of printed reports and labels using layout and design mode. Prequisite: Access Table Basics and Queries or equivalent experience. (Forms class recommended)

11/14 from 10 a.m. -12 p.m.

This is a required question

Excel 2007/2010 Basics Part 1

Learn the 2007/2010 ribbon interface, create a worksheet, cell formatting, autofill, insert/delete cells, rows, columns, sheets, create simple formulas and functions, print and save worksheets. Follow along with a tutorial on the "big screen" with an instructor facilitating and providing additional assistance and showing features specific to your need. No prerequisite.

12/5 from 2-4 p.m.

This is a required question

Excel 2007/2010 Basics Part 2

Learning auditing commands for checking formulas, learn to use absolute and relative cells in formulas, create and work with named ranges, learn more formatting and styling, learn how to filter/sort, use conditional formatting and an introduction to graphical elements and multiple documents. Follow along with a tutorial on the "big screen" with an instructor facilitating and providing additional assistance and showing features specific to your needs. Prerequisite: Part 1 or equivalent experience.

12/12 from 2-4 p.m.

This is a required question

Outlook Mail Basics (2007/2010)

Learn how to use UNMC Outlook email - create and send messages, receive, file, delete messages. Work with contacts and several useful email tips. No prerequisite.

11/8 from 9 a.m. - 11 a.m.

This is a required question

Outlook Calendar (2007/2010) (TIME CHANGE)

Learn how to use Outlook calendars, set up preferences for using other calendar, and send meeting invitations. No prerequisite.

11/12 from 1:00 p.m. - 3:00 p.m.

This is a required question

Outlook OWA Basics - Web/Remote access

Learn how to use UNMC Outlook email from the web from on and off campus- create and send messages, receive, file, delete messages. Work with contacts and several useful email tips and use the calendar. No prerequisite.

12/ 12 from 1:00 - 2:30 p.m.

This is a required question

PowerPoint 2007/2010 Basics (Date change)

Learn how to create presentations using PowerPoint 2007/2010, work with various views, add graphical elements such as charts, pictures, SmartArt, work with screen shows, and how to use UNMC Branding elements and templates. Follow along with a tutorial on the "big screen" with an instructor facilitating and providing additional assistance and showing features specific to your needs. Prerequisite: Experience working with Word recommended.

12/13 from 1-4 p.m. (Date change)

This is a required question

Publisher 2010 Basics

Learn basic features of Microsoft Publisher to create newsletters, brochures and other publications with UNMC Branding elements. Knowledge of Word graphics is recommended.

11/27 from 2-4 p.m.

This is a required question

Word 2007/2010 Basics (Date Change)

Learn how to create and edit documents, use formatting features. Follow along with a tutorial on the "big screen" with an instructor facilitating and providing additional assistance and showing features specific to your needs. No prerequisite.

Need help with a specific feature of Word or Outlook or have a project in Excel or Access that you need advice on? Or perhaps you want to learn more about OneNote or another application? Stop by the 8th floor training room 8011 Wittson Hall for one-on-one help or get started with tutorials.