Outline a list of data in a worksheet

Outline a list of data in a worksheet
You have a list of data that you want to group and summarize, you can create an outline of up to eight levels, one for each group. Each inner level, represented by a higher number in outline symbol displays detail data for the preceding outer level, represented by a lower number in the outline symbols. Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of columns, or an outline of both rows and columns.

An outline row of cells data grouped by geographical regions and months with several summary and detail rows displayed.

1. To display rows for a level, click the appropriate outline symbols.
2. Level 1 contains the total cells for all detail rows.
3. Level 2 contains the total cells for each month in each region.
4. Level 3 contains the total rows (only detail rows 11 through 13 are currently visible).
5. To expand or collapse data in your outline, click the + and - outline symbols.


Create an outline of rows
1. Make sure that each column has a label in the first row, contains similar facts in each column, and that the range has no blank rows or columns
2. Select a cell in the range.
3. Sort the columns that from the groups.
For more information on sorting, see sort data in a range or table.
4. Insert summary rows.
To outline data by rows, you must have summary rows that that contain formulas that reference cells in each of the detail rows for that group. Do one of the following:
Insert summary rows by using the Subtotal command
· Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you. For information, see insert subtotals in a list of data in a worksheet.

Insert your own summary rows

Insert your own summary rows
· Insert your own summary rows with formulas immediately below or above each group of detail rows.
5. Specify whether the location of the summary row is below or above the detail rows.
How to specify the summary row location.
1. On the Data tab, in the Outline group, click the outline Dialog Box Launcher.
2. To specify a summary row above the details row, clear the Summary rows below detail check box.
To specify a summary row below the details row, select the Summary rows below detail check box.
Outline the data. Do one of the following:
Outline the data automatically.
If necessary, select a cell in the range.
1. On the Data tab, in the Outline group, click the arrow next to Group, and then click Auto Outline.

Important If you ungroup an outline while the detail data is hidden, the detail rows may remain hidden. To display the data, drag across the visible row numbers adjacent to the hidden rows. On the Home tab, in the cells group, click Format, point to Hide & Unhide, and then click Unhide Rows.
Prevent invalid data entry in a worksheet
In many worksheets that you create, users will enter data to get the desired calculations and results. Ensuring valid data entry is an important task. You may want to restrict data entry to a certain range of dates, limit choices by using a list, or make sure that only positive whole numbers are entered. Providing immediate help to instruct users and clear messages when invalid data is entered is also essential to make the data entry experience go smoothly. Once you decide what validation you want to use on a worksheet, you can set up the validation by doing the following:
1. Select one or more cells to validate.
2. On the Data tab, in the Date Tools group, click Data Validation.










Tab Data Validation dialog box is displayed.
3. Click the Settings tab.
4. To specify the type of validation that you want to, do one of following:
1. In the Allow box, select List.
2. Click the Source box and then type the list values separated by the Microsoft Windows list separator character (commas by default).
For example,
· To limit entry to a question, such as "Do you have children?" to two choices, type Yes, No.
· To limit a vendor's quality regulation to three rating, type Low, Average, High.
You can also create a list of values from a range of cells, For more information, see Create a drop-down list from a range of cells.
NOTE: The width of the drop-down list is determined by the width of the cell that has the data validation. you may need to adjust the width of that cell to prevent truncating the width of valid entries that are wider than the width of the drop-down list.
3. Make sure that the In-call dropdown check box is selected.
Allow a whole number within limits.
4. In the Allow box, select Whole Number.
5. In the Data box, select the type of restriction that you want. For example, to set upper and lower limits, select between.
6. Enter the minimum, maximum, or specific value to allow. You can also enter a formula that returns a number value.
For example, to set a minimum limit of deductions to two times the number of children in cell F1, select greater than or equal to in the Data box and enter the formula, =2*F1, in the Minimum box.
7. In the Allow box, select Dec

1 Filtering list

