Robb Murray, Workshop Leader
1	SITE FOR TIPS AND TRICKS
	www.komanndo.com
2	TIME ZONES
A   What time is it in Cairo?  (looking East)
1	Double-click Windows Clock in System Tray.
2	Click Time Zones.
3	Find the time zone for Cairo in the list.
4	Get time displacement from GMT from list.
	Central Time is -6; Cairo is +2.
	If the numbers are opposite in sign (+ and -), ignore their signs and add them together.
5	Result is 8; it is 8 hours later in Cairo.
B   What time is it in Honolulu? ( looking West)
1	Find the time zone for Hawaii in the list.
2	Central Time is -6; Hawaii is  -10.
	If numbers are the same sign, subtract the smaller from the larger.
3	Result is 4; it is 4 hours earlier in Honolulu.
	ALTERNATIVE:  Go to
	www.cnn.com/weather/worldtime   .
3	DISPLAY TWO TIME ZONES in your Outlook Calendar
How can I get my Outlook Calendar to show appointments in Central Time and Beijing time simultaneously?
1	In Outlook, Calendar, click:
	Tools-->Options-->Calendar-->Time Zones.
2	Click checkbox on "Show an additional time zone".
3	Label top section "ROTARY HQ".
4	Label bottom section "BEIJING".
5	In bottom section, select Beijing time zone in dropdown list.  It has the designation of  (+8 GMT).
6	Note that you can also swap the position of the two time zones.
7	"OK" your way back to your new calendar.
4	CURRENCY
A.   SYMBOLS:  What is the symbol for the currency used in Jamaica?  Greece?  The Ukraine?
1	In Excel, go to:
	Format-->Cells-->Number-->Currency.
