Setup gmail account in Microsoft Outlook

Part I - New Account Setup

• Goto the Tools menu and select E-mail Accounts


• Select Add a new e-mail account and click next


• Select POP3 and click next


• Fill in the blanks as seen below.

Incoming mail server (POP3): localhost (or 127.0.0.1 or your network computer name)
Outgoing mail server (SMTP): localhost (same as POP3)

• Click the More Settings button and head over to the Outgoing Server tab. Check My outgoing server requires authentication and Use same settings as incoming mail server
  
  NOTE: Do not use the Test Account Settings button because it does not support e-mail authentication and will result in a failure every time.

Part II - Filter Setup (required only one time per computer)

• Look for a Junk E-mail folder in your Outlook folder list (There should be one in Outlook 2002 or later). If you do not see this folder, go to File -> New -> Folder and create a folder inside the Inbox titled Junk E-mail (note the exact spelling).


• Now go to the Tools menu,Select Rules and Alerts or Rules or Rules Wizard (if this does not appear in the Tools menu, expand the menu by clicking on the down arrow at the bottom of the menu) Microsoft Outlook 2002 / XP Rules Wizard Window

• (Outlook 2000/2002 only) - Select Inbox (your Gmail account) under Apply changes to this folder. If there is only one item there, then make sure that is selected.
• In the Rules window, click Options
• In the Options window, select Import Rules.
• Navigate to your eMail2Pop installation directory (usually C:\Program Files\eMail2Pop)
  Select Outlook, click Open / OK (C:\Program Files\eMail2Pop\outlook.rwz)
  Verify that two rules have been imported into Outlook (X-eMail2Pop-status / X-Spam-Flag). They should be both checked.
• If the box beside the X-Spam-Flag rule is not checked, check the box, click the blue specified word in the big white box under Rule Description, and select the Junk E-mail folder. If there is not a Junk E-mail folder, create one inside the Inbox by clicking New .
• If you use your own additional Outlook rules, the eMail2Pop rules must process first. Use the Move Up (Up Arrow) button to move the two rules to the top of the list.
• Click Finish to close the Rules Wizard, and then OK to close the Rules and Alerts window
  Now you are all set to use Microsoft Outlook! No additional spam filtering configuration required.

Microsoft Powerpoint Tips

1. Setting the Default Text Style To change the style of the text that appears when you type things that aren't the title or the slide body, do the following:Choose the first layout option and click in the title box. From the Format menu, select Font. Make all the changes that you want there, and then check default for new objects. Next click OK. From that point on, new text will be created in that font style and size.
2. Changing A Design TemplateTo change the design template for the title or slide body objects, on the menu select View…Title or Slide Master. Click the body of the slide then right click the slide and choose Group…Ungroup. Delete any part of the design you desire. Then right click and choose Group…Regroup. When completed choose the slide sorter view mode from the lower left-corner of the screen.
3. Using More than One GuideIf you like using guides, but wish there were more, you can create additional Guides by simply holding down the CTRL key while dragging on an existing Guide. This will create a new guide. To get rid of guides, just drag them off the edge of the slide.
4. Creating Pages with Slides and Descriptive TextIf you want to create printable pages that have notes or descriptive text associated each slide, PowerPoint has a feature designed to do just this called Notes Pages, or Speaker's Notes (depending on which version you're using). To view the Notes page for any slide, go to the View menu and select Notes Pages. You will see an image of your slide there, and a placeholder for adding your script, notes, or any other text you wish. You can cut-and-paste text from Word here if you like. To print these pages, bring up the Print dialog, and at the bottom of the dialog where it says "Print What:", select Notes Pages. These pages were originally designed to be used as audience hand outs. To return to the normal view click the Slide View button in the lower right corner.
5. Building Presentations for Distribution to Others
   When making a PowerPoint presentation that will be distributed to other people, there are some important things to watch out for that will cause problems:
   * Stick with the fonts that come installed with Windows; Fancy fonts that appear on your machine will cause problems if everyone else doesn't have them.
   * Avoid embedding sounds and videos: these will not go from Mac to Windows gracefully, and you have to be very careful about how you insert the files in order to get them to "travel" properly. See the FAQ section for more information on this.
   * Design the presentation on the lowest version that you think might be in use. For example, if you want the presentation to be able to be viewed by Mac users (who may not have upgraded to the latest version), you will want to design your presentation in PowerPoint 4.0. If you don't have PowerPoint 4, then you'll want to save your presentation in the lowest format you think people will have. For cross-platform distribution, 4.0 is still your safest bet; for Windows-only distribution, save to PowerPoint 95. When you down-rev save, be prepared for some visual changes in your file--the previous version may not support some of the features you've put in, so be sure to sanity check your file on several different machines and versions BEFORE you distribute it!