Using AutoFilter to filter data is a quick and easy way to find and work with a subset of data in a range of cells or table column. Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed. After you filter data, you can copy,
find, edit, format, chart, and print the subset of filtered data without rearranging or moving it.

Filter Text
1. Select a range of cells containing alphanumeric data.
2. On the Home tab, in the Editing group, click Sort & Filter, and then click Filter.

Click the arrow in the column header.
Do one of the following:
Select from a list of text values
· In the list of text values, select or clear one or more text values to filter by.
The list of text values can be up to 10,000. If the list is large, clear (Select All) at the top.
Create criteria
1. Point to Text Filters and then click one of the comparison operator (=Equal to, > Greater than,<>=Greater than or equal to, <= Less than or equal to, and <> Not equal to.)commands, or click Custom Filter. For example, to filter by text that begins with a specific characters, select Begins With, or to filter by text that has specific characters anywhere in the text, select Contains.
2. In the Custom AutoFilter dialog box, in the box on the right, enter text or select the text value from the list. For example, to filter by text that begins with the letter "J", enter J, or to filter by text that has "bell" anywhere in the text, enter bell.

To find

If you need to find text that shares some characters but not others, use a wildcard character.

Use
To find
? (question mark)
Any single character
For example,sm?th finds "smith" and "Smyth"
* (asterisk)
Any number of characters
For example,*east finds "Northeast" and "Southeast"

Filter for top or bottom numbers
1. Select a range of cells containing numeric data.
2. On the Home tab, in the Editing group, click Sort & Filter, and then click Filter.

Click the arrow in the column header.
Point to Number Filters and then select Top 10.
In the Top 10 AutoFilter dialog box, do the following.
0. In the box on the left, click Top or Bottom.
1. In the box in the middle, enter a number.
2. In the box on the right, do one of the following:
§ To filter by number, click Items.
§ To Filter by percentage, click Percent.
Sub total
You can automatically calculate subtotals and grand total in a list for a column by using the Subtotal command in the Outline group on the Data tab.

Select from a list of text values

In the list of text values, select or clear one or more text values to filter by.
The list of text values can be up to 10,000. If the list is large, clear (Select All) at the top.
Create criteria
1. Point to Text Filters and then click one of the comparison operator (=Equal to, > Greater than,<>=Greater than or equal to, <= Less than or equal to, and <> Not equal to.)commands, or click Custom Filter. For example, to filter by text that begins with a specific characters, select Begins With, or to filter by text that has specific characters anywhere in the text, select Contains.
2. In the Custom AutoFilter dialog box, in the box on the right, enter text or select the text value from the list. For example, to filter by text that begins with the letter "J", enter J, or to filter by text that has "bell" anywhere in the text, enter bell.

Filtering list

Using AutoFilter to filter data is a quick and easy way to find and work with a subset of data in a range of cells or table column. Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed. After you filter data, you can copy,
find, edit, format, chart, and print the subset of filtered data without rearranging or moving it.

Filter Text
1. Select a range of cells containing alphanumeric data.
2. On the Home tab, in the Editing group, click Sort & Filter, and then click Filter.

Click the arrow in the column header.
Do one of the following:

Sort text

1. Select a column of alphanumeric data in a range of cells, or make sure that the active cell is in a table column containing alphanumeric data.
2. On the Home tab, in the Editing group, and then click Sort & Filter.
3. Do one of Following:
· To sort in ascending alphanumeric order, click Sort A to Z.
· To sort in descending alphanumeric order, click Sort Z to A.
Sort dates or times
1. Select a column of dates or times in a range of cells, or make sure that the active cell is in a table column containing dates or times.
2. Select a column of dates or times in a range of cells or table.
3. On the Home tab, in the Editing group, click Sort & Filter, and then do one of the following:
· To sort from an earlier to a later date or time, click Sort Oldest to Newest.
· To sort from a later to a earlier date or time, click Sort Newest to Oldest.

Sorting data

