MICROSOFT WORD

When you choose to open a new document in Word, it usually begins browsing in a specific directory, such as My Documents. Similarly, when you choose to save, there is a default directory. You can change these defaults: go to Tools > Options. Click on the ‘File Locations’ tab. Click on ‘Documents’ under ‘File Types’, and then on ‘Modify’. Use the ‘Look in’ list to locate the folder you want to use from now on. Click on the folder name, then click ‘OK’ to select that location. Finally, click ‘OK’.

Multiple Clipboards In Word
You’ll often need to copy more than one block of text to the Clipboard, but you probably didn’t know you could do this and then paste everything into a document!

To get to the clipboard in the task pane in Word XP, first make the task pane appear using View > Task Pane. Then, on the little ‘down’ arrow, select ‘Clipboard’. Click ‘Options’, then check ‘Collect Without Showing Office Clipboard’.

Now copy up to 12 blocks of text (24 blocks in Word XP), then, when you’re ready to paste, use the ‘Clipboard’ toolbar in Word 2000, or the task pane on the right side of the screen in Word XP. Now, you can paste everything at once, or individual items in different locations. Hover the mouse over the icons on the Clipboard toolbar or on the task pane to get a preview of the content.

Add A Button To A Toolbar
You’ve probably never bothered to do this, but it’s very easy to add your own buttons to the toolbars. You can add a button for any of a variety of commands. For example, if you often change the font of selected text to Verdana, you can place a convenient button on the toolbar to make the change with one click. To make a new button, go to View > Toolbars. Select ‘Customize’. Click on the ‘Commands’ tab, and select an item under ‘Categories’. Then select an item from the list of ‘Commands’. Drag the command to a toolbar. A beam that looks like an ‘I’ will appear to help you install the button. By default, the new button has only a text label. Right-click on the new toolbar item, and select Default Style-the button will become a plain square. Right click on the new toolbar item again. Choose ‘Change Button Image’, then select a button image. Finally, close the ‘Customize’ dialog box.

To remove a button from a toolbar, go to View > Toolbars, select ‘Customize’, and drag the button you want to remove off the toolbar.

Print Out All Of Word’s Shortcut Keys
Word has an inbuilt macro that generates a list of all the keyboard shortcuts available. To generate the document, go to Tools > Macro. Choose ‘Macros’. Select ‘Word commands’ from the list in the ‘Macros in’ box. Now from the list in the ‘Macro name’ box, choose ‘ListCommands’. Click Run. In the ‘List Commands’ dialog box, click ‘Current menu and keyboard settings’. Click OK. The macro will run, generating a document in table form that you can print.

Using Styles
A style is a set of formatting characteristics that you can quickly apply to text in your document. The Style list is the pull-down list on the ‘Formatting’ toolbar, where it usually says ‘Normal’ in a white box. You can apply styles by selecting text, then choosing a style from the list. There will be a few there by default. To create your own styles, select the text that contains the formatting you want to use for your style. On the Formatting toolbar, click inside the ‘Style’ box. Type over the existing style name to create the name for the new style, then press Enter. You can set additional formatting characteristics for paragraph styles, such as the style for the next paragraph. To do this, go to Format > Style. Click the style that has the settings you want to change. Click ‘Modify’, and then select the options you want.

Create Your Own AutoText
AutoText is a way to store and quickly insert text, graphics, fields, tables, bookmarks, and other items that you use frequently. Word comes with a library of AutoText entries. To see there, look at the items listed under AutoText in the ‘Insert’ menu, or turn on the AutoText toolbar, and then click on ‘All Entries’. You can create your own AutoText entries with either of the following methods.

 Choose AutoCorrect or AutoCorrect Options from the Tools menu, then click on the AutoText tab. Type in the text of your new AutoText entry in the ‘Enter AutoText entries here’ box, then click Add. Make sure the ‘Show AutoComplete tip’ checkbox is checked. Click OK. Word will show a tip on the screen after you type the first four or five letters that match the AutoText entry. Press [Enter] to accept the entry, or keep typing to ignore it. If ‘AutoComplete’ is turned off, you can insert AutoText entries with the AutoText toolbar (see the next method).

Turn on the AutoText toolbar by choosing Toolbars from the View menu, then selecting AutoText. Select the text you want for an AutoText entry, then click on the ‘New’ button on the AutoText toolbar. Make up a shortcut name for this entry. To use the shortcut, type the shortcut, then immediately press [F3].

When you choose to open a new document in Word, it usually begins browsing in a specific directory, such as My Documents. Similarly, when you choose to save, there is a default directory. You can change these defaults: go to Tools > Options. Click on the ‘File Locations’ tab. Click on ‘Documents’ under ‘File Types’, and then on ‘Modify’. Use the ‘Look in’ list to locate the folder you want to use from now on. Click on the folder name, then click ‘OK’ to select that location. Finally, click ‘OK’.

Multiple Clipboards In Word
You’ll often need to copy more than one block of text to the Clipboard, but you probably didn’t know you could do this and then paste everything into a document!

To get to the clipboard in the task pane in Word XP, first make the task pane appear using View > Task Pane. Then, on the little ‘down’ arrow, select ‘Clipboard’. Click ‘Options’, then check ‘Collect Without Showing Office Clipboard’.

Now copy up to 12 blocks of text (24 blocks in Word XP), then, when you’re ready to paste, use the ‘Clipboard’ toolbar in Word 2000, or the task pane on the right side of the screen in Word XP. Now, you can paste everything at once, or individual items in different locations. Hover the mouse over the icons on the Clipboard toolbar or on the task pane to get a preview of the content.

