Tuesday, May 3, 2011

Graphics - VII


Adding Picture
To add a picture:
  • Click the Insert Tab
  • Click the Picture Button
  • Browse to the picture from your files
  • Click the name of the picture
  • Click insert
  • To move the graphic, click it and drag it to where you want it
Insert Picture Dialog Box
Adding Clip Art
To add Clip Art:
  • Click the Insert Tab
  • Click the Clip Art Button
  • Search for the clip art using the search Clip Art dialog box
  • Click the clip art
  • To move the graphic, click it and drag it to where you want it
Adding Clip Art
Editing Pictures and Clip Art
When you add a graphic to the presentation, an additional Tab appears on the Ribbon.  The Format Tab allows you to format the pictures and graphics.  This tab has four groups:
Adjust:  Controls the picture brightness, contrast, and colors
Picture Style:  Allows you to place a frame or border around the picture and add effects
Arrange:  Controls the alignment and rotation of the picture
Size:  Cropping and size of graphic
Format Pictures Toolbar
Adding a Shape
To add Shapes:
  • Click the Insert Tab
  • Click the Shapes Button
  • Click the shape you choose
Insert Shapes Drop Down
  • Click the Slide
  • Drag the cursor to expand the Shape
Resize Shape Active Shape
To format the shapes:
  • Click the Shape
  • Click the Format tab
Shapes Toolbar
Adding SmartArt
SmartArt is a feature in Office 2007 that allows you to choose from a variety of graphics, including flow charts, lists, cycles, and processes.  To add SmartArt:
  • Click the Insert Tab
  • Click the SmartArt Button
  • Click the SmartArt you choose
Smart Art Dialog Box
  • Click the SmartArt
  • Drag it to the desired location in the slide
To format the SmartArt:
  • Click the SmartArt
  • Click either the Design or the Format tab
  • Click the SmartArt to add text and pictures.
Smart Art Design Toolbar
Adding a Photo Album
The photo album feature is new in PowerPoint 2007 and allows you to easily create a photo album to share pictures. To create a photo album:
  • Click the Photo Album button on the Insert tab
  • Click New Photo Album
  • Click File/Disk to add pictures to the photo album
  • Move the pictures up and down in the order of the album but clicking the up/down arrows
Insert Photo Album Dialog Box

Adding Content - VI


Resize a Textbox
To resize a textbox:
  • Click on the textbox
  • Click the corner of the box and drag the cursor to the desired size
Resize Image Graphic
Bulleted and Numbered Lists
Bulleted lists have bullet points, numbered lists have numbers, and outline lists combine numbers and letters depending on the organization of the list.
To add a list to existing text:
  • Select the text you wish to make a list
  • Click the Bulleted or Numbered Lists button
Lists Buttons
To create a new list:
  • Place your cursor where you want the list in the document
  • Click the Bulleted or Numbered Lists button
  •  Begin typing
Nested Lists
A nested list is list with several levels of indented text. To create a nested list:
  • Create your list following the directions above
  • Click the Increase or Decrease Indent button
Indent Buttons
Formatting Lists
The bullet image and numbering format can be changed by using the Bullets or Numbering dialog box.
  • Select the entire list to change all the bullets or numbers, or
    Place the cursor on one line within the list to change a single bullet.
  • Click the arrow next to the bulleted or numbered list and choose a bullet or numbering style.
Bullets Dialog Box
Adding Video
Video clips can be added to the presentation.  To add a video clip:
  • Click the Movie button on the Insert tab
  • Choose Movie from File or Movie from Clip Organizer
Insert Movie Button
To edit the video options:
  • Click the movie icon
  • Click the Format tab
Picture Tools Toolbar
Adding Audio
Audio clips can be added to the presentation.  To add an audio clip:
  • Click the Audio button on the Insert tab
  • Choose Sound from FileSound from Clip OrganizerPlay CD Audio Track, or Record Sound
Insert Audio Button
To edit the audio options:
  • Click the audio icon
  • Click the Format tab
Sound Tools Toolbar 

Formatting Text - V


Change Font Typeface and Size
To change the font typeface:
  • Click the arrow next to the font name and choose a font. 
  • Remember that you can preview how the new font will look by highlighting the text, and hovering over the new font typeface.
Font Preview Screen

To change the font size:
  • Click the arrow next to the font size and choose the appropriate size, or
  • Click the increase or decrease font size buttons.
