This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Monday, December 17, 2012

Action Button & Setting


Action buttons and action settings: 
With help of action buttons you can create a link between slides. (For example when you r viewing the last slide, you can go to the first slide again by putting the action button.)

·         Click on slide show menu
·         Click on action button
·         Select a button according to your requirement and drag the mouse to draw it in the slide.
·         The action settings dialogue appears. You can select any tab mouse click or mouse over, which will work, according to your selection. (For example select the mouse click.)
·         Automatically hyperlink to option get selected
·         Now from the list select any option as required (for example to move to the next slide select from the list next slide )


·         Then click ok.
·         This way you can link with the slides, document, web page etc.
·         Using action settings you can run a program also.
·         You can either drop an action button or you can select an object. (For example you can select a picture).
·         When you are linking with the action buttons, the action setting dialogue comes automatically but when you are going to link a program with an object select it and open action settings from the slide show menu.
·         Click on run program option, click on browse.
·         Select any program(for example select notepad)
·         Then click ok and again click ok.
·         Now when you are viewing the show click on the objects or button where you have set the program. The program starts running.
·         To play sounds check the play sound check box from the action settings dialogue and then select any sound from the list. Now when you are viewing the show click on the objects or button where you have set the sound. Then it starts playing the sound.


SET UP SHOW:
·         Open setup shows from slide show menu.
·         Here you can change the show type according to your requirement (For ex….- If you check the option loop continuously until esc,than the view show will continue till you press Esc Button.)
·         From the slides you can select all to set for all slides or you can select the slides by mentioning the starting number and the end number in from and to box .
·         From Advance slides you can set the show manually or you select the next option using timings, if present to run the view show with timings.
·         When you have done the entire setting click OK.

ANIMATION PREVIEW: Animation preview shows the preview of the slides. This will give you an idea before running the show.

Insert Object Text


Insert objects and text into our newly designed slides.
Insert New Slide: Go to the file menu and select Insert >> New Slide. A new slide will be inserted after the slide you are currently working with (shortcut command: Ctrl+M).

Insert Text Box: Go to the insert menu and select Insert >> Insert Text Box.

Insert Picture: Go to the file menu and select Insert >> Picture and choose from one of the options, depending on what type of picture you want to insert.

Clipart: "Clipart" are images that already come packaged with your computer. These are generally simple images that can be very effective when used in PowerPoint presentation. Clipart also functions as eye-candy for your slideshow to keep things looking interesting. Use the Clipart menus to navigate through different categories of images to find the pictures that best suit your needs.

From File: You can use the "From File" option to browse your computer to insert a specific image that you have saved.

AutoShapes: "AutoShapes" lets you create your own simple graphics, such as lines, word balloons, stars, and other shapes.

Insert Slide Number: In PowerPoint, you can number each of your slides. To do this, insert a new text box for where you want your slide number to be positioned, and select Insert >> Slide Number from the menu bar.

Insert Date and Time: Works just like the above "Insert Slide Number" tool. You must make a separate text box to insert your date and time. Then, select Insert >> Date and Time from the menu bar. A pop up window will then appear, allowing you to select an appearance for the date and time.

Insert Movie or Sound: For a media-rich slideshow, you may decide to display some movie or sound files that you can play during your presentation. You must first have the movie or sound file saved on your computer.

Insert Chart: By going to the menu bar and selecting Insert >> Chart, a spreadsheet will pop up into PowerPoint. You can manipulate data in order to create your own charts and graphs.

Insert Table: Go to the menu bar and select Insert >> Table to insert a number of rows and columns to create a table. When the table is inserted, a new table menu window will pop up with various formatting features. Here, you can add borders, change the border sizes of the table, and manage the cells in the table.

Insert Hyperlink: If you are giving a presentation on a computer that has access to the Internet, then you may find it helpful to have some hyperlinks in your slideshow, so that you can click on a link while you are presenting and then demonstrate a web site. To insert a hyperlink, go to the menu bar and select Insert >> Hyperlink. Then, a new window will appear for specifying the information regarding the hyperlink you want to insert into your document.

