Showing posts with label MS Office. Show all posts
Showing posts with label MS Office. Show all posts

Thursday, December 8, 2011

10 Ways to Make PowerPoint Presentations Powerful

Learn how to make your presentations sizzle, not fizzle.

Celebrating its 20-year year anniversary in 2007, Microsoft’s PowerPoint has brought two decades of engorged meetings, audio-visual hassles and bored boardrooms. It didn’t have to be this way… and it doesn’t have to in your next meeting.
A few tweaks here and there can make the difference between a presentation that sings and one that sets them snoozing.
1. Create an outline. Making a list of topics you need to address and rank them into primary and secondary importance. If time is short, you’ll know what to cut out. It also clarifies your ideas. “An outline helps you focus first on your content and how it’s organized,” says PowerPoint expert Ellen Finkelstein, author of “How to Do Everything With PowerPoint 2003.” “After all, isn’t what you’re saying more important than how you say it?”
2. No star wipes. Microsoft has given users dozens of ways to transfer from one slide to the next, with each new iteration offering more bells and whistles. Avoid the temptation. “Just because PowerPoint has some really cool transitions doesn’t mean they should be used,” recommends Kevin Lerner, of the Presentation Team, a consulting firm that advises clients on making presentations. “Most of the time, a simple wipe or dissolve will suffice. Also, it’s good to make the transitions consistent throughout your entire presentation.”
3. Choose your colors wisely. Using color can help convey meanings, make phrases stand out, and influence attitudes. All of that information you learned in elementary school about primary colors and complimentary colors can be useful in PowerPoint. Microsoft has some predefined color schemes in PowerPoint and they may be a good place to start. Microsoft also suggests that certain combinations of text color on background colors work best: green on purple, violet on yellow, white on black or blue-green on red. In graphics, try to choose one or more colors from the graphic to use in text, as well. It helps tie the presentation together. Finkelstein suggests using mid-range backgrounds and avoiding white or yellow text, which can be harsh on the eyes.
4. Use bullet points. It might seem to go without saying, but aside from direct quotes, the audience shouldn’t be reading whole paragraphs on a PowerPoint slide. That would be a real yawner.
5. More charts and diagrams, please. Pictures speak 1,000 words, the old saying goes. That’s why you want to sprinkle a variety of graphics into your presentation. An organizational chart can illustrate anything from a company’s chain of command to the families, genera and species of an order of biological organisms, according to Microsoft. For charts, PowerPoint also comes with ready-made cycles, radials, pyramids, Venns or target diagrams that you can customize to fit your pitch.
6. Be careful with sound and video. Audio and visual effects, particularly video, can slow down and even crash the computer during the presentation. Generally, the simpler the presentation, the less chance of crashing. If possible, test run the presentation on the actual computer you’ll be using.
7. Practice your presentation. Presentations often don’t work because speakers don’t take them as seriously as traditional presentations. Practice it as you would a regular speech. “By stopping even twenty minutes before your [actual] deadline, or showtime, you can significantly enhance your message by taking time to practice and rehearse,” Lerner says.
8. Coming to a conference room near you. PowerPoint now allows you to drop in movies, a short animated cartoon or show using Macromedia Flash. A tutorial on animation for PowerPoint on Microsoft’s website.
9. Double check your grammar and spelling. Nothing is more of a turnoff to that English major in the room.
10. If you don’t actually need visuals, leave your PowerPoint at home. Only use PowerPoint when it’s necessary.

Thursday, September 22, 2011

Microsoft Word Shortcut Keys

The followings are shortcut keys and mouse shortcuts that can be used for Microsoft Word
Use at your own risk.
Mouse shortcuts

Shortcut Description
Double-click (on a word) Select the word.
Single-click (anywhere in a sentence) + Holding CTRL Select the entire sentence.
Triple-click (anywhere in a paragraph) Select the entire paragraph.
Click, hold, drag, then release Select text from the click position to release position.
Click first position, hold SHIFT key, then click 2nd position Select text from the 1st position to the 2nd position.
Hold ALT key, then click and drag Vertical select text.
Hold CTRL key, then scroll wheel Zoom in/out.


Keyboard shortcuts