Font Size Arrows
Font Styles and Effects
Font styles are predefined formatting options that are used to emphasize text.  They include:  Bold, Italic, and Underline.  To add these to text:
  • Select the text and click the Font Styles included on the Font group of the Home tab or
  • Select the text and right click to display the font tools
Font Group
Change Text Color
To change the text color:
  • Select the text and click the Colors button included on the Font Group of the Ribbon, or
  • Highlight the text and right click and choose the colors tool. 
  • Select the color by clicking the down arrow next to the font color button.
Font Color Drop Down
WordArt
WordArt are styles that can be applied to text to create a visual effect. To apply Word Art:
  • Select the text
  • Click the Insert tab
  • Click the WordArt button
  • Choose the WordArt
Word Art Drop Down
To modify the styles of WordArt
  • Select the WordArt
  • Click the Format tab for the Drawing Tools
  • Click the WordArt Fill button, the WordArt Outline button, or the Text Effects button
Format Word Art Buttons
Change Paragraph Alignment
The paragraph alignment allows you to set how you want text to appear.  To change the alignment:
  • Click the Home Tab
  • Choose the appropriate button for alignment on the Paragraph Group.
    • Align Left:  the text is aligned with your left margin
    • Center:  The text is centered within your margins
    • Align Right:  Aligns text with the right margin
    • Justify:  Aligns text to both the left and right margins.
Format Paragraph Group
Indent Paragraphs
To indent paragraphs, you can do the following:
  • Click the Indent buttons to control the indent. 
  • Click the Indent button repeated times to increase the size of the indent.
Indent Pargraph Buttons
Text Direction
To change the text direction:
  • Select the text
  • Click the Text Direction button on the Home tab
  • Click the selection
Text Direction Button

Working with Content - IV


Enter Text
To enter text:
  • Select the slide where you want the text
  • Click in a Textbox to add text
Textbox Picture
To add a text box:
  • Select the slide where you want to place the text box
  • On the Insert tab, click Text Box
  • Click on the slide and drag the cursor to expand the text box
  • Type in the text
Text Box Button
Select Text
To select the text:
  • Highlight the text
Highlighted Text
Copy and Paste
To copy and paste data:
  • Select the item(s) that you wish to copy
  • On the Clipboard Group of the Home Tab, click Copy
  • Select the item(s) where you would like to copy the data
  • On the Clipboard Group of the Home Tab, click Paste
Copy and Paste Buttons
Cut and Paste
To cut and paste data:
  • Select the item(s) that you wish to copy
  • On the Clipboard Group of the Home Tab, click Cut
  • Select the items(s) where you would like to copy the data
  • On the Clipboard Group of the Home Tab, click Paste
Cut and Paste
Undo and Redo
To undo or redo your most recent actions:
  • On the Quick Access Toolbar
  • Click Undo or Redo
Undo and Redo Buttons
Spell Check
To check the spelling in a presentation:
  • Click the Review tab
  • Click the Spelling button
Spelling Button

Creating a Presentation - III



« Customize PowerPointPresentationWorking with Content »
New Presentation
You can start a new presentation from a blank slide, a template, existing presentations, or a Word outline.  To create a new presentation from a blank slide:
  • Click the Microsoft Office Button
  • Click New
  • Click Blank Presentation
Blank Presentation Dialog Box
To create a new presentation from a template:
  • Click the Microsoft Office Button
  • Click New
  • Click Installed Templates or Browse through Microsoft Office Online Templates
  • Click the template you choose
Installed Templates
To create a new presentation from an existing presentation:
  • Click the Microsoft Office Button
  • Click New
  • Click New from Existing
  • Browse to and click the presentation
New From Existing Open Dialog Box
To create a new presentation from a Word outline:
  • Click the slide where you would like the outline to begin
  • Click New Slide on the Home tab
  • Click Slides from Outline
  • Browse and click the Word Document that contains the outline
Slides from Outline New Slide Options
Save a Presentation
When you save a presentation, you have two choices: Save or Save As.
To save a document:
  • Click the Microsoft Office Button
  • Click Save
Save Option
You may need to use the Save As feature when you need to save a presentation under a different name or to save it for earlier versions of PowerPoint.  Remember that older versions of PowerPoint will not be able to open PowerPoint 2007 presentation unless you save it as a PowerPoint 97-2003 Format. To use the Save Asfeature:
  • Click the Microsoft Office Button
  • Click Save As
  • Type in the name for the Presentation
  • In the Save as Type box, choose Excel 97-2003 Presentation