Insert WordArt: Inserting a WordArt element rather than regularly formatting text can give a little extra flair. WordArt is essentially text effects. To bring up the WordArt Gallery, open up the WordArt toolbar by going to the menu bar and selecting View >> Toolbars >> WordArt. A separate toolbar just for making WordArt will now appear.

View Show


VIEW SHOW: When you have finished creating the presentation it is time to see the show. This we will do with view show.

·         Click on slide show menu.
·         Click on view show.
·         (Note-if you have set the timing for the show it ends automatically. Else when you reach at the last slide at the left corner there is a button. Click it, a popup menu arrives click on end show.)
      Now the different view of power point is discussed.

NORMAL: In the Normal view you can add text, objects etc. in the slides directly or else you can write in the left pane next to the slide numbered icon.

SLIDE SORTER: Slide sorter view shows the miniature of all slides. Here you can change the position of the slides just by dragging with the mouse pointer and leaving it at the correct position. In this view you cannot alter any text, objects of the slides.

NOTE PAGES: Note pages view shows a portrait format of the slide with a space to add notes. You can add important information in the notes. Here you cannot alter any text, objects of the slides.

SLIDES SHOW: When you click on slide show from the view menu it shows the slide show, the same thing what you seen using view show from the slide show menu.

AUTO CONTENT WIZARD: You can create the presentation using the auto content wizard also. The wizard guides you with different steps and then creates a beautiful presentation. 

Slide Transitions



Slide Transitions: The Slow, Medium, and Fast options refer to the speed of the transition. Again, you'll see a preview of what they do when you select each option.
You can also play a Sound when each slide appears. Click the dropdown list to see the available options. But they are the same sounds you heard for the bullets. You have to decide whether playing a sound with each new slide is suitable for the presentation. If it's a professional, work-based presentation then the answer is almost always No. After all, do you really want your boss scared half to death by the sound of Gunshots and Explosions? OK, don't answer that!

The other option is Advance. The default is to have each slide transition after the mouse has been clicked. You can also tick the box next to automatically after. This lets you set how many seconds/minutes to wait before the next slide appears.
But when you've finished experimenting, click either the Apply to All, or Apply to all Slides button. This will return you to your main presentation.
Press F5 and run your presentation. Ask yourself, Do the slide transitions look OK, or a bit gimmicky?


Custom Animation