Shortcut Description
Ctrl + A Select all (including text, graphics).
Ctrl + B Bold.
Ctrl + I Italic.
Ctrl + U Underline.
Ctrl + C Copy.
Ctrl + V Paste.
Ctrl + X Cut.
Ctrl + F Find.
Ctrl + Z Undo.
Ctrl + Y Redo.
Ctrl + P Open the print dialog.
Ctrl + K Insert link.
Ctrl + L Left align.
Ctrl + E Center align.
Ctrl + R Right align.
Ctrl + M Indent.
Ctrl + (left arrow) Moves one word to the left.
Ctrl + (right arrow) Moves one word to the right.
Ctrl + (up arrow) Moves cursor to the beginning of the paragraph.
Ctrl + (down arrow) Moves cursor to the end of the paragraph.
Ctrl + Shift + F Change font.
Ctrl + Shift + * View/hide non-printing characters.
Ctrl + Del Deletes word to the right of cursor.
Ctrl + Backspace Deletes word to the left of cursor.
Ctrl + End Moves cursor to the end of document.
Ctrl + Home Moves cursor to the beginning of document.
Ctrl + Spacebar Reset highlighted text to the default font.
Ctrl + 1 Single-space.
Ctrl + 2 Double-space.
Ctrl + 5 1.5-line.
Ctrl + Alt + 1 Format text: heading 1.
Ctrl + Alt + 2 Format text: heading 2.
Ctrl + Alt + 3 Format text: heading 3.
F1 Help.
F4 Repeat the last action
F5 Go to .
F7 Spelling and grammar.
F12 Save as.
F8 then (left arrow) Increase selection to the left by one character
F8 then (right arrow) Increase selection to the right by one character
Ctrl + F1 Task Pane.
Ctrl + F2 Print preview.
Alt + Ctrl + F2 New document.
Shift + F3 Cycle between capitalized formats
Ctrl + Insert Copy.
Shift + Insert Paste.
Shift + End Select from current position to the end of the line.
Shift + Home Select from current position to the beginning of the line.
Ctrl + Shift + (left arrow) Select from current position to the beginning of the word.
Ctrl + Shift + (right arrow) Select from current position to the end of the word.
Ctrl + Shift + (up arrow) Select from current position to the beginning of the document.
Ctrl + Shift + (down arrow) Select from current position to the end of the document.
Ctrl + Shift + Page Up Select from current position to the beginning of the window.
Ctrl + Shift + Page Down Select from current position to the end of the window.
Shift + Page Up One screen page up.
Shift + Page Down One screen page down.
Shift + F7 Thesaurus check selected text.
Shift + F12 Save.
Ctrl + Shift + F12 Print.
Alt + Shift + D Insert the current date.
Alt + Shift + T Insert the current time.

Microsoft Outlook Shortcut Keys

The followings are shortcuts for Microsoft Outlook. Some keys are version specific.
Use at your own risk.
Shortcut Description
Ctrl + B Bold
Ctrl + C Copy.
Ctrl + F Forward a message.
Ctrl + I Italic highlighted selection
Ctrl + K Auto-Complete the name or message.
Ctrl + P Paste selected text.
Ctrl + R Reply to a message.
Alt + S Compose a new message
Ctrl + U Underline
Ctrl + X Cut selected text.
Ctrl + N Compose a new message.
Ctrl + Shift + A New appointment to your calendar.
Ctrl + Shirt + C New contact.
Ctrl + Shift + I Go to Inbox.
Ctrl + Shift + J New journal entry.
Ctrl + Shift + K New task.
Ctrl + Shift + O Go to Outbox.

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse shortcuts

Shortcut Description
Double-click (on a cell) Edit the cell contents.
Double-click (on a row/column divider) Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column divider Adjust height/width to auto-fit of all high-lighted rows/columns
Triple-click Select the entire contents in the cell
Click on row/column divider then drag Adjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then drag Adjust height/width of the rows/colunns
Ctrl + Mouse wheel Zooms in and out of document.
Hold Shift + Click the cells Select multiple cells


Keyboard shortcuts