Sorting data is an integral part of data analysis. You might want to put a list of names in alphabetical order, compile a list of protect inventory levels from highest to lowest, or order row by colors or icons. Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions .
You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. You can also sort by a custom list (such as Large, Medium, and Smallest) or by format, including cells color, font color, or icon set. Most sort operations are column sorts, but you can also sort by rows.

Default sort orders: In an ascending sort, Microsoft Office Excel uses the following order. In a descending sort, this sort order is reversed.

Value
Comment
Numbers
Numbers are sorted from the smallest negative number to the largest positive number.
Dates
Dates are sorted from the earliest data to the latest data.
Text
Apostrophes (') and hyphens (-) are ignored, with one exception: If two text strings are the same except for a hyphen, the text with the hyphen is sorted last.
Logical
In logical values, FALSE is placed before TRUE.
Error
All error values, such as #NUM! and #REF!, are equal.
Blank cells
In both an ascending and descending sort, blank cells are always placed last.

Lock only specific cells and ranges in a protected worksheet

1. If the worksheet is protected, do the following:
· On the Review tab, in the Changes group, click Unprotect Sheet.
NOTE: Protected Sheet changes to Unprotect Sheet when a worksheet is protected.
· If prompted, type the password to unprotect the worksheet.
2. Select the entire worksheet by clicking the Select All button.
Select All button
3. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher.

Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1.
4. On the Protection tab, clear the Locked check box, and then click OK.
NOTE: This unlocks all of the cells on the worksheet when you protect the worksheet.
5. In the worksheet, select just the cells that you want to lock.
6. On the Home tab, in the Font group, click the Format Cells Font dialog box launcher.
(Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1.)
7. On the Protection tab, select the Locked check box, and then click OK.
8. On the Review tab, in the Changes
group, click Protect Sheet.
9. Type a password for the worksheet.
· Changing the size and position of the windows for the workbook when the workbook is opened

Protect workbook elements

1. On the Review tab, in the Changes group, click Project Workbook.
2. Under Project workbook for, do any of following:
· To protect the structure of a workbook, select the Structure check box.
· To keep workbook windows in the same size and position each time the workbook is opened, select the Windows check box.
Select this check box To prevent users from
Structure
Recording new macros.

1. Viewing worksheets that you have hidden.
2. Moving, deleting, hiding, or changing the names of worksheets.
3. Inserting new worksheets or chart sheets.
4. Moving or copying worksheet to another workbook.
5. In PivotTable reports, displaying the source data for a cell in the data area, or displaying page field pages on separate worksheets.
6. For scenarios, creating a scenario summary report.
7. In the Analysis Toolbar, using the analysis tools that place results on a new worksheet.
3. To prevent other users from removing workbook protection, in the Password (optional) box, type a password, click OK, and then retype the password to confirm it.

Allow cells to be edited in a protected worksheet
When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the worksheet. Windows
1. Moving, resizing, or closing the windows.
2. Changing the size and position of the windows for the workbook when the workbook is opened

· Changing the size and position of the windows for the workbook when the workbook is opened

Protect workbook elements

1. On the Review tab, in the Changes group, click Project Workbook.
2. Under Project workbook for, do any of following:
· To protect the structure of a workbook, select the Structure check box.
· To keep workbook windows in the same size and position each time the workbook is opened, select the Windows check box.
Select this check box To prevent users from
Structure
Recording new macros.

1. Viewing worksheets that you have hidden.
2. Moving, deleting, hiding, or changing the names of worksheets.
3. Inserting new worksheets or chart sheets.
4. Moving or copying worksheet to another workbook.
5. In PivotTable reports, displaying the source data for a cell in the data area, or displaying page field pages on separate worksheets.
6. For scenarios, creating a scenario summary report.
7. In the Analysis Toolbar, using the analysis tools that place results on a new worksheet.

view cell

5. On the Review tab, in the Changes group, click Protect Sheet.
6. In the Allow all users of this worksheet to list, select the elements that you want users to be able to change.

Clear this check box To prevent users from

Select locked cells : Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.

Select unlocked cells: Moving the pointer to cells for which the Locked check box is cleared on the Protection tab of the Format Cells dialog box. By default, users are allowed to select unlocked cells, and they can press the TAB key to move between the unlocked cells on a protected worksheet.

Format cells: Changing any options in the Format Cells or Conditional Formatting dialog boxes, If you applied conditional formats before you protected the worksheet, the formatting continues to change when a user enters a value that satisfies a different condition.

Format columns: Using any of the column formatting commands, including changing column width or hiding columns (Home tab, Cells group, Format button).

Format rows: Using any of the row formatting commands, including changing row height or hiding rows (Home tab, Cells group, Format button).

Insert columns: Inserting columns.
Insert rows: Inserting rows.
Insert hyperlinks: Inserting new hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an internet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), even in unlocked cells.