Add A Button To A Toolbar
You’ve probably never bothered to do this, but it’s very easy to add your own buttons to the toolbars. You can add a button for any of a variety of commands. For example, if you often change the font of selected text to Verdana, you can place a convenient button on the toolbar to make the change with one click. To make a new button, go to View > Toolbars. Select ‘Customize’. Click on the ‘Commands’ tab, and select an item under ‘Categories’. Then select an item from the list of ‘Commands’. Drag the command to a toolbar. A beam that looks like an ‘I’ will appear to help you install the button. By default, the new button has only a text label. Right-click on the new toolbar item, and select Default Style-the button will become a plain square. Right click on the new toolbar item again. Choose ‘Change Button Image’, then select a button image. Finally, close the ‘Customize’ dialog box.

To remove a button from a toolbar, go to View > Toolbars, select ‘Customize’, and drag the button you want to remove off the toolbar.

Print Out All Of Word’s Shortcut Keys
Word has an inbuilt macro that generates a list of all the keyboard shortcuts available. To generate the document, go to Tools > Macro. Choose ‘Macros’. Select ‘Word commands’ from the list in the ‘Macros in’ box. Now from the list in the ‘Macro name’ box, choose ‘ListCommands’. Click Run. In the ‘List Commands’ dialog box, click ‘Current menu and keyboard settings’. Click OK. The macro will run, generating a document in table form that you can print.

Using Styles
A style is a set of formatting characteristics that you can quickly apply to text in your document. The Style list is the pull-down list on the ‘Formatting’ toolbar, where it usually says ‘Normal’ in a white box. You can apply styles by selecting text, then choosing a style from the list. There will be a few there by default. To create your own styles, select the text that contains the formatting you want to use for your style. On the Formatting toolbar, click inside the ‘Style’ box. Type over the existing style name to create the name for the new style, then press Enter. You can set additional formatting characteristics for paragraph styles, such as the style for the next paragraph. To do this, go to Format > Style. Click the style that has the settings you want to change. Click ‘Modify’, and then select the options you want.

Create Your Own AutoText
AutoText is a way to store and quickly insert text, graphics, fields, tables, bookmarks, and other items that you use frequently. Word comes with a library of AutoText entries. To see there, look at the items listed under AutoText in the ‘Insert’ menu, or turn on the AutoText toolbar, and then click on ‘All Entries’. You can create your own AutoText entries with either of the following methods.

 Choose AutoCorrect or AutoCorrect Options from the Tools menu, then click on the AutoText tab. Type in the text of your new AutoText entry in the ‘Enter AutoText entries here’ box, then click Add. Make sure the ‘Show AutoComplete tip’ checkbox is checked. Click OK. Word will show a tip on the screen after you type the first four or five letters that match the AutoText entry. Press [Enter] to accept the entry, or keep typing to ignore it. If ‘AutoComplete’ is turned off, you can insert AutoText entries with the AutoText toolbar (see the next method).

Turn on the AutoText toolbar by choosing Toolbars from the View menu, then selecting AutoText. Select the text you want for an AutoText entry, then click on the ‘New’ button on the AutoText toolbar. Make up a shortcut name for this entry. To use the shortcut, type the shortcut, then immediately press [F3].

MICROSOFT EXCEL

Locking A Range Of Cells
If you want to lock only a particular range of cells along with the formula instead of locking the entire sheet, use the following steps. First, unlock all the other cells. This is necessary because all the cells start with their ‘Locked’ property set to ‘True’. Select the entire sheet by clicking on the grey square to the left of the grey letter A at the top of column A. Go to Format > Cells. Click the ‘Protection’ tab. Uncheck the ‘Locked’ checkbox. Click ‘OK’. Then, you can protect a certain number of cells. For example, let’s protect A4:B10: select cells A4:B10. Go to Format > Cells. Click the Protection tab. Check the ‘Locked’ checkbox. Click OK. Now go to Tools > Protection > Protect Sheet. Enter a password if you want to. Now, only the cells in A4:B10 will be protected.

Disabling Specific AutoCorrect Features
In Excel 2000, it may seem impossible to put “ehr” in a cell because Excel changes it to “her”. You can fool it by concatenating individual letters, but an easier way is to disable the relevant AutoCorrect feature.

To stop Excel from doing this or any other similar change, follow these steps: go to Tools > AutoCorrect Options. On the first tab (‘AutoCorrect’), in the ‘Replace text as you type’ section, there is a long list with a scrollbar. Use the scrollbar to go down to through the alphabetical list to ‘e’. Find the entry for ‘ehr’. Click that entry to select it. Now click ‘Delete’.

Round Off Times
Here’s a formula that can round off a time to the nearest quarter hour: if someone clocks in at 7:07, it counts as 7 AM. If he clocks in at 7:08, then it should be 7:15 AM. To do this, use this formula:
=ROUND(A1*96,0)/96

If your times are in column A, you would enter a formula like this in column B. You will have to use Format> Cells and then format the cells in column B with a time format.

Easily Convert Numbers To Text
If you have a column of numbers and you need to convert them all to text, you would select the column, then go to Format > Cells, and on the ‘Number’ tab, change the formatting to ‘Text’. That doesn’t quite do it though-the formatted cells will still work as numbers, which you can verify by using them in formulas. To convert them to real text, you need to press [F2] and then hit [Enter], for each and every cell. Here’s a simpler way to convert a whole bunch of numbers to text. Let’s assume you have numbers in cells A2:A1000. Insert a temporary blank column B. In cell B2, enter this formula:
=TEXT(A2,”0″)