Save As Options
Add Slides
There are several choices when you want to add a new slide to the presentation: Office Themes, Duplicate Selected Slide, or Reuse Slides.
To create a new slide from Office Themes:
  • Select the slide immediately BEFORE where you want the new slide
  • Click the New Slide button on the Home tab
  • Click the slide choice that fits your material
New Slide
To create a slide as a duplicate of a slide in the presentation:
  • Select the slide to duplicate
  • Click the New Slide button on the Home tab
  • Click Duplicate Selected Slides
Duplicate Slides
To create a new slide from another presentation:
  • Select the slide immediately BEFORE where you want the new slide
  • Click the New Slide button on the Home tab
  • Click Reuse Slides
  • Click Browse
  • Click Browse File
  • Locate the slide show and click on the slide to import
Reuse Slides
Themes
Themes are design templates that can be applied to an entire presentation that allows for consistency throughout the presentation.  To add a theme to a presentation:
  • Click the Design tab
  • Choose one of the displayed Themes or click the Galleries button
Themes Group
To apply new colors to a theme:
  • Click the Colors drop down arrow
  • Choose a color set or click Create New Theme Colors
Theme Color Drop Down
To change the background style of a theme
  • Click the Background Styles button on the Design tab
Background Styles

Customizing PowerPoint - II


PowerPoint 2007 offers a wide range of customizable options that allow you to make PowerPoint work the best for you.  To access these customizable options:
  • Click the Office Button
  • Click PowerPoint Options include picture of OB menu.   

Getting Started - I


Getting started with PowerPoint 2007 you will notice that there are many similar features to previous versions.  You will also notice that there are many new features that you’ll be able to utilize.  There are three features that you should remember as you work within PowerPoint 2007:  the Microsoft Office Button, the Quick Access Toolbar, and the Ribbon.  The function of these features will be more fully explored below.
PowerPoint Window

Monday, May 2, 2011

Customize the Layout - XIII


Split a Worksheet
You can split a worksheet into multiple resizable panes for easier viewing of parts of a worksheet. To split a worksheet:
  • Select any cell in center of the worksheet you want to split
  • Click the Split button on the View tab
  • Notice the split in the screen, you can manipulate each part separately

Page Properties and Printing - XII


Set Print Titles
The print titles function allows you to repeat the column and row headings at the beginning of each new page to make reading a multiple page sheet easier to read when printed.  To Print Titles:
  • Click the Page Layout tab on the Ribbon
  • Click the Print Titles button
  • In the Print Titles section, click the box to select the rows/columns to be repeated
  • Select the row or column
  • Click the Select Row/Column Button
  • Click OK

Developing a Workbook - XI


Format Worksheet TabYou can rename a worksheet or change the color of the tabs to meet your needs.
To rename a worksheet:
  • Open the sheet to be renamed
  • Click the Format button on the Home tab
  • Click Rename sheet
  • Type in a new name
  • Press Enter

Formatting a Worksheet - XI


Convert Text to Columns
Sometimes you will want to split data in one cell into two or more cells.  You can do this easily by utilizing the Convert Text to Columns Wizard.
  • Highlight the column in which you wish to split the data
  • Click the Text to Columns button on the Data tab
  • Click Delimited if you have a comma or tab separating the data, or click fixed widths to set the data separation at a specific size. 

Charts - X


Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types of charts including: Column, Line, Pie, Bar, Area, Scatter and more.  To view the charts available click the Insert Tab on the Ribbon.
Create a Chart
To create a chart:
  • Select the cells that contain the data you want to use in the chart
  • Click the Insert tab on the Ribbon
  • Click the type of Chart you want to create

Graphics - IX


Adding a Picture
To add a picture:
  • Click the Insert tab
  • Click the Picture button
  • Browse to the picture from your files
  • Click the name of the picture
  • Click Insert
  • To move the graphic, click it and drag it to where you want it

Sort and Filter - VIII


Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria.
Basic Sorts
To execute a basic descending or ascending sort based on one column:
  • Highlight the cells that will be sorted
  • Click the Sort & Filter button on the Home tab
  • Click the Sort Ascending (A-Z) button or Sort Descending (Z-A) button
Sort and Filter Drop Down Menu

Macros - VII


Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed in one step.
Recording a Macro
To record a Macro:
  • Click the View tab on the Ribbon
  • Click Macros
  • Click Record Macro
  • Enter a name (without spaces)
  • Enter a Shortcut Key
  • Enter a Description