Custom Animation: Open custom animation from the slide show menu you will find all the above objects are listed next to a check box. A label displays a message check to animate slide objects.
So you have to click on the box to check them.
·         Now select each object by clicking on it (for example u want to put effect on word art so select word art from the list

·         Now click on effects tab if it is not open.
·         Now from the entry animation and sound list select animation (for example fly)
·         Select a sound from the sound list (for example camera).
·         When you are  putting effects for the text from the introduce text list box you can select any option to introduce text in that format (for example select by latter )
When you have finished click ok.


Design Template


Design Template: A template, also called a presentation design, lets you create a presentation without worrying about design elements. The template defines the color, background, and font of the slides. PowerPoint has many templates, which you can preview and select in the New Presentation dialog box.
PowerPoint also lets you customize the templates. For instance, you can change the background color or typeface of a template.
In the “New” section of the “New Presentation” panel, click on the “From Design Template” button. The following panel will then appear:
                                                                          
This is a list of different design templates. They are pre-made backgrounds and layouts that you can use to build your presentation. Use the scroll bar to see the entire list of designs.
When you see a design template you like, simply click on the design, and it will be applied to your presentation. Now, every time you make a new slide, it will retain the design template you selected. You can choose a new design template by clicking on a different design in the “Slide Design” panel on the right.
You can right-click on a design template to bring up even more options. You can apply a design template to selected slides, all the slides, use the design for all new presentations you create.



Blank Presentation

Blank Presentation: Click on the “blank presentation” button. The panel will then give you a number of slide layouts to choose from.
There are different kinds of objects in the slide layouts: long bars of gray represent text boxes, boxes with little pictures in them represent image objects, and the bulleted lists represent unordered lists.
If you choose to select from one of these pre-made slide layouts you can change the positioning and even delete some of the objects in the layout. you can choose to make a completely blank slide, and then insert objects and text as you work . Find a layout you like, and click on it in the panel window. As soon as you click on the layout in the “Slide Layout” panel, the layout will be applied to the current slide.
From this point, you are free to create the rest of your presentation as you see fit. To create a new slide based on a pre-made layout, right-click on the layout you like in the “Slide Layout” panel, and select “Insert Slide.” You will then see the new slide appear on your screen, as well as in the “Slide” view on the left side of your screen. If you want to change the order of the slides you made, simply click and drag the selected slide in the “Slide” panel to the desired location.





Create a New Presentation



Create a New Presentation: If you want to start a new presentation, you can do one of many things. Click on the "Create a new presentation..." button. You'll notice a change in the "Getting Started" panel. It's now called "New Presentation,
In the "New" section, you can make a new presentation using a blank presentation, a design template, the AutoContent wizard, an existing presentation, or from a photo album. At this point, we’ll describe in detail the different ways you can begin your new presentation.




Introduction To Microsoft Power Point


Introduction: 

PowerPoint is an application used for the creation of presentations. These presentations are laid out in a "storyboard" type fashion, where individual slides are created and formatted with text and images. PowerPoint presentations are widely used in classrooms as note outlines for teachers and for project presentations by students.
The point of the slides in PowerPoint presentations is NOT to fit as much detailed information as you can onto a single slide. Rather, each slide should contain elements that briefly sum up the major idea(s) of what you will be presenting for the duration of the slide.
The style in which you create slides is completely up to you. PowerPoint allows you to choose from a wide variety of formats that include sections such as titles, lists, images, or charts. Any of these can be incorporated into your presentation. The main thing to keep in mind, however, is that an audience will be viewing this material; it must be large enough to read, yet not so large that it takes up far too much of the screen to include relevant.

Across the top of the screen, you’ll notice a toolbar that looks similar to ones used in word processing program. These tools allow you to format and edit text and other elements in your slide.
On the left side of the screen, there’s a panel with two tabs called “Slides” and “Outline” this allows you to view all of your slides in your slideshow as small images (in the “Slides” mode) or as text (you can view as text if you click on the “Outline” tab).
The panel on the bottom has more tools for editing your slides, such as Drawing and AutoShapes. 

How to Start M.S. Power Point

1.  Start à All Programsà Microsoft Officeà MS-Power Point
2.  Start à All Programsà Microsoft Officeà MS-Power Point à Right Click à Send To à Desktop
     3. Start à Run à Powerpnt




About the Slides: On any given slide in a PowerPoint presentation, you can present your information in a variety of ways. You can type in text using text boxes, insert images or sounds, create charts, graphs, or lists, and make text columns. Each separate element in a slide (be it text or an image) is considered its own object, and can be moved and modified independently from other objects in a slide.
The Task Pane: The panel on the right side of the screen is actually called the “Task Pane.” As the name implies, it controls all the main slide control tasks for your presentation. If you ever lose sight of this panel, go to the menu bar in PowerPoint, navigate to “View,” select the “Toolbars” menu, and make sure “Task Pane” is selected or you can get it by pressing “CTRL+F1”.



Thursday, December 13, 2012

Window


Window: Open new window just above the opened document to switch over from opened window to window by & splitting or to arrange the opened document window.


New Window: Create a duplicate window according to the current windows.

Arrange All: Arrange all windows on the screen in tile wise.

Hide: Hides the active workbook window or makes a hidden window visible. A hidden window remains open.

Unhide: Display hidden workbook windows.



Split/Remove Split: Split the window in the any point.

Freeze Panes: Freeze Panes Command Freezes the top pane, the left pane, or both, on the active worksheet. The Freeze Panes button is in the utility category.




Data

Data:


Sort: Sort command rearranges a range of worksheet data alphabetically or numeric in order the sort command is suited for rearranging the rows of a list or database, you can also rearrange columns of data. You can define as three keys of each sort operation in Ascending or Descending Order.

Filter: Filter allow you to work with selected rows of information in list, including a list that you have organized as a database. Excel gives you two effective ways to filter a list or database. The simpler of the two techniques is known as AutoFilter. When you select this feature, Excel provides drop-down lists at the top of every columns in your database.

Forms: Displays the column labels that correspond to each column in your list. In the box to right of the column labels, you can enter new records at the end of the list, edit existing records or find records in your list based on criteria you specify. If you click the restore button then restores edited fields in the displayed record removing your changes.


Subtotal: Calculate a subtotal for the columns you select and inserts subtotal rows in the current list. Microsoft Excel inserts a subtotal row at each change in the column you select and a Grand Total row at the bottom of the list.

At each change in: Select a label from the at each change in box to specify the column the items or groups by which you want to subtotal values in other columns.

Use Function: You can also select a function to use for the subtotal calculation; Sum is the most common choice, but other function are also available, such as Count, Average, Max, Min, Product, Count Num etc.

Add subtotal to: Select one or more check boxes under add subtotal to specify the columns that contain value you want to subtotal.

Validation: Defines what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers or text and limits on the valid entries.

Text to columns: Separates text in one cell on a worksheet into columns by using the convert text to columns wizard.

Table: Creates a data table based on input values and formulas you define. Data tables can be used to show the results of changing values in your formulas.

Consolidate: This Command is used to merge two or more files (Table) with functions.

Pivot Table: A Pivot Table is dynamic, customizable tool designed to help you rearrange, summarize and explore information from a database or list. The pivot table wizard provides a simple four-step graphical approach. First Choose the Microsoft Excel list or database, External Data source, Multiple Consolidate Range, Another Pivot Table.
Second select the pivot table in new sheet or select the cell on the worksheet, or type a cell reference in the existing worksheet box to specify the upper-left cell of the range on the worksheet where you want the pivot table to be placed.




Tool


Tool: Includes checking grammar & spelling, to select auto summarize & auto correct  facility, document protection, create envelope & tables or labels, macros, mail merging the document. It also includes the option button which includes all the main settings of MS-Word such as security, File location, compatibility etc. 


Spelling and Grammar: Spell check is run using either the tools/ spelling menu selection or by clicking the spelling button. You can check an entire document or a selected word or passage.

Language: You can change the language or omit proofing for a document or for selected text in a document. If you change the language, you must have the dictionary of the language or a related to check the spelling.

Thesaurus: Electronic thesaurus lets you look up and select synonyms for words in the text of you WordStar document at any time during editing.

Share Workbook: Choose this option if you want several users to work on the data in the same workbook simultaneously. Make it available on your network and anyone with access can make changes.

Protection: You can password protect a single sheet of a workbook, or the entire workbook. One obvious application would be to protect a worksheet which you are using as your grade book.

Goal Seek: The Goal seeks Command adjust a Numeric entry that a formula depends on, to achieve a target result from the formula itself.

Scenarios: Creates and saves scenarios, which are sets of data you can use to view the results of what-if analyses. The scenario Manager is especially useful on a worksheet that is organised into distinct “Input” and “Output” areas.

 Formula Auditing: The command in the Auditing submenu allows you to trace precedents and dependents on a worksheet. A precedent is a cell that is referenced in the formula of the active cell. A dependent is a cell containing a formula that refers to the active cell.

Macro: A macro is a series of commands that you can group together as a signal command to make everyday task simpler and easier. A macro is first recorded and saves with a name and a shortcut key. When you record the macro, you perform a series of steps. When you run the macro, these steps are performed exactly as you recorded them.

Auto correct: Control the capitalization of some text when you are inputting a string of artistic text or block of paragraph text. It also allows you to build quick shortcut words when entering repetitive information.

Customize: Create a custom toolbar
  1. On the Tools menu, click Customize.
  2. Click the Toolbars tab.
  3. Click New.
  4. In the Toolbar name box, type the name you want.
  5. Click the Commands tab.
  6. Do one of the following:
Add a button to the toolbar
1.    Click a category in the Categories box.
2.    Drag the command you want from the Commands box to the displayed toolbar.
3.    In the Categories box, click Built-in Menus.
Drag the menu you want from the Commands box to the displayed toolbar.