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:
- Goodwill Community Free Learning Online Tutorials
- Windows 7 Training (and Windows 8)
- Microsoft Office Training
- Microsoft Showcase – Casual Short Videos
- Microsoft Office 2007 Demos (usually 5-10 min) – Access - Excel - PowerPoint - Word - Publisher
- Microsoft Office 2007 Demos on other products – Project - Onenote - Infopath - Outlook – Visio
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