Delete columns: Deleting columns.
NOTE: If Delete columns is protected and Insert columns is not also protected, a user can insert columns that he or she cannot delete.


Delete rows:
Delete rows


NOTE: If Delete rows is protected and Insert rows is not also protected, a user can insert rows that he or she cannot delete.

Select this check box To Prevent users from

Format Cells

· On the Protection tab, clear the Locked check box, and then click OK.

3. To hide any formulas that you don't want to be visible, do the following:
· In the worksheet, select the cells that contain the formulas that you want to hide .
· On the Home tab, in the Cells group, click Format, and then click Format Cells.
· on the Protection tab, select the Hidden check box, and then click OK.
4. To unlock any graphic objects (such as picture, clip art, shapes, or Smart Art
graphics) that you want users to be able to change, do the following:
· Hold down CTRL and click each graphic object that you want to unlock. This display the Picture Tools or Drawing Tools, adding the Format tab.
· On the Format tab, in the Size group, click the Dialog Box Launcher next to Size.
· On the Properties tab, clear the Locked check box, and if presents, clear the Lock text check box .

A range of cells, table

1. Select the range of cells, table, or PivotTable for which you want to clear
conditional formats.
2. On the Home tab, in the Styles group, click the arrow next to Conditional
Formatting, and then click Clear Rules.
3. Depending on what you have selected, click Selected Cells, This Table.
Protect worksheet or workbook elements
To Prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can protect certain worksheet or workbook elements, with or without a password.
Protect worksheet elements
When you protect a worksheet, all cells on the worksheet are locked by default, and users cannot make any changes to a locked cell. For example, they cannot insert, modify, delete, or format data in a locked cell. You can, however, specify which elements users will be allowed to change when you protect the worksheet.
1. Select the worksheet that you want to protect.
2. To unlock any cells or ranges that you want other users to be able to change, do the following:
· Select each cells or range that you want to unlock.
· on the Home tab, in the cells group, click Format, and then click Format Cells
· On the Protection tab, clear the Locked check box, and then click OK.
3. To hide any formulas that you don't want to be visible, do the following:

a customized hyperlink to a document, foles, or web pag