6. Easily Changing from Caps to Lower Case (or Vice Versa)If you have text that is in the wrong case, select the text, and then click Shift+F3 until it changes to the case style that you like. Clicking Shift+F3 toggles the text case between ALL CAPS, lower case, and Initial Capital styles. This useful trick works with Word too!
7. Nudging ObjectsYou can use the arrow keys to move objects very small distances. This is a big win for those laptop users who no longer have mice. Select the object, then use your arrow keys. Each press of the key will move the object on "grid unit" (1/12th of an inch, don't ask why); if you hold down the Ctrl key while nudging, or if you have the grid turned off, you can move the objects one pixel at a time.
8. Saving Across Multiple DiskettesSince PowerPoint 7.0 (the one in Office 95, also known as PowerPoint '95) you have the option to save large files over multiple diskettes. From the File menu, select Pack and Go. This wizard will compress your PowerPoint presentation and copy the file onto as many floppies as are necessary.
9. Draw A Line Perfectly Horizontal or VerticalDepress the Shift key while dragging to create your line.
10. Draw A Perfect SquareDepress the Shift key while dragging to create your square.
11. Draw A Perfect Circle Depress the Shift key while dragging to create your circle.
12. Quickly Access the Slide Master Click on the Slide View icon (at the top-left of the screen), while depressing the Shift key.
13. Create A New Design Template Click on the File drop down menu, select New and then select the Design Template tab. Select an existing design template that most closely matches what you wish to achieve. Make changes to the slide master as required. Then save the file as a template using the SaveAs command to save the file as a dot file.
14. Preview A Presentation in Black and White Click on View…Black and White.
15. Send to the Back or Bring Forward an Object Right click on the object, select order, and choose the desired command.
16. Insert the Copyright Symbol To insert the copyright © symbol, enter (c) To insert the Trademark ™ symbol enter (tm) To insert the registered ® symbol enter (r)
    Saving Shows Save your presentation as a ‘PowerPoint Show’ (.pps) and your presentation will open straight into screenshow mode. To change a .pps back to a presentation for editing, locate the file name, right click the file name, choose rename, and change the .pps extension to .ppt. A warning about instability will appear, but no harm will be done to the presentation.
17. Jumping to Screens In show mode type a number then hit ‘enter’ to go to straight to that screen i.e. ’1’ to go back to the 1st screen. This is particularly useful if you have a large show for multiple speakers - just make a note of the slide number where each one starts - and during rehearsal, simply keying the number and pressing enter, jumps you straight to the right place. Quick and efficient.
18. Hiding Screens In the show mode you can hide your first (or any other) screen until you are ready to start by pressing ‘B’’ to blackout the screen or (‘W’ to ‘whiteout’ the screen) then press the ‘B’ or ‘W’ again to reveal the screen when you are ready.
19. To Go to the First Slide or Last Slide Ctrl+Home will take you to the first slide in a presentation, Ctrl+End will take you to the last slide.
20. Toolbar TipsYou can customize your toolbar to contain buttons for tasks that you routinely conduct. Click View…Toolbars…Customize. Click the Commands Tab and choose the desired task. Click and drag the accompanying icon to your preferred location in the toolbar. Close the customize window.
21. Setting up the ShowTo set up the presentation to run continuously, click Slide Show…Set Up Show. Check ‘loop continuously until ESC’ and click OK.To set up the presentation with timed settings on each slide, click Slide Show…Rehearse Timings. As each slide appears a rehearsal clock will appear in the upper left corner. When the desired time has expired click the mouse to progress to the next slide. After viewing the entire show you will be asked if you wish to save the rehearsed time. Click Yes.To record your own narration for the presentation click Slide Show…Record Narration.
22. Printing the PresentationYou have many options for printing your presentation. Click File…Print. You can choose to print it as slides or handouts and choose how many will fit on a page, print it as a Notes Page, or print it in the outline view. Other options include to print it in Grayscale, Pure Black and White, or with Animations. You can also choose to print only specific slide numbers or print all slides.
23. Scrolling CreditsScrolling text can be an effective means of ending or beginning a presentation. Click the desired text. When the Custom Animation text box opens, click the Effects tab. Click the arrow at the right side of the Entry Animation list box to expand the list. Locate Crawl From Bottom and select it. Check the list box labeled Introduce Text. If it isn't set to All at Once, click the arrow at the right side of the list box and select All at Once. Click the Timing tab and select the radio buttons labeled Animate and Automatically. Click OK to close the dialog box and save your changes. following are key board shotcuts :
24. Insert a new slide
    CTRL+M
25. Switch to the next pane (clockwise)
    F6
26. Switch to the previous pane (counterclockwise)
    SHIFT+F6
27. Make a duplicate of the current slide
    CTRL+D
28. Start a slide show
    F5
29. Promote a paragraph
    ALT+SHIFT+LEFT ARROW
30. Demote a paragraph
    ALT+SHIFT+RIGHT ARROW
31. Apply subscript formatting
    CTRL+EQUAL SIGN (=)
32. Apply superscript formatting
    CTRL+PLUS SIGN (+)
33. Open the Font dialog box
    CTRL+T
34. Repeat your last action
    F4 or CTRL+Y
35. Find
    CTRL+F
36. View guides
    CTRL+G
37. Delete a word
    CTRL+BACKSPACE
38. Capitalize
    SHIFT+F3
39. Bold
    CTRL+B
40. Italicize
    CTRL+I
41. Insert a hyperlink
    CTRL+K
42. Select all
    CTRL+A
43. Copy
    CTRL+C
44. Paste
    CTRL+V
45. Undo
    CTRL+Z
46. Save
    CTRL+S
47. Print
    CTRL+P
48. Open
    CTRL+O

Microsoft Visio Shortcuts

1. Getting around your diagram
   Zoom in (Ctrl + Shift + Left-click or Ctrl + Mouse wheel up)
   Zoom out (Ctrl + Shift + Right-click or Ctrl + Mouse wheel down)
   Zoom to selection (Ctrl + Shift + Left mouse drag)
   Zoom to whole page (Ctrl + W)
   Pan (Ctrl + Shift + Right mouse drag), Pan right (Shift + Mouse wheel up), Pan left (Shift + Mouse wheel down)
2. Select, add text, and connect your shapes, as easy as 1-2-3!
   Pointer tool (Ctrl + 1)
   Text tool (Ctrl + 2)
   Connector tool (Ctrl +3) (Note that if the Connector tool is selected and a shape is selected, dropping a new shape adds it connected to the first one)
3. Layout and layering of shapes
   Bring to front (Ctrl + Shift + F)
   Send to back (Ctrl + Shift + B)
   Group (Ctrl + Shift + G)
   Ungroup (Ctrl +Shift + U)
   Align Shapes (F8)
   Align shape to original X or Y axis when moving shape (Shift + Mouse drag)
   Nudge shape (Shift + ←,↑,→,↓)
4. Duplicating selected shape
   Copy (Ctrl + C), then paste (Ctrl + V), or
   Ctrl + mouse drag selected shape to duplicate (Tip: you can also hold Shift to align the duplicated shape to the original X or Y axis)
5. Switch page
   Previous Page (Ctrl +PageUp)
   Next Page (Ctrl + PageDown)
6. Full screen (F5)
7. Open Visual Basic Editor (Alt + F11)

Headers and Footers

1. Choose Header and Footer from the View menu.
2. The Header editing window and the Header and Footer toolbar will appear.
3. Type the text for the header or footer (the text in a header or footer is formatted like any other text).
   You can insert page numbers, the document's filename and path, and other codes into headers and footers (there are a number of options on the Header and Footer toolbar). The Switch Between Header and Footer button on the toolbar toggles the editing window between the header and the footer. The commands to control headers and footers are on the Page Setup dialog box (Page Setup on the File menu):
   Set the header and footer margins on the Margins tab.
   Set the other options on the Layout tab (different first page and odd and even). If you select either of the options on the Layout tab, then you can format the various headers individually and do things like remove the first page number, "mirror" the page numbers, etc. Headers and footers can be further controlled by formatting your document into multiple sections.
   

Remove Blanks Rows in Excel

1. First of all backup the Existing Excel file ( Due to Accidental Loss of Data )


2. Now, select the cells in one column from the top of your list to the bottom.


3. Now Click on Edit and Find the Go To Section ( or Press F5 )


4. Click the Special Button


5. Now Select the Blank Option in Options Box ( it will select all the Blank Rows )


6. Final Step is to Delete the Rows ( Now Go To Edit and Delete , Select Delete Entire Row )