UNHCE Information Technology & Distance Education Blog: Microsoft Archives
October 13, 2011
From PSU Ag Science IT: http://agsci.psu.edu/it/how-to/use-flags-and-reminders-in-outlook
Use Flags and Reminders in Outlook
Flagged email messages help you better manage your mail. Flagged messages create to-do items either for you alone or for you and the recipients of the email message.
August 24, 2011
Learn All the Microsoft Word Keyboard Shortcuts with This Printable Cheatsheet (August 23, 2011, LifeHacker)
Using keyboard shortcuts can really speed up your use of software, and Microsoft Word has tons of them!Microsoft Word offers many--at least 247--keyboard shortcuts to speed up your document creation workflow. If you don't know all of them yet, grab this PDF or doc file as a handy reference.
January 16, 2008
November 8, 2007
Many people on campus are using Microsoft Office 2007. Extension has no plans to upgrade to Office 2007 in the near future. If you receive documents in the new format (.docx, etc.) they can be opened in Office XP (our current suite) after installing the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. The compatibility pack is available for download from Microsoft.
October 25, 2006
With computer screens getting larger, video resolutions getting higher, and eyeballs getting older, the zoom feature is a great tool to learn to use. Unfortunately, Word doesn't provide a quick way to access the zoom feature strictly using the keyboard. You can remedy that shortcoming with the macros discussed in this tip.
Read the full tip: http://wordtips.VitalNews.com/T1410
You can link objects from other Microsoft Office documents into your Word document. You can manage the status of those links by using the Links dialog box, discussed in this tip.
Read the full tip: http://wordtips.VitalNews.com/T0766
When you install Word, it asks you to personalize your copy of the program with your name and contact information. This info can change over time, so it is helpful to know where you can change it within the program. Here's how to do it.
Read the full tip: http://wordtips.VitalNews.com/T0686
Sometimes it could be helpful to have Word substitute two characters for the one that you type, for instance to replace a slash with a slash followed by a no-width optional space. (This could possibly help in the proper breaking of information between lines in Word.) This can be accomplished with AutoCorrect, but you may want to carefully think through the change before doing it, as discussed in this tip.
Read the full tip: http://wordtips.VitalNews.com/T1793
October 11, 2006
Context menus appear when you right-click on different items in Word. These menus can be edited to add items, such as common fonts you routinely use. You can then apply a font to selected text by right-clicking and using your newly modified Context menu.
Read the full tip: http://wordtips.VitalNews.com/T1329
There are any number of reasons that the freezing could be occurring, and this tip describes a few things to check out to clear things up.
Read the full tip: http://wordtips.VitalNews.com/T1791
September 27, 2006
Some of the secondary menus used in Word can be made into floating toolbars, if you know the trick. It's not that hard; just click on the bar at the top of the menu and drag it to a new location, as described in this tip.
Read the full tip: http://wordtips.VitalNews.com/T0839
If you have two tables separated by a couple of blank lines, you can easily join the tables by simply removing those blank lines. When you do, you are still faced with the task of making the column widths of the two tables the same. How you perform the task depends on the version of Word you are using.
Read the full tip: http://wordtips.VitalNews.com/T0825
For some types of documents, you may need to include more than one table of contents. For instance, you might have a document that includes multiple chapters, and each chapter needs its own TOC. This tip explains how easy it is to create multiple tables of contents in your own documents.
Read the full tip: http://wordtips.VitalNews.com/T0772
September 5, 2006
The text within comments can be formatted using the same techniques used to format regular document text. In addition, you can modify the style on which comments are based in order to completely control how comments look. This tip explains how to get the formatting you want.
Read the full tip: http://wordtips.VitalNews.com/T1784
One of the units of measure understood by Word is the pica, which is equivalent to 1/6 of an inch. This tip explains how to enter picas into dialog boxes where measurements are required.
Read the full tip: http://wordtips.VitalNews.com/T0696
August 15, 2006
When you are using Word, it normally saves temporary AutoRecover files that reflect the latest state of your document. If you want these AutoRecover files to be stored in a certain place, you can configure Word to make that specification.
Read the full tip: http://wordtips.VitalNews.com/T0814
Once you've divided your document into columns, you may need to change the width of each column. Word allows you to change each column's width independent of the others. This tip explains how to perform this task.
Read the full tip: http://wordtips.VitalNews.com/T0606
When you start to create a document, you need to "lay it out" so that it is inviting and helpful to readers. This tip discusses some of the things you'll want to consider as you determine how wide your text columns should be.
Read the full tip: http://wordtips.VitalNews.com/T0605
It is often necessary to add hyphens (dashes) between the words in a phrase. If you need to perform this editing task often, you might appreciate the macro in this tip. Assign it to a shortcut key, and you can hyphenate phrases very quickly.
Read the full tip: http://wordtips.VitalNews.com/T1779
July 26, 2006
Microsoft redesigned much of the Windows interface in Windows XP, but if you're not a fan of the new two-column Start menu, you can easily revert to the classic one-column version.
Simply right-click on the taskbar and choose Properties. Select the Start Menu tab and then select the Classic Start Menu option button. If you click on the Customize button you can choose exactly which options you'd like to display on the one-column Start menu.
July 10, 2006
Not only does Word allow you to maintain a custom dictionary of correctly spelled words, but it allows you to keep an "exclusion list" that identifies words that should not be spell-checked. Updating the exclusion list is not that easy of a task, unless you create your own command (like the one in this tip) that does the updating for you.
Read the full tip: http://wordtips.VitalNews.com/T0817
Your printer may be able to print on many different sizes of paper, but if you don't format your document correctly it will never know which of those paper sizes to use. This tip explains just how easy it is to format your document for a particular paper size.
Read the full tip: http://wordtips.VitalNews.com/T0786
June 8, 2006
If you merge information into a Word document from Excel, you know that it can sometimes be challenging to get the information imported in just the way you expect. Case in point: leading zeroes in ZIP Codes. What do you do if the zeroes don't appear in the merged data?
Read the full tip: http://wordtips.VitalNews.com/T1760
April 19, 2006
One of the nicest features of Office XP is the ability to copy multiple clips to the clipboard without erasing the previous one. You can use this functionality outside of Office too.
Using the Office Clipboard with Other Applications
Office XP lets you dock the Office Clipboard in the Windows taskbar so that you
can use it with any application. As long as the Office Clipboard remains open in
the taskbar, users can cut or copy multiple items from any file and paste one--or
all of them at once--into any Office application.
For example, suppose you found three items on the Web that you want to save to
a Word document. Using the system Clipboard you would need to copy and paste
each item individually, but that's unnecessary when you use the Office Clipboard.
Follow these steps to cut and paste between applications:
1. In Word XP, press [Ctrl]C twice to dock the Office Clipboard icon in
the status section of the Windows taskbar.
2. Minimize Word on the desktop.
3. Open Internet Explorer and copy the first item. The following message
is displayed next to the Clipboard icon: "1 of 24 - Clipboard item
collected."
4. Continue copying items. As each item is copied, Office displays a
message indicating the number of the item on the clipboard.
5. Open the Word document into which you want to paste the items and, in
the taskbar, double-click the Clipboard icon to display the task pane
containing the items copied to the Clipboard.
6. In the Word document, position the cursor where you want the copied
items to appear.
7. Click Paste All to paste all items at once. To paste one item at a time,
position the cursor where you want the item to appear in the document,
and double-click the desired item in the task pane.
April 13, 2006
When you’re trying to look through a large document and find something that appears different visually, such as a map, table, or graphic, try using Document mapping.
Document mapping produces small replicas of the page layouts in a sidebar on the left side of the screen. You can scroll up and down the document much more easily using document mapping, than paging through multiple pages.
To use this feature In Word:
Select View\document map. (Note: If the document is an outline, it will show the outline and clicking on an item will bring you to that area in the document. You may have to widen the left window to make the text legible.)
There are three great methods one can use to find a document using Office applications. For further information, click on the link below.
I. The first is to use the Preview function. (See: http://extension.unh.edu/blogs/itde/archives/001669.html )
II. The second is sorting by date. (See: http://extension.unh.edu/blogs/itde/archives/001670.html )
III. Lastly, you can try using Searching Tools (See: http://extension.unh.edu/blogs/itde/archives/001671.html )
If you are having difficulty locating the document, there are some search
features which can be of assistance.
To do a search from within Office 2002 (XP) applications, select File and then Search. A sidebar will appear with search options.
You can enter a text string you are sure is contained within the document.
The lower part of the menu allows you to refine your search to search in a
certain area or directory (and its subdirectories.) You can also confine
your search to certain filetypes. Access those options by clicking on the
down arrow next to the options.
Hint: When doing a search, look for the most obscure string you are sure
would be in the document or filename. For instance, if you are looking for
the UNHCE ITDE Strategic Plan, searching on Extension, Cooperative,
UNHCE, or strategic may produce a multitude of documents. If the team
was listed in the document, you know Mike Sciabarrasi was on the team,
and you don’t have his name in many other documents, a search on a
document containing the text Sciabarrasi will be faster and produce fewer
hits.
More advanced search options are available by selecting File\open from
the menu system. When the popup window comes up, select Tools and
then Search. Clicking on the advanced search tab allows you to search
based on several criteria, such as filename.
April 12, 2006
You can find documents more quickly by sorting the listing when you go
to open a document. When you go to the file open area, select view. (The
icon on the right side of the toolbar that looks like a miniature table.) On
the view menu, select details.
Clicking on the top of a column will sort by that column. This is helpful if
you are looking for a certain date, or want the list alphabetized. You can
also sort by file type or size.
Office applications will give you a preview of a document before you
open it. This can be helpful and a timesaver when you are looking for a
multi-page document or one with a lot of graphics or tables.
Select File\open from the menu system. When the pop-up window comes
up, select view. (This is an icon on the right side of the toolbar that looks
like a miniature table.) On the view menu, select preview.
April 7, 2006
Ever had a PDF print with lines in the graphic or a box over the graphic? If the document prints from other computers fine, the reason is probably due to low system resources. To print a PDF you must have at least 50% of your systems resources available. Reboot your computer and open Adobe Acrobat Reader. Print document. The graphics should appear without lines or boxes. However, if the document is large and you are printing from the web, you should print only a few pages at a time or if multiple graphics per page, try printing one at a time.
April 5, 2006
If your work involves a lot of typing, each keystroke you save helps you work more efficiently. Here's a tip that can help you virtually eliminate the need to perform the simple act of pressing the [Shift] key to capitalize the first letter of a sentence, depending on the kind of text you type.
Here's how it works:
1. Go to Tools AutoCorrect and click the AutoCorrect tab.
2. Click the check boxes for the options Capitalize First Letter Of Sentences and Capitalize Names Of Days.
With these options activated, you don't have to press [Shift] to capitalize the first letter of a sentence. After you type a period or a question mark to finish one sentence and type the first word of the next sentence, Word will automatically capitalize the first letter of that word. In addition, with the Capitalize First Letter Of Sentences option enabled, you can type the singular or plural form of any day of the week (e.g., Friday or Fridays) and Word will automatically initial cap each instance.
While you're in the AutoCorrect menu, go ahead and create your own AutoCorrect entries for the months of the year. For example, in the Replace field, type january, then type January in the With field. Click Add to include this change in the list. Click OK to save and close. How does Word know when the period you've typed is used in an abbreviation and not at the end of a sentence? Also under AutoCorrect, click the Exceptions button to display a list of common abbreviations that require periods. Word won't automatically change the capitalization of a word that follows any abbreviation in this list. You'll want to make sure that common abbreviations like Dr., Mr., Ms., and Mrs. aren't included in the Exceptions list so that Word will initial cap the names that follow them.
April 3, 2006
Here are some shortcuts to dialog boxes and functionality you can invoke by double-clicking your mouse:
1. Open the Page Setup dialog box, which provides access to margin, paper size and orientation (portrait and landscape), and layout (section start, header/footer control) options by double-clicking on the ruler bar. (If the ruler isn't shown, use the View/Ruler command.) Note: If you do not have a printer installed, the Page Setup dialog box may not appear. (Alternative: Use the File/Page Setup command.)
2. Double-click "TRK" in the status bar at the bottom of the work area to turn Track Changes on. This feature triggers Word to use a different color when displaying your changes, so the document's author can easily spot your work. (Alternative: use the Tools/Track Changes command.)
3. Double-click in the location information in the status bar (any spot within the area that shows the page number, section number, vertical position, line number, and column number of the blinking insertion bar) to open the Go To menu. By default, the dialog box is ready with "Go to Page" (you enter the page number). The tabbed dialog box also provides access to Find as well as Find and Replace commands. (Alternative: Press F5, Ctrl+G, or use the Edit/Go To command.)
4. Double-click in any empty area surrounding the top toolbar to open the Customize dialog box to tailor the toolbar to your liking. (Alternative: Right-click in the same area and choose Customize.)
5. Double-click on the speller icon in the status bar to begin the spelling checker. (Alternative: Tools/Spelling and Grammar menu command, or press F7.)
6. Double-click on the splitter bar (just above the up- pointing arrow in the vertical scrollbar) to open two equal- sized panes for the same document. This allows you to edit two different areas of the same document. (Tip: Double- click on the border between the two panes to return to a single-pane view.) (Alternative: Window/Split menu command.) 7. Select a word by double-clicking it. (Triple-click to select the current paragraph.)
Do you like to use the fastest method possible to get your work done? If so, you probably use keyboard shortcuts whenever possible, rather than going through the menu system. Access 2000 and 2002 support a number of keyboard shortcuts that can save you time when you're entering records or working on a new project.
Keep this list of shortcuts handy for easy reference:
* [CTRL]' inserts the data from the same field in the previous record.
* [CTRL]: inserts the current time.
* [CTRL]; inserts the day's date.
* [CTRL][ENTER] inserts a carriage return in a memo or text field.
* [CTRL]C copies the current selection.
* [CTRL]F summons the Find And Replace dialog box.
* [CTRL]N opens a new database.
* [CTRL]O summons the Open dialog box.
* [CTRL]P summons the Print dialog box.
* [CTRL]S saves the current database.
* [CTRL]V pastes the contents from the clipboard.
* [CTRL]Z undoes the most recent change you've made.
* [ESC] undoes changes made to the current field.
* [ESC][ESC] undoes changes made to the current record.
* [F11] displays the database window.
1. If your menus only show the most recently used commands, display all commands by selecting Tools/Customize, choosing the Options tab, and checking the “Always show full menus” option.
2. If you like abbreviated menus, show the full menu by leaving the drop-down menus displayed for at least 6 seconds. Turn on this feature by selecting Tools/Customize, choosing the Options tab, and un-checking the “Always show full menus” option checking the "Show full menus after a short delay" option.
3. You can also display the full menus by clicking the down-pointing double arrows at the end of the menu list or by double-clicking the main menu options (for example, double-clicking the File, Edit, View, Insert, etc., menu options in Word).
4. In Word and Excel, you can close all open documents at once. Hold down the Shift key as you click on the File command. The Close command changes to Close All. (Note: you'll have to use your mouse to select the File command; pressing Alt-F doesn't work.)
UNHCE has published a 12-page document with links and directions for several of the most popular features in Microsoft Word XP. TO access this document, go to:
http://extension.unh.edu/Intranet/ITDE/WordTips.pdf
March 30, 2006
Read the full tip: http://wordtips.VitalNews.com/T0788
Courtesy of: Allen Wyatt's WordTips
Sometimes an automatic number isn't the only thing you need at the
Read the full tip: http://wordtips.VitalNews.com/T0644
Courtesy of: Allen Wyatt's WordTips
March 29, 2006
Courtesy of: Allen Wyatt's WordTips
February 22, 2006
A new vendor, CompuMaster, is available. They offer classes in Microsoft applications and PhotoShop. Classes are offered in various applications through out NH, including Portsmouth, Concord, and Manchester. Some classes are also offered in MA and Vermont, which may be more convenient for some county staff.
Classes are generally $199 for one day or $399 for 2 days. They offer group discounts for groups of 4 or more.
For further information, consult their website at: http://www.compumaster.net/index.html/Z/03824/ST/CMCONPS
February 20, 2006
A point is a typographical measurement. Points are used for many types
of measurements in Word, PageMaker and related applications. This tip explains how you can enter them directly into dialog boxes in Word.
Read the full tip: http://wordtips.VitalNews.com/T0075
Courtesy of: Allen Wyatt's WordTips
February 13, 2006
You can increase the flexibility of tables by creatively merging cells
to get just the look and layout that you need. This tip describes a
couple of different ways you can perform the merging tasks. It covers
using menus and the more flexible toolbar approach.
Read the full tip: http://wordtips.VitalNews.com/T0768
Courtesy of: Allen Wyatt's WordTips
Paragraph marks (created by pressing Enter) and line breaks (created
by pressing Shift+Enter) are two of the most common special characters
in a document. Word allows you to easily search for these characters,
using the method described in this tip.
Read the full tip: http://wordtips.VitalNews.com/T0007
Courtesy of: Allen Wyatt's WordTips
Cover pages, which often need to be formatted different than the main
body of a document, can easily be created in Word. The trick is to add
a section break between the cover page and the body. You can then
format each section independently of the other. This tip explains this
concept and how to add the necessary section break.
Read the full tip: http://wordtips.VitalNews.com/T0182
Courtesy of: Allen Wyatt's WordTips
Graphics placed in a document can be "cropped" so that parts of the
graphic are hidden from display. This tip explains how to crop
graphics and also discusses why making such croppings doesn't result
in a smaller document.
Read the full tip: http://wordtips.VitalNews.com/T0158
Courtesy of: Allen Wyatt's WordTips
MVP ( http://word.mvps.org/ ) offers free articles and tutorials on a variety of Word topics.
The tutorial section is available at: http://word.mvps.org/Tutorials/index.htm
February 8, 2006
Sometimes a change of mouse pad or mouse causes the way your mouse responds to make it more difficult to use. You can change the speed of your mouse pointer to adjust for your individual set up. To do so in Windows XP:
* Go to Control Panel
* Select Mouse
* From the tabs on the top, select Pointer Options
* In the top box, titled "Select a pointer speed:"
* Slide the arrow along the continuum to the desired speed. (Slower or Faster)
Be sure "Enhance Pointer Precision" is checked.Adjusting the speed of your mouse pointer:
February 7, 2006
Granite State College (formerly CLL - College for Lifelong Learning) has announced several Microsoft training opportunities in their offerings this spring. Sessions are at the Portsmouth campus (formerly Pease) and Littleton campus, except as noted.
Check their calendar for dates at your preferred campus.
Classes offered include:
Intro to Microsoft Word I
Microsoft Word II
Intro to Microsoft Excel
Microsoft Excel II
Intro to Microsoft PowerPoint (Littleton campus, only)
Intro to Microsoft Access
Microsoft Access II
Classes in Littleton are from 9:00-4:00 and Portsmouth classes run from 9:30-4:30. The cost is usually $120 per class, but UNH employees can use a staff waiver to get 1/2 tuition. (County employees would have to pay full price.) Participants are eligible for 0.6 CEUs.
For further information on these classes, or to see other listings offered through Granite State College, go to: http://www.granite.edu/news/assets/workshops01.pdf
January 19, 2006
Word allows you to sort not only information in tables, but also
regular selections of text. This tip explains the easiest way to do
this using the Sort Text dialog box.
Read the full tip: http://wordtips.VitalNews.com/T0724
Courtesy of: Allen Wyatt's WordTips
(a.k.a.: Turning on Picture Placeholders)
Documents with lots of graphics can slow down the editing of a
document, or they can be distracting. One way to deal with lots of
graphics is to turn on picture placeholders. This feature, described
in this tip, shows positioning information for a graphic, but does not
display the graphic itself.
Read the full tip: http://wordtips.VitalNews.com/T0160
Courtesy of: Allen Wyatt's WordTips
Gridlines allow you to see the boundaries of a table, even if you have
table borders turned off. Word allows you to specify whether you want
the gridlines turned on or off, by default. This tip explains how that
works, in addition to how gridlines relate to borders.
Read the full tip: http://wordtips.VitalNews.com/T1729
Courtesy of: Allen Wyatt's WordTips
January 4, 2006
Allen Wyatt's Word Tips is a web page which offers information in a searchable format to answer common questions as well as "gotcha's" people encounter when using Word.
To access this site, go to: http://wordtips.VitalNews.com
Hewlett-Packard (HP) offers free on-line training ,which is available 24/7.
Offerings change on a rotating basis. Current offerings include PhotoShop, the Office Suite, Windows, and Dreamweaver.
Information on their offerings is in our Training Resources Guide at: http://ceinfo.unh.edu/Intranet/ITDE/trg/indextrg.htm
January 3, 2006
Copy a paragraph from one document to another, and the results may be
different than what you expect. The reason for this may not be clear,
but is understandable if you know how Word treats styles. This tip
explains the underlying principles that affect such
document-to-document paragraph copies.
Read the full tip: http://wordtips.VitalNews.com/T0097
Courtesy of: Allen Wyatt's WordTips
You can easily convert regular text into a table using a couple of
different methods. This tip explains how to make the conversion as
problem-free as possible.
Read the full tip: http://wordtips.VitalNews.com/T0756
Courtesy of: Allen Wyatt's WordTips
You are not limited to only using Arabic numerals in your numbered
lists. Word allows you to select from a wide range of numbering
schemes. You only need to use the Customize Numbered List dialog box
to make the changes, as outlined in this tip.
Read the full tip: http://wordtips.VitalNews.com/T0704
Courtesy of: Allen Wyatt's WordTips
Word makes it easy to align information within a table cell, both
horizontally and vertically. The results of formatting vertically can
be affected by the formatting used in a paragraph, as described in
this tip.
Read the full tip: http://wordtips.VitalNews.com/T1166
Courtesy of: Allen Wyatt's WordTips
December 22, 2005
Word 2002 crashes at times, depending on how you open
files. This seems to be a problem that Microsoft knows about, and
there is a fix. If the problem is not caused by what Microsoft thinks
it is, then guidance is provided on how to start tracking down the
problem.
Read the full tip: http://wordtips.VitalNews.com/T1724
Courtesy of: Allen Wyatt's WordTips
If the insertion point is located in a table, pressing the Tab key
results in the insertion point moving to the next cell in the table.
If you want to actually insert a tab character within a cell, just
remember to hold down the Ctrl key as you press Tab.
Read the full tip: http://wordtips.VitalNews.com/T0713
Courtesy of: Allen Wyatt's WordTips
December 21, 2005
A new vendor, CompEd Solutions, will be offering a class in Advanced Excel in Manchester, NH on March 10, 2006.
The cost is $159 per person, but if you get a group of 4, the 4th person is free, making the net cost about $119 per person.
For a syllabus, to register or for further information, go to: http://www.nationalseminarstraining.com/Seminars/Advanced%20Training%20for%20Microsoft?%20Excel/1520517/index.html
A listing of all their classes can be found at: www.nationalseminarstraining.com
Note: They also offer a book title Excel Tips & Tricks with Chuck Chauvin for $99. See their site for further information.
December 5, 2005
Tips and tutorial for repeating table headers across multiple pages in word procesing software can be found at:
* Repeating Table Headers (Microsoft Word XP)
* Repeating Table Headers (WordPerfect 10)
November 18, 2005
CIS has announced their training sessions through January of 2006. Sign up early for CIS classes. Not only are the most popular classes oversubscribed early; CIS cancels classes which are under-enrolled two weeks prior to the class date.
Vendor-based classes are being offered in the following subjects through January of 2006 :
* Access
* Acrobat
* Dreamweaver
* Excel (2 levels)
* PowerPoint (2 levels)
* PhotoShop
FREE Sessions offered by CIS
* Scanning Demonstration for Faculty 12/15 (available to all staff)
* Desktop Video Demonstration 12/21/05 or 1/25/06 (Note - these sessions are available to faculty only)
* Computing @ UNH: What?s New with Windows XP 1/26/06 (available to all staff)
Note that they have also listed offerings for February and beyond. They will continue to add to their offerings as they become available.
To see current offerings and their descriptions, or sign up for a session, use their web site at: http://training.unh.edu They keep adding to their offerings, so check back for updated information.
November 17, 2005
Fred Pryor Training offers training in various Microsoft applications. Their pricing is VERY competitive. In many cases, they charge less than the discounted price which New Horizon's (a contracted vendor) charges through CIS.
Upcoming classes include:
MS Office Cost: $39; Locations: Keene, Manchester, Portsmouth
MS Excel - One-Day seminar Cost: $79; Locations: Keene, Manchester, Portsmouth, West Lebanon
Advanced Excel Cost: $99; Locations: Keene, Manchester, Portsmouth, West Lebanon
Note: All classes are one full-day session, even though one has "one-day" listed in its title.
DISCOUNTS: If you sign up for both the Excel One-Day seminar and the Advanced Excel class, you get a further discount of $50, making the total cost $128 for the two seminars combined. Group discounts of $5-$10 per registrant are also available for groups of 5 or more.
For descriptions, further information, or to register for these course, refer to Fred Pryor's Training site
October 24, 2005
To print an Excel spreadsheet with (or without) gridlines:
1) Open the desired worksheet in Excel
2) Click on the file drop-down menu
3) Select Page Setup on the File menu
4) Select the Sheet tab on the top of the Page Setup menu
5) Select (or clear) the Gridlines check box
6) Print the worksheet with the revised setting
October 5, 2005
CIS offerings for October & November include several FREE sessions in addition to their vendor-based training.
CIS has announced training in the following topics for October & November.
Vendor-based classes are being offered in:
* Access
* Adobe Acrobat
* Dreamweaver
* Excel
* Photoshop
* PowerPoint
Vendor-based classes are generally one or 2 days. The cost is typically $99 per day. They are held at the CIS training lab, 1 Leavitt Lane, at the UNH Durham campus.
In addition, FREE sessions are being offered, including:
* Several sessions of BlackBoard on a variety of topics
* Scanning Demo
* Internet 2
and
* Desktop Video Demo (Faculty only)
Sign up early for CIS classes. Not only are the most popular classes oversubscribed early; CIS cancels classes which are under-enrolled two weeks prior to the class date.
Some December offerings have also been posted.
To see current offerings and their descriptions, or sign up for a session, use their website at: http://training.unh.edu They keep adding to their offerings, so check back for updated information.
Granite State College (formerly CLL - College for Lifelong Learning) has openings in several Microsoft training sessions for this fall. Sessions are at the Portsmouth campus (formerly Pease.)
NOTE - Classes are offered at other campuses. See the July posting in our BLOG for other listings.
Classes offered this fall at the Pease Tradeport include:
Intro to PowerPoint - October 12
Intro to Access - October 17
Access II - October 24
Intro to Excel - October 26
Access III - November 7
Excel II - November 9
Classes run from 9:30-4:30. The cost is usually $120 per class, but UNH employees can use a staff waiver to get 1/2 tuition. (County employees would have to pay full price.)
For further information on these classes, or to see other listings offered through Granite State College, go to: http://www.cll.edu/
September 2, 2005
The state of NH offers training courses conducted by professional trainers in a variety of computer topics.
The 2005-2006 training calendar has been announced. It includes training in:
* Basic Computer skills
* Office, including Access, Excel, PowerPoint, and Word
* Windows XP
* Browsers & using the Internet
Download this spreadsheet containing a list of courses relevant to UNHCE staff. It lists courses chronologically, but can be sorted by application (Such as "Access," or searched using Ctrl + F and inputting the topic.
To view the entire 2005-2006 catalog, go to: http://www.nh.gov/hr/docs/Catalog_of_Courses.pdf
The registration form is available on page 12 of the guide.
Note: This is an 87-page document. To ease in navigation, click on the Bookmark tab on the left side of your screen to open the bookmarks. Clicking on a bookmark will take you to that section of the document.
For questions or further information, contact Ruth Viola at: Ruth.Viola@NH.Gov or call (603) 271-1434
Remember that UNH staff are entitled to discounts. For discount information, go to: http://ceinfo.unh.edu/Intranet/ITDE/trg/unh_disc.htm
August 25, 2005
CIS (Computing & Information Services) has announced their training list for this fall.
Sign up early for CIS classes. Not only are the most popular classes oversubscribed early; CIS has begun to cancel classes which are under-enrolled two weeks prior to the class date.
Courses which will be offered in September and October include:
* Adobe Acrobat 6.0 - Level 1
* Adobe Illustrator
* Blackboard - FREE courses in different topics
* Dreamweaver (2 levels)
* Excel - 3 levels
* Photoshop - 2 levels
* PowerPoint - 2 levels
Blackboard classes are offered for free. Vendor-based classes cost $99 per day. Many topics are 2-day sessions.
To see current offerings and their descriptions, or sign up for a session, use their website at: http://training.unh.edu They keep adding to their offerings, so check back for updated information.
August 9, 2005
To change the default font in Excel, select the Tools option in the menu bar on top of the screen.
From the Tools dropdown menu, select:
* Options
* General
* Standard Font
* Select desired Font style and size
The changes will take effect AFTER you close and reopen Excel.
To change the font used in a chart in Excel:
Click the chart text, or select the individual characters you want to format.
If a chart title or text box is linked to a worksheet cell, you can change the formatting of all characters in the title or text box at the same time, but you cannot change individual characters.
To change the formatting for all of the text in the chart at the same time, click the blank area between the border of the chart and the plot area to select the chart area.
On the Formatting toolbar, click a button for the format you want.
To see other font options, such as superscript and subscript, click the text you want to change.
On the Format menu, click the command for the chart item you want to format ? for example, Selected Axis Title or Selected Object. (The name of the command depends on the chart item selected.)
Ten select the options you want on the Font tab.
August 5, 2005
Selecting a theme allows you to change the colors & design of boxes on your desktop as well as in some of your applications.
This can be used to enhance visibility, select colors you desire, ease eye fatigue, or jazz up your desktop.
To change the theme click on:
The Start Menu (Lower lefthand corner of your screen)
Settings (Windows 98 only)
Control Panel
Display
Appearance (Windows 98)
Theme (Windows XP)
Select the theme
Note - there's a preview window so you can see what the theme will look like.
Click on OK to save the setting
July 19, 2005
To rearrange Internet Explorer's toolbars, click on the end of
any of the toolbars and hold down the mouse button while dragging
it to a new location. You can also shrink or enlarge the height
or width of a toolbar by hovering your mouse pointer over the
edge of a toolbar until it changes to a double-sided arrow. Then,
click and drag the edge closer to or farther from the opposite
side to change the toolbar's size. Finally, you can disable,
enable, or change what's available on any of these toolbars by
right-clicking on one and making the appropriate changes in the
resulting shortcut menu. You can also access this capability by
choosing View | Toolbars from the Internet Explorer menu bar.
Courtesy of: Element K tips
July 12, 2005
Granite State College (formerly College for Lifelong Learning) has announced the following computer classes for Fall 2005:
Word I & II - Littleton Campus
Excel I & II - Portsmouth & Littleton
Intro to PowerPoint - Portsmouth & Littleton
Access I & II - Portsmouth & Littleton
Access Level III - Portsmouth
The cost of these classes is $120. Discounts are available for UNH staff. See: http://ceinfo.unh.edu/Intranet/ITDE/trg/unh_disc.htm for discount information.
For further information on these classes, or to see other listings offered through Granite State College, go to: http://www.cll.edu/
June 16, 2005
Microsoft has a Tips site on "How to Use Windows XP." It contains 365 tips for the average user. To access it, go to:
http://www.microsoft.com/windowsxp/using/default.mspx
June 15, 2005
In Excel 2002 you can now jazz up your headers or footers with
graphics. To do this, choose View | Header And Footer from the
menu bar. In the Page Setup dialog box, click either the Custom
Header or Custom Footer button. In the resulting dialog box,
click in the section where you want the graphic to appear (either
the Left, Center, or Right section). Then, click the Insert
Picture button. Locate and select the graphic file then click
Insert. You can also double-click on the graphic filename to
insert the graphic. Now, click OK twice to return to your
workbook.
Use Print Preview to see how the graphic looks on the worksheet.
To adjust the size or appearance of the graphic, open the Custom
Header or Custom Footer dialog box again. Place your insertion
point in the section that contains the picture placeholder,
&[Picture]. Then, click on the Format Picture button in the
dialog box to change the size, scale, or color of the image.
Click OK three times to return to your workbook.
Courtesy of: Element K tips
In previous versions of PowerPoint, you could only apply one
design template to a presentation. If you wanted to have more
than one, you had to jump through some hoops. Now, PowerPoint
2002 allows you to have multiple design templates within a
presentation. To apply a design template, first create the slides
with one design template. Then, to add another design template to
certain slides, in the Slide Pane select the slides that will
display the second template. You can hold down the [Ctrl] key and
click on non-adjacent slides. To select a group of adjacent
slides, select the first slide in the group, hold down the
[Shift] key and click on the last slide in the group. All the
slides in-between are selected. Then, apply a new design either
by clicking on the Design button on the Formatting toolbar, or by
right-clicking on a selected slide and choosing Slide Design. In
the Design task pane, select the template and it's applied to all
the preselected slides.
Courtesy of: Element K tips
Do you need to save individualized copies of documents for a series of
individuals? This tip describes how to do just that, without using
mail merge. Individual names are pulled from a text file and placed in
the header of each document just before the document is saved.
Read the full tip: http://wordtips.VitalNews.com/T0464
Courtesy of: Allen Wyatt's WordTips
June 9, 2005
The State of New Hampshire offers training courses for a nominal fee to UNH and state employees.
Offerings this summer include:
Microsoft Access - 2 levels
Microsoft Excel - 2 levels
Microsoft PowerPoint
Microsoft Word - 2 levels
In addition, they offer short courses in topics such as PC Fundamentals, and Special topics using Office.
To see this summer's listings, go to: http://www.nh.gov/hr/docs/training_courses_spring_2005.pdf Page 7 of this guide lists the summer class calendar.
CLL will be offering computer workshops on the following applications during July and August.
Microsoft Access - 3 levels
Microsoft Excel - 3 levels
Microsoft Word
All of the above offerings are located at their Portsmouth Center
In addition, they offer a credit course in Software Tools. That is offered both as a traditional class located in Rochester, and as an Interactive (on line) course.
For further information, please consult their summer listings at: http://www.cll.edu/news/assets/locationlist_summer05.pdf
June 6, 2005
CIS (Computing & Information Services) has announced their training list for June & July. There are several FREE sessions in addition to their vendor-based training. Some August offerings have also been posted.
Sign up early for CIS classes. Not only are the most popular classes oversubscribed early; CIS has begun to cancel classes which are under-enrolled two weeks prior to the class date.
As of this posting, CIS has announced they will be offering training in the following topics this summer:
* Adobe Acrobat
* Blackboard - 13 FREE courses in 5 different topics
* Dreamweaver (3 levels)
* Excel - 2 levels
* Photoshop - 2 levels & special topics
* PowerPoint - 2 levels
In addition, CIS offers a FREE training series, entitled Computing @ UNH. Offerings include:
Using Photoshop to Enhance Digital Images - July 27th
Computing @ UNH: Using Dreamweaver MX 2004 to Create Webpages - August 24th
Scanning Demonstration (offered three times)
* June 23rd
* July 28th
* August 25th
To see current offerings and their descriptions, or sign up for a session, use their website at: http://training.unh.edu They keep adding to their offerings, so check back for updated information.
May 3, 2005
Source: Element K Tips newsletter
Have you ever added an item to a list that has already been
formatted and then had to format the new item to match the
others? Excel 2002 can automatically format the new item using
the Extended Formats And Formulas option. For this feature to
work, at least three of the preceding five rows must have the
same format.
For example, let's say you have five items listed in cells A2
through A6. Format the items any way you want. In cell A7, type a
new item for the list. When you press [Enter], the new item is
formatted to match the preceding items.
This feature also copies down a formula if the preceding rows
contain the same formula. For example, suppose you have several
rows of data in columns B through G with column H containing a
formula at the end of each row. When you add a new row data to
the bottom of the list and press [Enter] for the last item of
data, the formula will be filled in the last cell for that row.
To turn this option on or off, choose Tools | Options from the
menu bar and click on the Edit tab. On the right side of the
dialog box, either select or deselect the Extend List Formats And
Formulas check box.
March 14, 2005
Purdue has a web site with Free tips for various applications we use. Topics include:
The Office Suite (Access, Excel, PowerPoint, and Word), along with Acrobat, clip art, Browsers (Both Explorer and Netscape), and information on palm pilots.
To access this site, go to: http://sharepoint.agriculture.purdue.edu/agit/instructional_tools.aspx
March 10, 2005
Due to funding issues, the Land Grant Training Alliance website will no longer be available after May 1, 2005.
This site contains links to a variety of University and Extension-sponsored training opportunities. In addition, it contains tutorials on a variety of topics. Some of these tutorials might be helpful in assisting you to make technology work better for you. Although many tutorials are not in the most-current version of the software, most of the information is applicable.
Of particular interest are:
March 9, 2005
Source: WordTips by DCI
Smart Tags were developed by Microsoft as a way for companies or
individuals to mark certain words so they lead to additional
information. For instance, a person's name or a company name or some
other proper noun could become a Smart Tag. If so, it appears
on-screen with a wavy purple underline that indicates the word (or
phrase) can be clicked for more information. In some ways, a Smart Tag
is similar to a hyperlink.
You can turn off Smart Tags, so they are not saved with a document, by
following these steps:
1. Choose Options from the Tools menu. Word displays the Options
dialog box.
2. Display the Save tab.
3. Clear the Embed Smart Tags check box.
4. Click OK.
Now you can save your document as you normally would. The setting is
stored with the document, and Smart Tags won't be saved with this
particular document unless you go back and explicitly change the
setting.
If you want the saving of Smart Tags turned off for all your
documents, you need to open the templates you use to create documents,
and then perform the steps just listed. For instance, load the
Normal.dot template and perform the four steps. Save the template, and
then the setting will be turned off for any future documents you
create that are based on Normal.dot. Existing documents, even though
they may be based on Normal.dot, will need to be individually changed.
If you prefer, you can create a small macro that will turn the option
off for you:
Sub OptSmartTagsOff()
ActiveDocument.EmbedSmartTags = False
End Sub
You likely have more than a few sites saved to your Favorites
list that, no matter how long you spent searching, you'd never be
able to find again. To keep your Favorites saved for all of
eternity, it's a good idea to back up your Favorites list to a
disk. This way, you can carry them with you as you change or
upgrade computers or as a backup means of preservation should you
ever need it.
To do so, insert a disk into your floppy drive. Next,
double-click on My Computer and select your C drive. Navigate to
your username folder in the Documents And Settings folder, and
then right-click on your Favorites folder. Select Send To from
the shortcut menu and choose the drive you want to copy to
(usually your A drive for a floppy disk). A copy of your
Favorites is then saved to that location, which you can now take
with you wherever you go, or store away in case of a PC meltdown.
From Element K Journals Newsletter
One addition to Windows XP that you can probably live without is
the highlighting of newly added programs in your extended Start
menu. When new software is added to your PC, the new program
appears in a different color on the All Programs list,
immediately drawing your attention to it whenever you access the
All Programs list.
To remove the menu highlighting, right-click on the Start button
and choose Properties. On the Start Menu property sheet, click
the Customize button, and then select the Advanced tab. Deselect
the Highlight Newly Installed Programs check box, and then click OK.
From Element K Journals Newsletter
If you're new to Windows XP, you might be surprised to see that
your favorite and often-used desktop icons are no-shows in the
new version of the operating system. If you'd like to return
these icons to your desktop, doing so is a breeze.
All you need to do is right-click on the desktop and then choose
Properties. Select the Desktop tab and then click the Customize
Desktop button. In the Desktop Icons panel, select the check box
that corresponds to an icon you'd like returned to the desktop.
You can choose to return the My Documents, My Computer, My
Network Places, or Internet Explorer icons. Finally, click OK.
From Element K Journals Newsletter
March 7, 2005
In addition to training listings for the next 2 months, and links to sources of that training, this update contains information on:
- The NewlyRevised Training Resources Guide
- A FREEBY for March
- Free Videoconferencing in-service – Advanced techniques
Read on!
March 2005 ITDE Training News
Updated Training Resources Guide!
The UNHCE Computer Training Resources Guide has been revised. There are new sections, including information on discounts and more sources of free or reduced-price training for UNHCE employees.
To view this newly-updated guide, please go to: http://ceinfo.unh.edu/Intranet/ITDE/trg/indextrg.htm
March Freebie
Element K offers free weekly tips in a variety of subjects, including: Corel WordPerfect, Windows, Photoshop, PageMaker, and the entire Office suite (Access, Excel, PowerPoint, and Word.)
For a complete listing of their offerings, or to subscribe to one of these weekly newsletters, go to:
http://www.elementkjournals.com/tips.asp
A NEW training offering on Videoconferencing is available to UNHCE staff
Dave Foote will be offering an in-service entitled Videoconferencing 201: Enhancing Your Videoconference with Tools and Teaching Techniques. It is open to UNHCE staff.
This training will be offered on March 17, with an April 20 repeat of the session.
To sign up for one of these sessions, please access our in-service signup calendar.
The following training opportunities are available in the next two months.
I. UNH CIS
Sign up early for CIS classes. Not only are the most popular classes oversubscribed early; CIS has begun to cancel classes which are under enrolled two weeks prior to the class date.
Vendor-based Training - CIS has arranged with outside vendors to offer classes on a variety of topics for a nominal fee. The cost is typically $99 for a full day or two half-day sessions, or $198 for 2 days or 4 half-day sessions. That is less than half the cost of the training offered to the public.
Classes in the following topics will be offered in the next two months.
- The class in Access on March 17 th has been canceled. They will be offering Access training – level one in June.
- Adobe Acrobat
- Dreamweaver - Level one, with Level two to follow in May
- Excel – Two levels
- PhotoShop – Levels One and Two.
Note: In May they will be adding a class entitled PhotoShop CS: Photoprinting & Color.
All Microsoft Office applications are taught using Office 2003. Dreamweaver is version MX 2004.
For further information, an outline of each course, or to register, please consult their web site at: http://www.cistrainingcenter.unh.edu/
II. UNH Division of ContinuingEducation (DCE) is offering in-service training opportunities in the following topics in the next two months.
- Adobe PageMaker
- Adobe PhotoShop
- Dreamweaver
- PowerPoint
Note that all UNH status employees are eligible for a tuition waiver on credit classes, and to a reduction (50% discount) on non-credit classes offered through the university system, which includes DCE. See the Human Resources website at: http://www.usnhhr.unh.edu/benefits/tuition-waiver.html for more information.
For further information on DCE classes, consult their web site at: http://www.learn.unh.edu/pcw/index.php
III. TheState of New Hampshire offers classes “at cost” to all UNH employees. This is at considerable savings from what one would pay with an outside vendor.
The state is offering classes in the following topics during the next 2 months.
- Access* - various levels & special topics
- Adobe Acrobat
- Dreamweaver – Two levels
- Excel* - various levels & special topics
- PageMaker - Two levels
- PowerPoint*
- Intro to Windows
- Word
* Note: In addition to general training in these areas, special topics are also offered using these applications.
Please consult their website for further information on the above listings.
To consult their website, go to: http://www.nh.gov/hr/docs/ Then scroll down to the section on training and select the term for which you’d like information. (Note – The URL for the specific calendar changes each semester. If you bookmarked their site, you may want to replace it with the new URL listed above. Then follow the directions for scrolling to the appropriate term’s document.)
Note – The state also offers a multitude of courses in other areas such as Effective management, strategic planning, supervisory techniques (certificate program), communication and writing skills, conflict resolution, grant writing, learning styles, and Myers-Briggs, to name a few.
IV. College for Lifelong Learning will be offering the following classes during the next two months.
Seacoast Region – In-services in the following topics are being offered in the Seacoast region in the next two months.
- Access (multiple levels)
- Excel (multiple levels)
In addition, they offer formal credit courses in computer topics which begin in January.
North Country Region
No current listings.
They offer formal credit courses in computer topics, such as Software tools. This semester began in January, but check out their listings for future semesters.
Merrimack Valley Region
No current listings.
They offer formal credit courses in computer topics, such as Software tools. This semester began in January, but check out their listings for future semesters.
The Connecticut Valley Region offersformal credit courses which began in January. Topics include Software Tools and Introduction to Computers. Check out their listings for future semesters.
For further information and to register, consult their website at: http://www.cll. edu / .
CBT and Training Resources Guide
Training Resource Listings
- Training Resources Guide. The UNHCE Training Resources Guide just underwent a major revision. Several new listings are already available. New sections include online tutorials and discounts available to UNH employees.
This guide contains information on training resources available in applications utilized by employees of UNHCE, including Microsoft Office, Adobe products (Acrobat, PageMaker, PhotoShop), as well as operating systems, and applications used by smaller audiences, such as PictureTel, DreamWeaver, Blue Ribbon YOUTH enrollment, or WordPerfect. To access this guide, go to: http://ceinfo.unh.edu/Intranet/ITDE/trg/indextrg.htm
- Computer Based Training (CBT) - Included in this guide is a listing of Extension or University-owned Computer-based Training CD-ROMs (CBT), which can be used for FREE. UNHCE has a library of CBT (Training CD-ROMs) available from the ITDE office. The CDs are free to UNHCE staff, and can be borrowed for up to 2 weeks. CIS also has free CBT available to be used on campus.
This CBT can be used interactively, and allows you to receive information on just the topics where you desire training. For instance, you can select a topic such as “Creating/modifying headers and footers” in Word. It will show you how to do that step-by-step. You can repeat any sections as needed, and skip to other sections.
For further information on our CBT and a listing of the offerings, go to: http://ceinfo.unh.edu/Intranet/ITDE/trg/trcdtoc.pdf
- New online tutorial section offered by ITDE
New tutorials are available on our ITDE website. You can view step-by-step demos showing techniques for accomplishing a variety of computer-related processes.
Topics include using various applications as well as general and Windows topics. Each demo is accompanied by documentation, so you can print out directions to do them on your own.
To access this new area, go to: http://cecf1.unh.edu/tutorials/index.cfm
To access the complete, Training Resources Guide, go to: http://ceinfo.unh.edu/Intranet/ITDE/trg/indextrg.htm
February 8, 2005
Element K offers free weekly newsletters with tips in a variety of subjects. (There is a separate newsletter for each subject.) Newsletter topics include: Corel WordPerfect, Windows, Photoshop, PageMaker, and the entire Office suite (Access, Excel, PowerPoint, and Word - one newsletter for each application.)
For a complete listing of their offerings, or to subscribe to one of these weekly newsletters, go to: http://www.elementkjournals.com/tips.asp
February 9, 2004
If advertisements are opening on your computer in a window titled Messenger Service , it may indicate that your system is not secure. You should disable the Messenger Service in Windows XP to help protect your computer from unwanted messenger spam and other potential threats.
Click here to see a tutorial on Disabling Messenger in Windows XP:
http://ceinfo.unh.edu/common/documents/MessSvc.htm
July 15, 2003
Thanks to everyone who responded to our on-line Training Needs Assessment Survey. We received 67 responses, which was more than we had hoped for.
Here are some of the highlights:
Respondents would like to receive training on the following applications (in order from highest preference): Access, PowerPoint, PictureTel, PhotoShop, Excel, Windows XP, PageMaker, Word, Acrobat.
Respondents feel the following characteristics of training are important (from most important to least): Instructor present, cost, time involved, customized content.
Based on these data and our past experiences, we've decided to take a new approach to training in the coming year, that we call the "roll-your-own" method.
Here's how it works:
An office or other group decides they would like training in a particular subject (see list below). They contact the appropriate ITDE team member (see list below) and schedule a time, place, and topics for training. There needs to be a minimum of five people committed to participate in the training, and it may be opened up to wider participation if space and resources are available.
We have used this technique several times in the past year, and find that by tailoring the training to a particular group's needs and scheduling at a time and location convenient to the group (like the county office), the training is much more effective and efficient.
To further tailor training to the particular group's needs, it's our intention that the instructor-led training be more task-oriented, to equip Extension staff with the skills they need to perform their jobs.
The following is a partial listing of subjects and contacts:
Faye Cragin: Advanced PowerPoint, PhotoShop, and PageMaker / InDesign
David Foote: PictureTel
Stephen Judd: Access, Excel, and any topic not specified here
Michael Toepfer: WordPerfect and "How to Get the Most from the Windows Operating System"
Barbara Wright: Word