1. Select the text or picture that you want as the hyperlink .
2. On the Insert tab, in the Links group, click Hyperlink you can also right- click the text or picture and then click Hyperlink Create on the shortcut menu.
3. Do one of the following :
§ To link to an existing file or web page, click Existing File or web page under Link to, and then type the address that you want to link to on the Address box.
If you don't know the address for a file, click the arrow in the Look in list, and then navigate to the file that you want.
§ To link to a file that you haven't ceated yet, click Create New Document under Link to, type the name, of the nem file in the Name of new document box, and then, under when to edit, click Edit the new document later or Edit the new document now.
NOTE To customize the the Screen Tip that appeas when you rest the pointer over the hyperlynk, click Screen Tip and then type the text that you want . If you don't specify a tip, word user the path or address of the as the tip.
Crete a hyperlink to a blank e-mail message
1. Select the text or picture that you want to display as the hyperlynk.
2. On the Insert tab, in the Links group, click Hyperlynk you can laso right- click the text or picture and then click Hyperlynk on the shortcut menu.
3. Under Link to, click E-mail Address.
4. Either pype the e-mail address that you want in the E-mail address box, or select an e-mail address in the Recently used e-mail addresses list.
5. In the Subject box, type the subject of the e-mail messaje.
NOTE
Some Web browsere (Web browser that interprets HTML files , formats them into web pages , and displays them. A web browser , such as Windows Internet Explorer , can follow hyperlinks , transfer files, and play sound ar video files that are embedded in web pages.) and e-mail programs might not recognize the subject line.To customize the Screen Tip that appears when you rest the pointer over the hyperlynk, click Screen Tip and then type the text that you want. If you don'n specify a tip, word uses "mailto " followed by the e-mail address and the subject line as the tip.
TIP you can also create a hyperlynk to a blank e-mail message by typing the address in the document. For example, type someone@example.com , and word create the hyperlynk for you, unless you turned off automatic formatting of hyperlynks.
Create a hyperlynk to a location in the current document or web page
To link to a location in a document or web page that you created in word, you must mark the hyperlynk location or destination and then add the link to it.
Mark the

bookmark

late time. Instad of scrolling through the document to locate the text, you can go to it by using the Bookmark dialog box.
You can also add cross- references to bookmarks . For exaple, after you insert a bookmark in a dacument, you refer to that bookmark from other places in the text by creating cross-references to the bookmark.
Add a bookmark
1. Select the text or item to which you want assign a bookmark, or click where you want to insert a bookmark.


2. On the Insert tab, in the Links group, click Bookmark.
3. Under Bookmark name, type or select a name.
Bookmark names must begin with a letter and can contain numbers . You can't include spaces in a bookmark name. However, you can use the underscore character to separate words- for exmple, "First _heading."
4. Click Add.
Go to specific bookmark


1. On the Insert tab, in the Links group, click Bookmark.
2. Click either Name ir Location to sort the list of bookmarks in the document.
3. Click the name of the bookmark that want to go to.
4. Click Go To.
Using hyperlink :
A hyperlink is a colored and underlined text or a graphic that you click to go to a file, a location on a file, a web page on the word wide web, or a web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher. Telnet, and FTP sites.

Adding Header and Footer to outline page

1. Click on /View /on the menu bar and then point to / Header and Footer /.Set the values (s) in dialog box that suits your presentation.