Shortcut Description
F2 Edit the selected cell.
F5 Goto a specific cell. For example, C6.
F7 Spell check selected text and/or document.
F11 Create chart.
Ctrl + A Select all.
Ctrl + B Bold.
Ctrl + C Copy.
Ctrl + F Find (same as Shift + F5).
Ctrl + G Go To.
Ctrl + H Replace.
Ctrl + I Italic.
Ctrl + K Insert link.
Ctrl + N New Workbook.
Ctrl + O Open Workbook.
Ctrl + P Print dialog.
Ctrl + S Save.
Ctrl + U Underline.
Ctrl + V Paste.
Ctrl + Z Undo.
Ctrl + Y Redo.
Ctrl + X Cut.
Ctrl + 5 Strikethrough text.
Ctrl + F3 Define Name.
Ctrl + F4 Exit Excel.
Ctrl + F6 Switch between open workbooks.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize current window.
Shift + F1 Activate Help on Item.
Shift + F2 Insert Comments
Shift + F3 Insert Function.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Ctrl + Page down Move to next worksheet.
Ctrl + Page up Move to previous worksheet.
Ctrl + Shift + # Number Format: Date
Ctrl + Shift + @ Number Format: Time.
Ctrl + Shift + ! Number Format: Commas.
Ctrl + Shift + $ Number Format: Currency
Ctrl + Shift + % Number Format: Percentage
Ctrl + Shift + ^ Number Format: Scientific.
Ctrl + Space Select entire column.
Shift + Space Select entire row.
Ctrl + (Arrow key) Move to next section.

Convert Any Document or Web Page to PDF

Somebody just told you that you need to have Adobe Acrobat (Writer) to create a PDF file? Guess what, you can get away from that pricey piece of software if you just need to convert some documents to pdf, without a need of fancy editing the pdf document.
Here's how. Thanks to the BullZip, who provides a Free Pdf printer. With this free tool, you can simply "print out" your document or webpage to a pdf file, just about the same way as you print it out to a printer.

You can visit BullZip.com for more information about the software.
Here the direct link to BullZip downloads page: Downloads
  1. To get started, first follow the link above and download Free Pdf Printer from BullZip, then install it to your computer.
  2. Once you're done, you might need to close the program (or the web browser) which you're currently viewing the document. This helps refreshing the list of available printers on your computer.
  3. Once you get back to the document you want to convert, perform the same steps are you print out the document, i.e. File > Print ...
  4. When you see the Print window pop-up, select "Bullzip PDF Printer" under "Printers", then click "OK".
  5. BullZip PDF Printer will then start to analyze your document and display a new pop-up window, where you can direct it to the location you want to save the pdf file.
  6. Follow the pop-up windows and.. hola! The PDF document is created!

Add Watermark to an Excel Document

Unfortunately, the printed watermark feature is not available on any version of Excel (including Excel 2007, 2010). However, there are some workaround methods to add text or images into an Excel document that would result something similar to a watermark.

The followings are examples of Excel Documents with text and image "watermark":





Step-by-step to add a watermark to an Excel document (applied for Microsoft Word 97-2010):
A. TEXT WATERMARK:
The trick is to place a WordArt on the background of the Excel sheet.

Microsoft Excel 97/2000/XP (2002)/2003:
  1. Open the Excel document that you want to add watermark to.
  2. Select "Insert" from the top menu, then select "Picture" > "WordArt...".
  3. In the "WordArt Gallery" dialog, select a WordArt style that you like then click "OK".
  4. In the "Edit WordArt Text" dialog, type in your desired text, select the font style and size, then click "OK".
  5. Right-click on the newly inserted WordArt on the Excel document, then select "Format WordArt...".
  6. In the "Format WordArt..." dialog, select "No fill" for "Fill"/"Color".
    Also select a brighter color (i.e. gray) for "Line"/"Color" then click "OK".
  7. Right-click on the WordArt on the Excel document, then select "Order." > "Send to Back".
  8. Click and drag the WordArt to position it where you like.
    Note: The WordArt needs to be manually placed on each page of the document.
Microsoft Excel 2007/2010:
  1. Open the Excel document that you want to add watermark to.
  2. Select the "Insert" tab from the top menu, then in the group "Text", select "WordArt".
  3. Select the WordArt style you want, then type the text for your watermark.
  4. Under "Drawing Tools", select "Format".
  5. In the group "WordArt Styles" change "Text Fill" to "No fill".
  6. Also in the same group "WordArt Styles", change "Text Outline" to "Automatic".
  7. In the group "Arrange" select "Send to Back".
  8. Click and drag the WordArt to your preferred position.
    Note: The WordArt needs to be manually placed on each page of the document.