Copy the formula in B2 down to B3:B1000. We need to change these formula to values in order to have them become text. Highlight cells B2:B1000. Use [Ctrl] [C] to Copy, then Edit > Paste Special > Values > OK. The entries in column B will now be text versions of the numbers in column A. Now, copy column B back to Column A. Delete the temporary Column A.

The key to this technique is the =TEXT() function. The second parameter describes how the number should be formatted before being converted to text. You may need to adjust this based on your numbers. The result of =TEXT(123.25,”0″)will be 123.
The result of =TEXT(123.25,”0.0″)will be 123.3.
The result of =TEXT(123.25,”0.00″)will be 123.25.
To always keep only the decimals as entered, use=TEXT(A2,”General”).

This function is also useful for converting dates to formatted dates. Assuming you’ve set Windows to use the Indian system for dates, if you have ’10/05/2005′ in cell A2, then using =TEXT(A2,”d mmmm, yyyy”)
will give you ’10 May 2005′.

Bet You Didn’t Know 
Printing Out Headings
Say you have a row of headings at the top of your spreadsheet. To make this row appear at the top of each page when you print out the spreadsheet, go to File>Page Setup. In the ‘Page Setup’ dialog, there are four tabs across the top. Select the ‘Sheet’ tab. In the field for ‘Rows to repeat at top:’, enter 1:1. This will cause Row 1 to appear at the top of each printed page.


Add A Number To Every Cell
Say you have a spreadsheet full of values, and you need to add 0.2 to every cell. To do this, find a blank cell in your spreadsheet. Enter 0.2 in that cell. Select that cell and go to Edit > Copy. Now, select every cell that the operation needs to be applied to. From the menu, go to Edit > Paste Special. In the Paste Special dialog box, select ‘Values’ in the top section, and ‘Add’ in the ‘Operation’ section. Click ‘OK’. This will add the contents of the clipboard (0.2) to every number in the selected range.

Correcting The Placement Of The Minus Sign
When you import from a text document into Excel, the minus sign may appear to the right of the numbers. To correct this in Excel 2000, use this function:
=VALUE(IF(RIGHT(A1,1)=”-“,RIGHT(A1,1)&LEFT(A1,LEN(A1)-1),A1))

In Excel 2002 and 2003, here’s how to do it: in Step 3 of the Text Import Wizard, or in Step 3 of ‘Text to Columns (select from Data)’, click Advanced. Now, in the ‘Advanced Text Import Settings’ dialog box,
select the ‘Trailing minus for negative numbers’ checkbox.

MICROSOFT EXCEL

Locking A Range Of Cells
If you want to lock only a particular range of cells along with the formula instead of locking the entire sheet, use the following steps. First, unlock all the other cells. This is necessary because all the cells start with their ‘Locked’ property set to ‘True’. Select the entire sheet by clicking on the grey square to the left of the grey letter A at the top of column A. Go to Format > Cells. Click the ‘Protection’ tab. Uncheck the ‘Locked’ checkbox. Click ‘OK’. Then, you can protect a certain number of cells. For example, let’s protect A4:B10: select cells A4:B10. Go to Format > Cells. Click the Protection tab. Check the ‘Locked’ checkbox. Click OK. Now go to Tools > Protection > Protect Sheet. Enter a password if you want to. Now, only the cells in A4:B10 will be protected.

Disabling Specific AutoCorrect Features
In Excel 2000, it may seem impossible to put “ehr” in a cell because Excel changes it to “her”. You can fool it by concatenating individual letters, but an easier way is to disable the relevant AutoCorrect feature.

To stop Excel from doing this or any other similar change, follow these steps: go to Tools > AutoCorrect Options. On the first tab (‘AutoCorrect’), in the ‘Replace text as you type’ section, there is a long list with a scrollbar. Use the scrollbar to go down to through the alphabetical list to ‘e’. Find the entry for ‘ehr’. Click that entry to select it. Now click ‘Delete’.

Round Off Times
Here’s a formula that can round off a time to the nearest quarter hour: if someone clocks in at 7:07, it counts as 7 AM. If he clocks in at 7:08, then it should be 7:15 AM. To do this, use this formula:
=ROUND(A1*96,0)/96

If your times are in column A, you would enter a formula like this in column B. You will have to use Format> Cells and then format the cells in column B with a time format.

Easily Convert Numbers To Text
If you have a column of numbers and you need to convert them all to text, you would select the column, then go to Format > Cells, and on the ‘Number’ tab, change the formatting to ‘Text’. That doesn’t quite do it though-the formatted cells will still work as numbers, which you can verify by using them in formulas. To convert them to real text, you need to press [F2] and then hit [Enter], for each and every cell. Here’s a simpler way to convert a whole bunch of numbers to text. Let’s assume you have numbers in cells A2:A1000. Insert a temporary blank column B. In cell B2, enter this formula:
=TEXT(A2,”0″)

Copy the formula in B2 down to B3:B1000. We need to change these formula to values in order to have them become text. Highlight cells B2:B1000. Use [Ctrl] [C] to Copy, then Edit > Paste Special > Values > OK. The entries in column B will now be text versions of the numbers in column A. Now, copy column B back to Column A. Delete the temporary Column A.