2	Under "Symbols", find the symbol you need.
3	In Word, you can type special currency symbols, and others, using the list of special characters shown on pages 5-8.
4	CURRENCY (cont'd)
B.   CONVERSIONS:  What is the value in Korean currency of $250?
1	Go to finance.yahoo.com/m3?u   [no "www"]
2	Type in US dollar amount.
3	In dropdown to right, find Korean Won.
4	Click "CONVERT".
5	Now try converting  two NON-US currencies against each other.
6	Now see the HISTORY of this conversion value.
5	MAPS AND FLAGS
Where can I get map shapes and flags for decorating a flyer?
A   USE POWER POINT, WORD or EXCEL
1	Open a document in the desired program.
2	Click Insert-->Picture-->Clipart.
3	Click the FIND button in upper right and type "Italy" in place of the highlighted text.
4	Click Find and note results.
5	Double-click any image desired and it will insert into your document.
6	(Some installations of clip art will list Maps or Flags as a major category).
5	MAPS AND FLAGS (cont'd)
B   USE VISIO
1	Start Visio, using Maps-->Geographic Maps.
2	If already in Visio, click File-->Stencils-->Open Stencil---> Maps and select the maps group you want.
3	Drag the map shape onto the document from the stencil and size as desired.
4	Ungroup the map shape for the continent of Africa.  (Shape-->Grouping-->Ungroup).  Pull Sudan or any other country out to the side.  Put a shadow on it using the format toolbar and  point and arrow to it for dramatic effect.
5	Use the shape here or copy and paste into your Microsoft program.
6	One of the categories under Maps is Flags.  Try to show a flag superimposed on a map shape.
C   USE LYCOS
1	Go to www.lycos.com
2	Within the FIND category, click on Multimedia.
3	Select "Maps" and click the link for "Get international maps".
4	Select your country from the dropdown list, and click GET MAP.
5	To use an image, right-click it and click Copy.
6	Switch to the Microsoft program of your choice and click Paste.
6.   ROUGH TRANSLATIONS
A  WORDS and SENTENCES:  How can I say "Thank you for your kind letter" in French?
1	Go to "http://www.lycos.com".
2	Within the FIND category (second line), click on Translate.
3	Select "English to French" from the dropdown list.
4	Type or paste desired text in the text area.
5	Click "Translate".
B   WEB SITES:  How can I read a French web site? a German site?
1	Call up the site "http://www.louvre.fr".
2	Follow the links through "collections" and "peintures" [paintings]
3	See the site "http://www.willkommen.de".
4	Now go to the Lycos area above and paste the address into the text window.
5	Click the links and Lycos translates each page as it is called up.
7	CREATING MAPS
	How can I plot data on a map of the U.S.?
	A   TO SHOW DATA, USE THE MAP-DRAWING PROGRAM -- IN EXCEL
1	Open Excel and type in 2 parallel columns, as shown.
2	Leave no blank Excel columns between the two columns of data:
	STATE                    NEW MEMBERS
	California               236
	Iowa                        86
	Maine                      203
3	Now highlight this data by dragging over it, top left to bottom right.
4	Click Insert--->Map.  Drag the crosshairs of your mouse in a rectangular shape into your spreadsheet.
5	Choose "United States in North America".
6	Notice that your menus are those for Microsoft Map as long as you are selected into the map.  The map behaves like a chart in this regard.
7	Move your mouse over the buttons on the toolbar to see tool tips describing their functions.
8	There is an entire manual on MAP in the Help section.
7	CREATING MAPS  (cont'd)
	B   TO SHOW IDEAS, USE STENCILS AND SHAPE LABELS -- IN VISIO
1	Start Visio, using Maps-->Geographic Maps.
	(If already in Visio, click File-->Stencils-->Open Stencil --->Maps and select the maps group you want.
2	Select the "Maps of the U.S. and Canada" stencil.
3	In no particular spatial arrangement, drag out onto the workspace the shapes for the states California, Florida and Texas.
4	Press CTRL+A to select all the shapes.
5	Let Visio arrange the shapes into proper spatial relationship by clicking Tools-->Macro-->Maps-->Build Region.
6	Label each state shape by double-clicking. Mark the states "FIRST PLACE", "SECOND PLACE", and "THIRD PLACE", as you choose.
7	Let's group these states so they stay in the same spatial relationship"  Press CTRL+A to select them all, then click Shape-->Grouping-->Group.
7	CREATING MAPS  (cont'd)
	B   TO SHOW IDEAS, USE VISIO (cont'd)
8	Now let's put these states into a frame that is a US Map.  Select the "Maps of N. and S. America" stencil.  Drag out onto the workspace the outline shape of the USA.
9	Drag the map shape onto the document from the stencil and size as desired.
10	To be sure the individual states float over the outline, push the outline to the back by clicking Shape--> Send to Back.
11	Drag the grouped states over the frame to nest them within it.  Size the states group using the corner handles as necessary.  Also if necessary, turn off "snap to grid" by clicking Tools-->Snap and Glue and by clicking off "Snap" in the center top of the dialog box.
8	INTERNATIONAL SYMBOLS
Which  symbols are available in MS Office?
	At least 3 places provide built-in symbols . . .
A.  SYMBOL FONTS.
1	In  MS Word, click Insert --->  Symbols
2	You will see two folders: "Symbols" and "Special Characters".
8	INTERNATIONAL SYMBOLS (cont'd)
A.  SYMBOL FONTS. (cont'd)
3	In there "Symbols" folder you will see a dropdown list of fonts that offer symbols, depending on your individual machine's installed fonts.  Some--notably MingLiU (Chinese characters!), Tahoma and Normal Text--scroll to 100's of symbols.
4	If you will use a particular symbol often, note that you have the ability to create EITHER an AutoCorrect for the symbol or a shortcut key.
5	Symbols from this location are only available for use in MS Word and PowerPoint.
	Two more symbol sources are available in most of the programs of MS Office:
B.   CLIP ART
1	Click Insert-->Picture-->Clip Art  [in MS Word, for example].
2	You can find particular picture themes by using the FIND button.
3	In PowerPoint, you can use AUTO-CLIPART.
	a)   Let the software suggest the clip art for your presentation by clicking  Tools--AutoClipArt.
	b)   You will see a dropdown box listing pages where match suggestions were found.
	c)   When you double-click the suggested clip art, it does insert, but only onto the current page you are viewing.  You have to cut-and-paste the clip later to the proper page if the current page isn't where the picture goes.
8	INTERNATIONAL SYMBOLS (cont'd)
C.    THE DRAWING TOOLBAR (especially AutoShapes)
1	If the Drawing Toolbar is not displaying, right-click ANY toolbar and click it on.
2	On the Drawing Toolbar, click AutoShapes, then release the mouse button and trace up to Basic Shapes and over to a shape you want.  Click t