Adding a Word Art in your presentation
1. point to Word Art on drawing toolbar and click it.
2. Word art gallery dialog box appears.
3. Click ok .
Do necessary change likes in MS-Word if needed.
Note
Adding an auto shapes in your presentation [Like in MS-Word




Create a Slide master
To give all the slide in the presentation a uniform look, design template use the Slide Master. A slide master is an element of the design template that stores information about the template, including tent styles, placeholder sizes and positions, background design, and color schemes. With Slide Master you can make a marked change such as replacing the font style and have that change reflected on all the slides in your presentation. To change the font or bullets, insert art such as a logo that you want it to appear on multiple slides, Change Placeholder positions, size and formatting. For all these task you would need the help of a slide master.

Procedures:
1. Click on /View />/Master /
2. Choose one of the steps:

a. To insert a slide master that uses the default styles in PowerPoint on the slide master view toolbar, click on insert new Slide master.
b. To insert a slide master by adding a new design tem plated , on the formatting toolbar click on Design, point to the design you want, click on the arrow, and select one of the options of the options on the shortcut menu. If you want to insert a title master for an existing slide master, select the slide master thumbnail on the left and on the slide master view toolbar, click on insert new title master and close master view..


4. Once the change are made, click on the apply button for changing color to hte current slide or click apply to all button to apply the change to all slides in the presentation in the Background dialog box.

1. Click on /slide /show /> /Animations Schemes /

Adding Header and Footer to outline page

1. Click on /View /on the menu bar and then point to / Header and Footer /.Set the values (s) in dialog box that suits your presentation.

Adding a Word Art in your presentation
1. point to Word Art on drawing toolbar and click it.
2. Word art gallery dialog box appears.
3. Click ok .
Do necessary change likes in MS-Word if needed.
Note
Adding an auto shapes in your presentation [Like in MS-Word




Create a Slide master
To give all the slide in the presentation a uniform look, design template use the Slide Master. A slide master is an element of the design template that stores information about the template, including tent styles, placeholder sizes and positions, background design, and color schemes. With Slide Master you can make a marked change such as replacing the font style and have that change reflected on all the slides in your presentation. To change the font or bullets, insert art such as a logo that you want it to appear on multiple slides, Change Placeholder positions, size and formatting. For all these task you would need the help of a slide master.

Procedures:
1. Click on /View />/Master /
2. Choose one of the steps:

a. To insert a slide master that uses the default styles in PowerPoint on the slide master view toolbar, click on insert new Slide master.
b. To insert a slide master by adding a new design tem plated , on the formatting toolbar click on Design, point to the design you want, click on the arrow, and select one of the options of the options on the shortcut menu. If you want to insert a title master for an existing slide master, select the slide master thumbnail on the left and on the slide master view toolbar, click on insert new title master and close master view..


4. Once the change are made, click on the apply button for changing color to hte current slide or click apply to all button to apply the change to all slides in the presentation in the Background dialog box.

1. Click on /slide /show /> /Animations Schemes /

Rehearse Timing

1. On the Slide Show menu, click Rehearse Timings to start the show in rehearsal mode.
2. Click the advance button when you are ready to go to the next slide.
3. When you reach the end of the slide show, click yes to accept the timings or No to start over.

Set up show

Refer a Set up Show dialog box for advance setup.

Adding clip Art to Slide
A collection of drawings, photographs, sounds, videos and other media files shared with Office application, contained in the Microsoft Clip Organizer. There are tow ways to add Clip art to presentation.
1. One way is by selecting one of the slide layouts that includes a content placeholder with instructions to open the Microsoft Clip art to Organizer to add content. You will now add clip art to slides. When the button is double clicked in the content placeholder, it activates the instructions to open the Select Picture dialog box. This helps you to search for clips, through the use of keywords.
2. Another way is by clicking on the insert Clip Art button on the Drawing toolbar or / insert />/Picture / > Clip Art…/ to open the Insert Click Art task pane. The Insert Click Art task pane allows you to search for clips by using descriptive Keywords.

About smart tads
A "smart tag" is a type of button in Microsoft Power Point 2002 that appears after certain actions, such as an automatic text correction or a copy-and -paste, have taken place. The button has a menu of options that help you control the result or the action. For instance, if PowerPoint automatically capitalizes the first letter of a word, but you want the word lowercased in this instance, you can click the

"undo capitalization" option on the button menu to reverse the action. can either do /Double Click/ on it or/

Inserting, moving and sizing a click
After inserting clips, you can either do /Double Click/ on it or/ Right click/>/Format Picture/ .Go to /Size tab and do necessary changes.
Simply, move your mouse pointer over any nodes or edit points or handles of the place-holder around clip and drag it when resizing arrow appears. Press /Shift/ while dragging for constraint proportion

Importing chart from Microsoft Excel
1. Click on /insert />/Chart…/
2. Switch to Datasheet View.
3. Click on /Edit />/import file / The import dialog box appears.
4. Locate your excel file and click on open.
5. Select the sheet you want to import from the import data options.
Do one of the following:
a. Click on radio button of entire sheet under import in order to import all the data on the worksheet.
b. To import part of the data, click on Range and then type the range of data you want eg . a 1:b8
6. Click ok and finally click on blank area of the file.

Adding animation scheme to a slide show

Visual effects that vary that slide transitions and the methods in which the slide title and bullets or paragraphs display on the slide are some of the animations schemes that come packed with PowerPoint. It doesn't mean that all animations sachems have the slide transition element or effects for both the title and body text. These schemes are ground in three categories. Suitable, Moderate and Exciting. This effects is added easily busing the slide design text pane, which you used earlier in this project to select a design template.
Follow the steps mentioned below:
Custom Animation
1. In normal view, displays the slide that has the text or objects you want to animate.
2. Select the object you want to animate.
3. On the Slide Show menu, click Custom Animation.
4. In the Custom Animation task pane, click Add Effect ,and do one or the following:
If you want to make the text or object enter the slide show presentation with an effect, point to Entrance and then click an effect. Oif you want to add an effect to text or an object that is on the slide, point to Emphasis and then click an effect.
If you want to add an effect to text or an object that makes it leave the slide at some point, point to Exit and then click an effect.
Note The effects appear in the Custom Animation lists, top to bottom, in the order you apply them. The animated items are noted on the slide by a non-printing numbered tag that correlates to the effects in the list. This tag dose not show up in the slide show view.

Test animated Slide Show manually

1. Click on Slide Show following one of the processes you have learnt.
2. Go on Clicking or pressing Enter to see the upcoming slide and its animation.
You can edit your slide layout, animation scheme, sound etc anytime you like.
Printing a presentation created on outline tab
1. Click on the Outline Tab to see the outline of your presentation.
2. / File / >/ Print /
3. When the Print dialog box appears click on the Print to Outline View and click on it.
If the Expand All button on the Outlining toolbar is selected then entire outing will print . And only slide title will print if you clicked on Collapses All button.
It is always an easier option to review your outline in print rather that on screen when you are creating a long presentation. Printing your outline is also useful for audience handouts or when your supervisor or instructor wants to review your subjects matter before you develop your presentation entirely.

4. Click on Ok.

Rehearse Timing
1. On the Slide Show menu, click Rehearse Timings to start the show in rehearsal mode.
2. Click the advance button when you are ready to go to the next slide.
3. When you reach the end of the slide show, click yes to accept the timings or No to start over.

Set up show

Refer a Set up Show dialog box for advance setup.

Adding clip Art to Slide
A collection of drawings, photographs, sounds, videos and other media files shared with Office application, contained in the Microsoft Clip Organizer. There are tow ways to add Clip art to presentation.
1. One way is by selecting one of the slide layouts that includes a content placeholder with instructions to open the Microsoft Clip art to Organizer to add content. You will now add clip art to slides. When the button is double clicked in the content placeholder, it activates the instructions to open the Select Picture dialog box. This helps you to search for clips, through the use of keywords.
2. Another way is by clicking on the insert Clip Art button on the Drawing toolbar or / insert />/Picture / > Clip Art…/ to open the Insert Click Art task pane. The Insert Click Art task pane allows you to search for clips by using descriptive Keywords.

About smart tads
A "smart tag" is a type of button in Microsoft Power Point 2002 that appears after certain actions, such as an automatic text correction or a copy-and -paste, have taken place. The button has a menu of options that help you control the result or the action. For instance, if PowerPoint automatically capitalizes the first letter of a word, but you want the word lowercased in this instance, you can click the

"undo capitalization" option on the button menu to reverse the action. can either do /Double Click/ on it or/

Adding animation scheme to a slide show

Visual effects that vary that slide transitions and the methods in which the slide title and bullets or paragraphs display on the slide are some of the animations schemes that come packed with PowerPoint. It doesn't mean that all animations sachems have the slide transition element or effects for both the title and body text. These schemes are ground in three categories. Suitable, Moderate and Exciting. This effects is added easily busing the slide design text pane, which you used earlier in this project to select a design template.
Follow the steps mentioned below:
Custom Animation
1. In normal view, displays the slide that has the text or objects you want to animate.
2. Select the object you want to animate.
3. On the Slide Show menu, click Custom Animation.
4. In the Custom Animation task pane, click Add Effect ,and do one or the following:
If you want to make the text or object enter the slide show presentation with an effect, point to Entrance and then click an effect. Oif you want to add an effect to text or an object that is on the slide, point to Emphasis and then click an effect.
If you want to add an effect to text or an object that makes it leave the slide at some point, point to Exit and then click an effect.
Note The effects appear in the Custom Animation lists, top to bottom, in the order you apply them. The animated items are noted on the slide by a non-printing numbered tag that correlates to the effects in the list. This tag dose not show up in the slide show view.

Slide Transition
A visual effect that appears when you move from one slide to the next is called slide transition.
Repeat the following process for each slide you want to add a different transition to. On the Slides tab in normal view, select the slides you want to add a transition to.
1. On the Slide Shod menu, click Slide Transition.
2. In the list, click the transition effect you want.

In a presentation one can add transitions to slides and it will show its effects only when one slide moves to the nest .
If you have added the sound effect to the slide transition then you'll her the sound when one slides move to the next. You can choose any sound from the list and even browse the sound and take it into your presentation if sound file is compatible or supported.










2. Click on the transition you want to use. PowerPoint adds the transition to The displayed slide and display a preview of the transition.
To view again click on the transition again.
3. To add the sound effects to the transition, click on the down arrow to display a list of sound options.
4. Click on the desired sound you want to use. PowerPoint display a preview of the transition with the sound you selected.
5. To add the transition to all the slides in your presentation, click on Apply to All Slides.

Slide Layout

The arrangement of placeholders in a slide is specified by a Layout . These placeholders are arranged in various configurations and can contain text, such as the slide title or a bulleted, or they can contain contents such as clips, pictures, chars, table, and shapes. A particular slide layout can be specified by you when a new slide is added to a presentation or you do that even after a slide is created.
With the help of a Slide Layout task pane, a slide layout can be chosen. The layouts in this text pane are arranged in four areas; Text Layout, Content Layout, and Other Layout.

Procedures
1. click on /Format /in the Menu bar and then point to/ slide Layout /and click it.
2. Choose one layout that you want for your slide from task pane.

Adding a picture in your slide
1. Click insert Picture icon button to add a picture to the slide from the drawing toolbar. Insert picture dialog box appears.
2. Locate your picture and click insert button.
[Do necessary change like in MS-word if needed]


Adding diagram in a slide
1. Click on insert Diagram or organizational chart.
A diagram gallery dialog box appears. Select the type of diagram.

Inserting a table in your slide
1. Click Insert Table icon button to add a table to the slide.
Insert table dialog box appears like below.
Do necessary changes like in MS-word if needed.

Adding a chart to your slide
1. Click on Insert chart icon.
2. Click on View Datasheet button if the datasheet does not appear.
3. You can replace the data by clicking on cell in which data appears. You can even change the chart type from the chart menu which appears as soon as we click on chart button.
4. Press enter after typing.
5. Click on a blank area on your serene when you finish entering data.

Inserting Media Clip
1. Click on Insert Media Clip Button.
2. The Media Clip Dialog box appears like below.
3. Choose a media clip that suits yours presentations.
4. If you to import media clip from other then click on/ import..!
5. You will see the dialog box, locate your file here but that must be compatible or supported by media clip features.
6. Finally click on add button.

Changing Slide Background Color
To change a slide's background color or gradient, follow the following procedures.
1. Choose/Format/ > /Background/ The background dialog box appears.
2. Click on the down arrow of colors rectangle and click on the color or sleet either More colors or Fill effects.
3. You can change the color, gradient, texture or pattern, or you can use a picture file, as shown in the more colors and fill effects dialog box below.

Animation effects in Presentation
Applying animation schemes

To give a professional look to the slide show presentation, PowerPoint has animation effects that can make the show interesting. Animation includes special visual and sound effects applied to text or content. For example, each line on the slide can swivel as it displays on the screen. Or an object can zoom in from the top of the screen to the bottom. PowerPoint provides a variety present animation schemes that determine slide transitions and effects for the title and body text. A special effects used to progress from one slide to the next in a slide show is called a Slide Transition. PowerPoint also allows you to set your own Custom Animation effect by defining your Owen animations types and speed and sound effects on a slide.