The key to this technique is the =TEXT() function. The second parameter describes how the number should be formatted before being converted to text. You may need to adjust this based on your numbers. The result of =TEXT(123.25,”0″)will be 123.
The result of =TEXT(123.25,”0.0″)will be 123.3.
The result of =TEXT(123.25,”0.00″)will be 123.25.
To always keep only the decimals as entered, use=TEXT(A2,”General”).

This function is also useful for converting dates to formatted dates. Assuming you’ve set Windows to use the Indian system for dates, if you have ’10/05/2005′ in cell A2, then using =TEXT(A2,”d mmmm, yyyy”)
will give you ’10 May 2005′.

Bet You Didn’t Know 
Printing Out Headings
Say you have a row of headings at the top of your spreadsheet. To make this row appear at the top of each page when you print out the spreadsheet, go to File>Page Setup. In the ‘Page Setup’ dialog, there are four tabs across the top. Select the ‘Sheet’ tab. In the field for ‘Rows to repeat at top:’, enter 1:1. This will cause Row 1 to appear at the top of each printed page.


Add A Number To Every Cell
Say you have a spreadsheet full of values, and you need to add 0.2 to every cell. To do this, find a blank cell in your spreadsheet. Enter 0.2 in that cell. Select that cell and go to Edit > Copy. Now, select every cell that the operation needs to be applied to. From the menu, go to Edit > Paste Special. In the Paste Special dialog box, select ‘Values’ in the top section, and ‘Add’ in the ‘Operation’ section. Click ‘OK’. This will add the contents of the clipboard (0.2) to every number in the selected range.

Correcting The Placement Of The Minus Sign
When you import from a text document into Excel, the minus sign may appear to the right of the numbers. To correct this in Excel 2000, use this function:
=VALUE(IF(RIGHT(A1,1)=”-“,RIGHT(A1,1)&LEFT(A1,LEN(A1)-1),A1))

In Excel 2002 and 2003, here’s how to do it: in Step 3 of the Text Import Wizard, or in Step 3 of ‘Text to Columns (select from Data)’, click Advanced. Now, in the ‘Advanced Text Import Settings’ dialog box, select the ‘Trailing minus for negative numbers’ checkbox.

MS POWERPOINT

Print Without Opening PowerPoint
To print your presentation without even opening PowerPoint, go to Start Menu > Run. Type in “powerpnt.exe /p filetoprint.ppt” into the text field, replacing “filetoprint.ppt” with the name of the presentation you wish to print.

Using Your Toolbar On Other Machines
When you customise your toolbar configuration, its layout, icons, visible options, and positions are all recorded in a file called ppt.pcb. The ppt.pcb file is typically found at c:windows application datamicrosoft powerpointppt.pcb, and by copying this file, you can port your toolbar customisation to other machines.

Resizing All Images And Pictures In Proportion
When resizing any image, picture, or element in PowerPoint, you may want to resize all the images and graphical elements in your PowerPoint presentation at the same time. For example, if you have three images and two graphic elements that you have to resize, but must stay the same size in relation to each other, select the first image you wish to resize. Hold down [Shift]. Click on the other two images. Still holding the [Shift] key, also click on the two graphical elements. Drag your mouse in the direction you wish to increase or decrease the size of the image, and the other selected items will scale accordingly.

Apply A Template To An Existing Presentation
Open your presentation. While your presentation is open, choose ‘Apply Design Template’ from the ‘Format’ menu. Navigate to the location of the PowerPoint Templates, or where the PowerPoint Template (.POT) file that you wish to apply to your presentation is located, and select the template you want. A small thumbnail image of the design becomes visible in the navigation palette. Choose Apply.

Loop Music Across A Certain Number Of Slides
To play a background music loop or music file across a number of slides in PowerPoint 20002/XP 2003, and 2004, first choose ‘Movies and Sounds’ from the ‘Insert’ menu. Depending on what you want, select ‘Sound From Clip Organizer’, ‘Sound From File’, ‘Play CD Audio Track’, or ‘Record Sound’. Locate the sound file you wish to play across any number of your slides. Insert the sound. At this point, if you don’t want the sound icon to appear in the presentation, drag it off the slide. If you are asked “Do you want the sound to play automatically?”, select “Yes”. Right click the sound’s icon, and select ‘Custom Animation’ from the popup menu.

The ‘Custom Animation’ dialog box will open and your sound file should be listed. Click the arrow directly to the right of the sound icon to pull down various options. Select ‘Effect Options’, and on the ‘Effects’ tab, select the radio button beside Stop Playing > After, and select the number of slides that you would like the music to continue to play through.

If you want the sound to continue through the end of the presentation, enter a very large number, such as 999. Now select the ‘Timing’ tab. To play automatically, the timing should be set to ‘After Previous’ with a 0-second delay. Click OK to close the dialog box. Your music track will now continue after you leave the slide on which you placed it, and play until it reaches the slide number which you entered to ‘Stop Playing’.

Change The Colour Of Your Hyperlinks
To change the colour of your hyperlinks in PowerPoint 2002 and 2003 to match the colour scheme of your presentation, choose ‘Slide Design’ from the Format menu. Click ‘Color Schemes’ in the ‘Slide Design’ window. ‘Apply a color scheme:’ appears beside the thumbnail images at the top of the window. Click ‘Edit Color Schemes’ at the bottom of the window, and the ‘Edit Color Scheme’ dialog box appears. Click the Custom tab. Eight coloured squares will now be visible. The bottom two squares, ‘Accent and hyperlink’ and ‘Accent and followed hyperlink’ are the colours used in your presentation for your text hyperlinks, and visited text hyperlinks. Double-click the ‘Accent and hyperlink’ colour square; this sets the colour of your hyperlinked text. Choose a new ‘Standard’ or ‘Custom’ colour in the colour selection dialog box that appears, and click ‘OK’. Now double-click the ‘Accent and followed hyperlink’ colour square; this sets the colour of your visited hyperlinked text. Choose a new ‘Standard’ or ‘Custom’ colour in the colour selection dialog box that appears,and click OK.

