Question: I recently started working at the College of Dentistry in Lincoln. I would love to take advantage of the training opportunities you offer.
Answer: I no longer travel to the other campuses because there are many good online resources, and off-campus UNMC employees who work at other campuses may be eligible for technology training at those campuses:, UNL, UNO. UNK
You will also find several of our courses already available on some recordings (from http://www.unmc.edu/its/class_handouts.htm).
A fellow colleague here at UNMC sent me a video link to some useful “Ted” Tech Tips. Some of these you may already know, but hopefully you can learn a few more.
If you’ve ever attended my Excel mini-sessions, you’ll learn how obsessed I am with Excel Tables feature. This article from Tech Republic is a great summary of the many reasons why I love Excel Tables.
I came across this article recently from Tech Republic. It shows how using SumIf(), helper columns, Countifs() Excel functions may be simpler than using complex formulas. Click this link for some useful Excel tips.
Question: I am retiring after working at UNMC for many years. I haven’t had time to attend many classes recently but wondered if it is possible to come back to take computing classes?
Answer: Yes! A benefit to UNMC employees is that when they retire they can attend our classes at no charge, as long as there is room in the class (there usually is). In fact, a former chancellor attended many of our classes! Just send me your email address so you’ll be on our list for notices and reminders. You can also check our web page for offerings. You will not be able to use the registration without a UNMC email address, but you can email firstname.lastname@example.org to let me know if you’d like to attend.
In addition, don’t forget to search other sources of free training at Microsoft, Apple, Adobe, and even Youtube, etc. Below are links to several good resources for online training:
There are other companies which have a few free courses but charge an affordable fee, such as www.totaltraining.com and www.lynda.com .
Best wishes on your retirement!
I know basic features of Word but would like learn more advanced features without having to sit through a lot of training. What do you recommend?
UNMC ITS recommends their short mini-sessions which are often available, as well as videos, demos and tutorials that Microsoft offers free of charge. Click here to see a variety of excellent short videos on: opening Word really fast, using office.com templates, convert a list into a table, make bulleted list more interesting, cropping pictures to shapes, zooming with your mouse, and more! All videos are three minutes or less.
The next ITS Word mini-session is Tuesday 11/13 from 10-11:30 and will feature Word Graphics features, including working with photos, text boxes, diagrams and more. Feel free to bring your own documents to “dress up.” Learn about Mail Merge on December 5 from 10-11:30 a.m. to create letters, labels or envelopes from your mailing lists in Excel or Access. We will also have “drop in help” sessions following those sessions from 11:30-12:30 to for individual help with projects (Word or other applications). These sessions will be held in 8011 Wittson and require registration at http://www.unmc.edu/its/training.htm (you don’t need to register for drop in sessions). If you have requests for additional Word training, contact email@example.com
Question: Can someone help me determine how to best save email and files for easy searching?
Answer: Unfortunately, only you and your colleagues best understand your work flow and requirements. The new year is a great time to resolve to get better organized. This means brainstorming and possibly changing your business practices so that email is NOT used as your records retention/file storage location. Since only a limited amount of Lotus Notes mail (if any) will be migrated to Outlook, and because the new email system has size limitations and no automatic archiving, we must find ways to work more efficiently. PCMAG has a series of excellent articles addressing this topic which will give you some suggestions.
In addition, concentrate on which Lotus Notes mail you want to keep and less on deleting. Save those messages in a folder called “Keep” or rename folders with “keep” before the folder name to easily identify them later. You will be able to convert those to PDF or forward emails to Outlook for several weeks after the conversion to Outlook.