B. IMAGE WATERMARK:
To insert an image watermark, use the header feature in Excel as follows...

Microsoft Excel 97/2000/XP (2002)/2003:
  1. Open the Excel document that you want to add watermark to.
  2. Select "View" from the top menu, then select "Header and Footer".
  3. In the "Page Setup" dialog, click on the "Custom Header..." button in the middle of the dialog.
  4. In the "Header" dialog, click on the middle box "Center section"
  5. In the middle of this dialog box, there are some tool buttons. We're going to use the last two buttons to insert and format the image.
  6. Click on the Insert Picture button (the second-to-last button with an image of a mountain)
  7. Navigate to the folder where your watermark image is located. Select the image and click "Insert".
  8. A text "&[Picture]" is now placed in the middle box named "Center section".
  9. Click on the Format Picture button (the last, right-most button).
  10. Adjust the scale and size if you wish, then select the "Picture" tab. Change the "Color" under "Image Control" to "Washout", then click "OK".
  11. At this point, you can click "OK" to finish, and do a "Print Preview" to see your watermark. However, you will notice that the image is placed far on the top of the page, which doesn't look usual for watermarks. To fix this, click on the middle box named "Center section" again and enter a few blank lines before the text "&[Picture]".
  12. Once you're all done, click "OK" to exit and open "Print Preview" to see your watermark. (The watermark will not be displayed in normal view.)
Microsoft Excel 2007/2010:
  1. Open the Excel document that you want to add watermark to.
  2. Select the "Insert" tab from the top menu, then in the group "Text", select "Header & Footer".
  3. Excel will now switch to Page Layout view, and the cursor will be moved to the center top of the page.
  4. On the "Design" Tab, in the group "Header & Footer elements" Select "Picture".
  5. Navigate to the folder where your watermark image is located. Select the image and click "Insert".
  6. A text "&[Picture]" is now placed in the middle box of the header.
  7. To move the picture down on the page, click on the header and place the cursor before the text "&[Picture]", then hit Enter a few times.
  8. To see the watermark, either open the "Print Preview" or click on any cell of the document.

Add Watermark to a Word Document

You can insert a watermark into a Microsoft Word document as either text or image.
Here is a sample Word Document with text watermark:


And here is an example of picture watermark:



Step-by-step to add a watermark to Word document (applied for Microsoft Word 97-2010):
Microsoft Word 97/2000/XP (2002)/2003:
  1. Open the Word document that you want to add watermark to.
  2. Select "Format" from the top menu, then select "Background", then "Printed Watermark".
  3. In the "Printed Watermark" dialog:

    A. To insert a text watermark:
    • Select the "Text watermark".
    • Then, either select a pre-defined text from the drop-down, or type in your desire text on the "Text" field.
    • Customize your watermark with other options in this dialog such as text size, text color, etc, then click "OK".
    • Watermark is now inserted into your document.

    B. To insert an image watermark:
    • Select the "Picture watermark".
    • Then click on the button "Select Picture...".
    • Navigate to the directory where your watermark picture is located. Select it and click "Insert".
    • Select a customized scale if desired, then click "OK".
    • The image is now inserted into your document as watermark.


Microsoft Word 2007/2010:
  1. Open the Word document that you want to add watermark to.
  2. Select the "Page Layout" Tab from the top menu
  3. In the "Page Background" group, select "Watermark".
  4. You can now select one of the pre-defined watermarks, or if you wish to use your own text/image, select "Custom Watermark" at the bottom.
    At the "Printed Watermark" dialog:

    A. To insert a text watermark:
    • Select the "Text watermark".
    • Then, either select a pre-defined text from the drop-down, or type in your desire text on the "Text" field.
    • Customize your watermark with other options in this dialog such as text size, text color, etc, then click "OK".
    • Watermark is now inserted into your document.

    B. To insert an image watermark:
    • Select the "Picture watermark".
    • Then click on the button "Select Picture...".
    • Navigate to the directory where your watermark picture is located. Select it and click "Insert".
    • Select a customized scale if desired, then click "OK".
    • The image is now inserted into your document as watermark.