Click ‘Apply’ if you wish to apply these colours to the current slide only, or click ‘Apply to All’ to apply the change to all text hyperlinks throughout your entire presentation.

Dual Displays
You can use PowerPoint to display your presentation on one screen, or projector, to an audience, while you read notes, and control your presentation, from another screen without your audience seeing what you are reading. In order to achieve this, your system hardware must support dual monitors.

Bet You Didn’t Know 
Hide Slides In PowerPoint
When producing a presentation for different audiences, often, you may not want to show all the slides to all the audiences. To hide a slide, select ‘Slide Sorter’ from the ‘View’ menu. Click on the slide that you want to hide. Select ‘Slide Show’ from the main menu toolbar. Click on ‘Hide Slide’, and that slide will now be hidden.


Open the presentation you wish to show on one of your monitors, screens, or projectors. Select ‘Set Up Show…’ from the Slide Show main menu option. The ‘Set Up Show’ dialog box appears. If you wish to use a projector, click the ‘Projector Wizard’ button. In the pull-down menu option under ‘Show on:’, choose which monitor, screen, or projector you wish to display your presentation on. Now go to View > Notes Master. Select ‘Set Up Show…’ again from the Slide Show main menu. This time, select which monitor, screen, or projector you wish to display your presentation notes on.

MS POWERPOINT

Print Without Opening PowerPoint
To print your presentation without even opening PowerPoint, go to Start Menu > Run. Type in “powerpnt.exe /p filetoprint.ppt” into the text field, replacing “filetoprint.ppt” with the name of the presentation you wish to print.

Using Your Toolbar On Other Machines
When you customise your toolbar configuration, its layout, icons, visible options, and positions are all recorded in a file called ppt.pcb. The ppt.pcb file is typically found at c:windows application datamicrosoft powerpointppt.pcb, and by copying this file, you can port your toolbar customisation to other machines.

Resizing All Images And Pictures In Proportion
When resizing any image, picture, or element in PowerPoint, you may want to resize all the images and graphical elements in your PowerPoint presentation at the same time. For example, if you have three images and two graphic elements that you have to resize, but must stay the same size in relation to each other, select the first image you wish to resize. Hold down [Shift]. Click on the other two images. Still holding the [Shift] key, also click on the two graphical elements. Drag your mouse in the direction you wish to increase or decrease the size of the image, and the other selected items will scale accordingly.

Apply A Template To An Existing Presentation
Open your presentation. While your presentation is open, choose ‘Apply Design Template’ from the ‘Format’ menu. Navigate to the location of the PowerPoint Templates, or where the PowerPoint Template (.POT) file that you wish to apply to your presentation is located, and select the template you want. A small thumbnail image of the design becomes visible in the navigation palette. Choose Apply.

Loop Music Across A Certain Number Of Slides
To play a background music loop or music file across a number of slides in PowerPoint 20002/XP 2003, and 2004, first choose ‘Movies and Sounds’ from the ‘Insert’ menu. Depending on what you want, select ‘Sound From Clip Organizer’, ‘Sound From File’, ‘Play CD Audio Track’, or ‘Record Sound’. Locate the sound file you wish to play across any number of your slides. Insert the sound. At this point, if you don’t want the sound icon to appear in the presentation, drag it off the slide. If you are asked “Do you want the sound to play automatically?”, select “Yes”. Right click the sound’s icon, and select ‘Custom Animation’ from the popup menu.

The ‘Custom Animation’ dialog box will open and your sound file should be listed. Click the arrow directly to the right of the sound icon to pull down various options. Select ‘Effect Options’, and on the ‘Effects’ tab, select the radio button beside Stop Playing > After, and select the number of slides that you would like the music to continue to play through.

If you want the sound to continue through the end of the presentation, enter a very large number, such as 999. Now select the ‘Timing’ tab. To play automatically, the timing should be set to ‘After Previous’ with a 0-second delay. Click OK to close the dialog box. Your music track will now continue after you leave the slide on which you placed it, and play until it reaches the slide number which you entered to ‘Stop Playing’.

Change The Colour Of Your Hyperlinks
To change the colour of your hyperlinks in PowerPoint 2002 and 2003 to match the colour scheme of your presentation, choose ‘Slide Design’ from the Format menu. Click ‘Color Schemes’ in the ‘Slide Design’ window. ‘Apply a color scheme:’ appears beside the thumbnail images at the top of the window. Click ‘Edit Color Schemes’ at the bottom of the window, and the ‘Edit Color Scheme’ dialog box appears. Click the Custom tab. Eight coloured squares will now be visible. The bottom two squares, ‘Accent and hyperlink’ and ‘Accent and followed hyperlink’ are the colours used in your presentation for your text hyperlinks, and visited text hyperlinks. Double-click the ‘Accent and hyperlink’ colour square; this sets the colour of your hyperlinked text. Choose a new ‘Standard’ or ‘Custom’ colour in the colour selection dialog box that appears, and click ‘OK’. Now double-click the ‘Accent and followed hyperlink’ colour square; this sets the colour of your visited hyperlinked text. Choose a new ‘Standard’ or ‘Custom’ colour in the colour selection dialog box that appears,and click OK.

