Microsoft+Office+Tools

Resources:
[|Office 2004 for Mac Templates] [|Mactopia] - Office 2008 for Mac Help Resources and Forum [|Office 2003 for Windows Training Resources] (Similar to the Mac 2004 version)

Formatting Palette:
In all of the Office applications you can find the most commonly used shortcut buttons in the formatting palette. To open: VIEW - Formatting Palette

=WORD=

Setting Tabs:
You can find the TABS menu under Format. An informative [|article explaining tab stops]. It uses MS Office 2007 for Windows as its example but is relevant to the Mac version as well.

Left align - everything lines up and goes to the right (lines up on left) Right align - everything lines up and goes to the left (lines up on the right) Decimal align - everything lines up on a specific character, usually the decimal point Center align - everything centers on a specific point. [|Tabs.doc]

Headers and Footers:
VIEW - Headers and Footers.

Watermark:
INSERT - Watermark

Tables:
Open new document. FILE - Page Set up, Make Landscape orientation TABLE - Insert. Create a table with 6 columns and 8 rows. Note - when shading for printing use GOLD instead of GRAY.
 * 1) Highlight Row 1. Table - Merge Cells
 * 2) Highlight Column 1. Table - Split Cells
 * 3) Highlight Row 2. Table - Table Properties - Row - specify height.
 * 4) Type a word in any cell in Row 2. Table - Table Properties - Cell. Check center or bottom.
 * 5) Highlight Row 4. Format - Borders and Shading - Click Shading, select a color.
 * 6) Highlight Row 6. Format - Borders and Shading - Click Borders, change width.
 * 7) Notice Apply To on Right side of dialog box.
 * 8) Table - Auto Format.

Notebook Layout:
View - Notebook Layout

Special Symbols:
[|Special Symbols:] System Preferences - International - Input Menu - click off Character Palette and Keyboard Viewer

Mail Merge:
[|What is Mail Merge?] Video Steps for creating a form letter [|Create Forms:Form Letters Using Mail Merge.doc] [|Create Labels Using Mail Merge.doc]

Tips:
(Retrieved and edited for Macintosh compatibility from this [|site])
 * Find and Replace
 * Click Edit…Find to type in text you desire to replace. You have the option to replace the text one time or replace it every time it appears in the document.
 * Selective Word Count
 * Need to know how many words, characters, paragraphs, or lines appear in a portion of a document? Just select the text you want to run the count on prior to choosing Word Count from the Tools menu.
 * Selecting Text
 * To select a word, double-click the mouse button on the word
 * To select a sentence, hold down COMMAND (Apple Key) and single-click the sentence.
 * To select a line of text on the screen, single-click with the left mouse button in the left screen margin at the line you want to select.
 * To select a paragraph, triple-click the left mouse button in the paragraphs
 * To select the whole document, hold down COMMAND (Apple Key) and A, or triple-click the left mouse button in the left margin of the screen.
 * Selecting Synonyms/Quick Spell Fix
 * A fast way is to locate a synonym for a word is to select the word and CTRL click it. In the menu, select synonyms and click your desired replacement.
 * Similarly to quickly fix a spelling error, CTRL click the word and choose the correct spelling from the list.

Shortcut Keys:
COMMAND (APPLE KEY) + A Selects all in the current document. COMMAND (APPLE KEY) + B Bold text. COMMAND (APPLE KEY) + C Copies the item or text to the Clipboard COMMAND (APPLE KEY) + D Displays the Font dialogue box. COMMAND (APPLE KEY) + E Centre Alignment. COMMAND (APPLE KEY) + F Displays the Find dialog box, to search the current document. COMMAND (APPLE KEY) + G Displays the Go to dialog box, to go to a specific location in the current document. COMMAND (APPLE KEY) + H Displays the Replace dialogue box. COMMAND (APPLE KEY) + I Italic text. COMMAND (APPLE KEY) + J Full Justification. COMMAND (APPLE KEY) + K Create Hyperlink COMMAND (APPLE KEY) + L Left Alignment COMMAND (APPLE KEY) + M Tab COMMAND (APPLE KEY) + N Creates a new document. COMMAND (APPLE KEY) + O Displays the Open File dialogue box. COMMAND (APPLE KEY) + P Displays the Print dialog box. COMMAND (APPLE KEY) + R Right Alignment. COMMAND (APPLE KEY) + S Displays the Save dialog box. COMMAND (APPLE KEY) + U Underline text COMMAND (APPLE KEY) + V Pastes the copied item or text from the Clipboard into the current position in the document. COMMAND (APPLE KEY) + X Cuts the item or text selected to the Clipboard. COMMAND (APPLE KEY) + Y Redo the last undone action. COMMAND (APPLE KEY) + Z Undoes the last action. COMMAND (APPLE KEY) + ENTER Insert Page Break. COMMAND (APPLE KEY) + F2 Show Print preview. COMMAND (APPLE KEY) + F4 Closes the active document window. COMMAND (APPLE KEY) + F6 Opens the next document window. COMMAND (APPLE KEY) + 1 Single spaces text COMMAND (APPLE KEY) + 2 Double spaces text COMMAND (APPLE KEY) + 3 Triple spaces text

=POWERPOINT=

Hyperlink to a Website:

 * 1) Go to the website you wish to link to and copy the URL.
 * 2) Create the text that will serve as the link. (For example, Click here to go to Library of Congress.)
 * 3) Highlight the text.
 * 4) Go to Insert - Hyperlink.
 * 5) Paste in the URL.
 * 6) Click on OK.

Hyperlink to another slide in your PowerPoint Using Text:

 * 1) Create the "target" slide. (The one that you want to link to)
 * 2) On the "main" slide, type the text that will serve as your link.
 * 3) Highlight that text.
 * 4) Go to Slide Show - Action Settings.
 * 5) Select Hyperlink to (a popup will appear)
 * 6) Click and hold on the popup and choose the slide to which you want to link. Most likely, you will choose Slide so you can actually select the target slide, regardless of its position in the presentation.
 * 7) Click on OK (and possibly a second OK).

Hyperlink to another slide in your PowerPoint Using a Button:
Note - by double clicking on the button, you can change the color. You reposition by dragging the button. You can also resize the button. Note - if you want the same button on many slides, after creating the first one, you can copy and paste to other slides. It should appear in the same location in the same size and color.
 * 1) Create the "target" slide.
 * 2) Select the slide on which the button will appear.
 * 3) Go to Slide Show - Action Buttons.
 * 4) Select the type of button you want to make.
 * 5) When you return to your slide show, you will see a crosshair on the screen. Click, hold and draw your button.
 * 6) Once you release, the Action Settings window will come up.
 * 7) Select Hyperlink to (a popup will appear)
 * 8) Click and hold on the popup and choose the slide to which you want to link.
 * 9) Click on OK (and possibly a second OK).

Saving PowerPoint Presentation as a Movie:
This would be used to create a Quicktime movie file out of your presentation. It could then be shown to students without PowerPoint
 * 1) FILE - Make Movie -OR- FILE - Save then choose PowerPoint Movie in the Format drop down box
 * 2) Click the Save button.
 * 3) Upload that to the [|Central York Fliggo] page or to your document manager page in School Center.

=EXCEL= Click here for a great page of Excel.