Click ‘Apply’ if you wish to apply these colours to the current slide only, or click ‘Apply to All’ to apply the change to all text hyperlinks throughout your entire presentation.

Dual Displays
You can use PowerPoint to display your presentation on one screen, or projector, to an audience, while you read notes, and control your presentation, from another screen without your audience seeing what you are reading. In order to achieve this, your system hardware must support dual monitors.

Bet You Didn’t Know 
Hide Slides In PowerPoint
When producing a presentation for different audiences, often, you may not want to show all the slides to all the audiences. To hide a slide, select ‘Slide Sorter’ from the ‘View’ menu. Click on the slide that you want to hide. Select ‘Slide Show’ from the main menu toolbar. Click on ‘Hide Slide’, and that slide will now be hidden.


Open the presentation you wish to show on one of your monitors, screens, or projectors. Select ‘Set Up Show…’ from the Slide Show main menu option. The ‘Set Up Show’ dialog box appears. If you wish to use a projector, click the ‘Projector Wizard’ button. In the pull-down menu option under ‘Show on:’, choose which monitor, screen, or projector you wish to display your presentation on. Now go to View > Notes Master. Select ‘Set Up Show…’ again from the Slide Show main menu. This time, select which monitor, screen, or projector you wish to display your presentation notes on.

BUYING A LAPTOP

Size Matters
Size and weight are important considerations when buying a laptop. If you travel a lot, opt for a laptop that is light in weight. Weights of laptops range from one to four kg. While checking the weight, include everything you will carry along with the notebook, such as the power adaptor or any external drives.

See Your Screen
The size of the display screen directly affects the size, and in most cases, the weight, of the notebook. The larger the screen, the bulkier the notebook. A bulky notebook will be a problem to use in cramped locations such as in an airplane.

Power Struggle
Though performance is not the most important criterion while purchasing a notebook, make sure you get enough horsepower for the applications you use or plan to use. While 256 MB of RAM should suffice for most, power users should opt for at least 512 MB.

All Work And No Play?
If you want to play 3D games, or plan to use your laptop for some graphics-intensive applications, opt for a model that features good-quality graphics. Options available include Mobility Radeon 7500, 9700 and GeForce FX Go5200.

These will give you better graphics as compared to commonly-used platforms.

Go Wirefree
Most notebooks today offer Wi-Fi capabilities. Check the Wi-Fi standard supported by the model you are considering for purchase. An 802.11 b/g device will give you higher data throughput as compared to 802.11b.

Upgrade
Check if the notebook is upgradeable at a later stage. Some options to look for when upgrading your laptop are the RAM, the CPU, and the hard drive. Are the upgrades something you can do yourself, or do they require visits to a service centre?

Build Quality Is Important
Since laptops are meant to be carried around, good build quality is essential. Opt for a notebook that has a rugged build quality that can withstand jerks and shocks. The optical drive tray, the screen hinges and latch, the panel on top of the keyboard, and the overall casing are good indicators of build quality.

Warranty Issues
Warranty is also an important consideration. Make sure you get a global warranty if you travel abroad frequently. Even if you don’t, make sure the service centre is easily accessible in terms of location and distance so you can get any problems rectified quickly.

Optical Drives
Most notebooks these days come with a DVD/CD-RW combo drive by default. Make sure the notebook you plan to buy has a combo drive if not a DVD- Writer. A combo drive will enable you to read DVDs as well as write CDs.

Optical Drive Location
Check for the location of the optical drive. An optical drive placed in the front may be a hindrance while working in cramped spaces, or when the notebook is placed on your lap.

Wider Is Better
Notebooks that come with wide screens offer a  better movie-viewing experience. They are also useful while working with large spreadsheets. Also, look for decent quality integrated speakers if you want to enjoy movies and music on the move.

Hot Laps
Make sure the notebook you plan to buy does not get too hot after a while. A hot laptop on your lap may pose a serious health risk!

Storage
Most notebooks come with 40 GB hard drives. If this does not seem enough, see if you can get an upgrade to a larger capacity hard drive. The drive’s rotational speed also impacts performance. While 4200 rpm drives are the most common, look for higher rpm hard drives for better performance.

Go Legal
When purchasing a laptop, make sure it comes with legal software. Some vendors may not provide you with legal copies of the software. Verify that the software that comes with your laptop is on an original CD, and has a software license or registration number.

Laptop Drivers
Check and make sure you get all the required drivers on a disk along with the laptop. A recovery disk is also preferable, and will come in handy in case of a system crash.

Connectivity Options
The available ports on a notebook will define the types and number of peripheral devices you can connect. Most notebooks come with 56K modems and at least 10/100 Ethernet integrated, so the notebook will have RJ11 and RJ45 ports for connecting a telephone cord and a network cord respectively.

Typically, you should look for at least two USB ports, a parallel port to connect a printer, a VGA port for connecting a projector or an external monitor, and Audio Out and Mic In ports to connect speakers and a microphone respectively.

PC card slots are also essential, and you should check the types of PC cards that are supported. An infrared port, if available, will let you connect compatible devices such as cell phones to your notebook, while a FireWire port lets you connect digital such devices as video cameras. Look for these ports if you feel you will require them even at a later stage. Additional ports such as S-video out are also welcome!

One-handed Operation
Some notebook models, especially those with larger screens, come with two latches that will require you to use both your hands to open the device. This may be inconvenient in some situations, for instance, when you are speaking on the phone. Look for a laptop that has a single latch.

Touch The Pad
Most notebooks these days feature touchpads. Make sure the laptop you plan to buy has one that is large and offers smooth and jerk-free control of the pointer. Some notebooks also provide pointing sticks as the pointing device. Go for one with which you are most comfortable.

Memory Card Reader
If you own a digital camera or any other device that uses a memory card (such as SD, MMC, CF or Memory Stick), it makes sense to purchase a notebook that has an inbuilt memory card reader. This way, you can transfer data to and from the card without the need to buy a separate memory card reader. Check whether the card reader in the notebook is compatible with the type of memory card you use.

Ease Of Use
Some notebooks feature scroll keys along with the touchpad keys to enable vertical and/or horizontal scrolling in large documents. Some also feature hotkeys for launching your favourite applications.

Additional Features
Additional features, including integrated Bluetooth, biometric security, keyboard light and integrated Web cams, are offered in some models. Since these extra features also affect the pricing of the laptop, opt for one that has the features you need.

USING A LAPTOP

Shortcuts To Success
Create shortcuts to your most commonly used applications, folders and files on the desktop. This way, you can access them quickly. If you like your desktop clutter-free, you can also create custom toolbars in Windows XP.

To do this, right click on the Windows taskbar, go to ‘Toolbars’ and click on ‘New Toolbar’. Next, choose the drive or folder you want to access using the toolbar. You can create different toolbars for different drives and folders. To remove a toolbar you added, right click on the Windows taskbar, go to ‘Toolbars’, and uncheck the toolbar. This is useful for sales executives who want easy access to presentations, proposals and other information on a day-to-
day basis.

Boot Faster
To make your notebook boot faster, remove unwanted programs from startup. To do this, go to Start > Run, type “msconfig” and press [Enter]. Go to the Startup tab and uncheck any programs you do not need. Click on ‘OK’ and then click on ‘Exit’ without restarting. The unchecked programs will not run the next time you boot.

Clean Up The Junk
Uninstall any applications you do not use. Apart from saving on disk space, you will also prevent your notebook from slowing down.

Be Resourceful
Keep backups of the operating system, drivers and commonly used applications on a secondary partition so that you can do some re-installing on your own if you face some issues while travelling. Carry driver CDs and recovery disks with you.

Prevention Is Better Than Cure
Since a notebook may be connected to different networks, such as at a client’s office, for example, it is essential you use a good anti-virus and firewall software. Update your virus definitions frequently. An anti-spyware program is recommended.

BUYING A LAPTOP

Size Matters
Size and weight are important considerations when buying a laptop. If you travel a lot, opt for a laptop that is light in weight. Weights of laptops range from one to four kg. While checking the weight, include everything you will carry along with the notebook, such as the power adaptor or any external drives.

See Your Screen
The size of the display screen directly affects the size, and in most cases, the weight, of the notebook. The larger the screen, the bulkier the notebook. A bulky notebook will be a problem to use in cramped locations such as in an airplane.

Power Struggle
Though performance is not the most important criterion while purchasing a notebook, make sure you get enough horsepower for the applications you use or plan to use. While 256 MB of RAM should suffice for most, power users should opt for at least 512 MB.

All Work And No Play?
If you want to play 3D games, or plan to use your laptop for some graphics-intensive applications, opt for a model that features good-quality graphics. Options available include Mobility Radeon 7500, 9700 and GeForce FX Go5200.

These will give you better graphics as compared to commonly-used platforms.

Go Wirefree
Most notebooks today offer Wi-Fi capabilities. Check the Wi-Fi standard supported by the model you are considering for purchase. An 802.11 b/g device will give you higher data throughput as compared to 802.11b.

Upgrade
Check if the notebook is upgradeable at a later stage. Some options to look for when upgrading your laptop are the RAM, the CPU, and the hard drive. Are the upgrades something you can do yourself, or do they require visits to a service centre?

Build Quality Is Important
Since laptops are meant to be carried around, good build quality is essential. Opt for a notebook that has a rugged build quality that can withstand jerks and shocks. The optical drive tray, the screen hinges and latch, the panel on top of the keyboard, and the overall casing are good indicators of build quality.

Warranty Issues
Warranty is also an important consideration. Make sure you get a global warranty if you travel abroad frequently. Even if you don’t, make sure the service centre is easily accessible in terms of location and distance so you can get any problems rectified quickly.

Optical Drives
Most notebooks these days come with a DVD/CD-RW combo drive by default. Make sure the notebook you plan to buy has a combo drive if not a DVD- Writer. A combo drive will enable you to read DVDs as well as write CDs.

Optical Drive Location
Check for the location of the optical drive. An optical drive placed in the front may be a hindrance while working in cramped spaces, or when the notebook is placed on your lap.

Wider Is Better
Notebooks that come with wide screens offer a  better movie-viewing experience. They are also useful while working with large spreadsheets. Also, look for decent quality integrated speakers if you want to enjoy movies and music on the move.

Hot Laps
Make sure the notebook you plan to buy does not get too hot after a while. A hot laptop on your lap may pose a serious health risk!

Storage
Most notebooks come with 40 GB hard drives. If this does not seem enough, see if you can get an upgrade to a larger capacity hard drive. The drive’s rotational speed also impacts performance. While 4200 rpm drives are the most common, look for higher rpm hard drives for better performance.

Go Legal
When purchasing a laptop, make sure it comes with legal software. Some vendors may not provide you with legal copies of the software. Verify that the software that comes with your laptop is on an original CD, and has a software license or registration number.

Laptop Drivers
Check and make sure you get all the required drivers on a disk along with the laptop. A recovery disk is also preferable, and will come in handy in case of a system crash.

Connectivity Options
The available ports on a notebook will define the types and number of peripheral devices you can connect. Most notebooks come with 56K modems and at least 10/100 Ethernet integrated, so the notebook will have RJ11 and RJ45 ports for connecting a telephone cord and a network cord respectively.

Typically, you should look for at least two USB ports, a parallel port to connect a printer, a VGA port for connecting a projector or an external monitor, and Audio Out and Mic In ports to connect speakers and a microphone respectively.

PC card slots are also essential, and you should check the types of PC cards that are supported. An infrared port, if available, will let you connect compatible devices such as cell phones to your notebook, while a FireWire port lets you connect digital such devices as video cameras. Look for these ports if you feel you will require them even at a later stage. Additional ports such as S-video out are also welcome!

One-handed Operation
Some notebook models, especially those with larger screens, come with two latches that will require you to use both your hands to open the device. This may be inconvenient in some situations, for instance, when you are speaking on the phone. Look for a laptop that has a single latch.

Touch The Pad
Most notebooks these days feature touchpads. Make sure the laptop you plan to buy has one that is large and offers smooth and jerk-free control of the pointer. Some notebooks also provide pointing sticks as the pointing device. Go for one with which you are most comfortable.

Memory Card Reader
If you own a digital camera or any other device that uses a memory card (such as SD, MMC, CF or Memory Stick), it makes sense to purchase a notebook that has an inbuilt memory card reader. This way, you can transfer data to and from the card without the need to buy a separate memory card reader. Check whether the card reader in the notebook is compatible with the type of memory card you use.

Ease Of Use
Some notebooks feature scroll keys along with the touchpad keys to enable vertical and/or horizontal scrolling in large documents. Some also feature hotkeys for launching your favourite applications.

Additional Features
Additional features, including integrated Bluetooth, biometric security, keyboard light and integrated Web cams, are offered in some models. Since these extra features also affect the pricing of the laptop, opt for one that has the features you need.

USING A LAPTOP

Shortcuts To Success
Create shortcuts to your most commonly used applications, folders and files on the desktop. This way, you can access them quickly. If you like your desktop clutter-free, you can also create custom toolbars in Windows XP.

To do this, right click on the Windows taskbar, go to ‘Toolbars’ and click on ‘New Toolbar’. Next, choose the drive or folder you want to access using the toolbar. You can create different toolbars for different drives and folders. To remove a toolbar you added, right click on the Windows taskbar, go to ‘Toolbars’, and uncheck the toolbar. This is useful for sales executives who want easy access to presentations, proposals and other information on a day-to-
day basis.

Boot Faster
To make your notebook boot faster, remove unwanted programs from startup. To do this, go to Start > Run, type “msconfig” and press [Enter]. Go to the Startup tab and uncheck any programs you do not need. Click on ‘OK’ and then click on ‘Exit’ without restarting. The unchecked programs will not run the next time you boot.

Clean Up The Junk
Uninstall any applications you do not use. Apart from saving on disk space, you will also prevent your notebook from slowing down.

Be Resourceful
Keep backups of the operating system, drivers and commonly used applications on a secondary partition so that you can do some re-installing on your own if you face some issues while travelling. Carry driver CDs and recovery disks with you.

Prevention Is Better Than Cure
Since a notebook may be connected to different networks, such as at a client’s office, for example, it is essential you use a good anti-virus and firewall software. Update your virus definitions frequently. An anti-spyware program is recommended.

LAPTOP SECURITY

Don’t Be A Jerk
Be careful while carrying the notebook. Do not subject it to any jerks and shocks. This will avoid damage to your hard drive and the precious data on it. Preferably, power the notebook off before moving it from one place to another.

Dusty Notebooks Don’t Impress
Protect your laptop from dust. Clean your laptop regularly to prevent dust accumulation. Do not leave your notebook on the floor and make sure all vents are clean to enable good air flow.

Drinks And Laptops Don’t Mix
Avoid having beverages while working on your laptop. Do not place any containers filled with hot or cold beverages near your notebook, to minimise chances of a spill.

Protect Your Laptop
Do not leave your notebook unattended in a car or in a client’s office. Be careful when going to a restaurant or when using public transport.

Backup, Backup, Backup!
Keep backups of all your important files and e-mails in a safe location such as your desktop PC or an external drive. This way you still have your precious data even in case your notebook is stolen.

Power Surges
Use a surge protector with your laptop to protect it from power surges.

POWER-SAVING TIPS

Condition Your Battery
A new battery needs to be conditioned-it must be fully charged and discharged a few times before it can use its full capacity.

Leave Power Management To The Pros
Use the notebook’s power management features to improve battery life. You can set the device to switch off the LCD screen and hard drive after set intervals of time.

Screen Scream
The screen hogs a lot of battery power. To prolong battery life, dim the screen brightness when you are not connected to a power source.

Close Applications
Close any applications you are not using when on battery power. Running applications increase CPU utilisation, thus reducing battery lif

Team Digit

Team Digit

Team Digit is made up of some of the most experienced and geekiest technology editors in India! View Full Profile

Digit.in
Logo
Digit.in
Logo