Working with Content - IV

Enter Text
To enter text:

• Select the slide where you want the text
• Click in a Textbox to add text

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

Select Text
To select the text:

• Highlight the 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

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

Undo and Redo
To undo or redo your most recent actions:

• On the Quick Access Toolbar
• Click Undo or Redo

Spell Check
To check the spelling in a presentation:

• Click the Review tab
• Click the Spelling button

Creating a Presentation - III

« Customize PowerPoint Presentation Working 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 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 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 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 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 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 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 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 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 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 To apply new colors to a theme: Click the Colors drop down arrow Choose a color set or click Create New Theme Colors To change the background style of a theme Click the Background Styles button on the Design tab

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.

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

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

Performing Calculations - VI

Excel FormulasA formula is a set of mathematical instructions that can be used in Excel to perform calculations.  Formals are started in the formula box with an = sign.

There are many elements to and excel formula.

References:  The cell or range of cells that you want to use in your calculation
Operators:  Symbols (+, -, *, /, etc.) that specify the calculation to be performed
Constants:  Numbers or text values that do not change
Functions:  Predefined formulas in Excel

Modifying a Worksheet - V

Insert Cells, Rows, and Columns
To insert cells, rows, and columns in Excel:

• Place the cursor in the row below where you want the new row, or in the column to the left of where you want the new column
• Click the Insert button on the Cells group of the Home tab
• Click the appropriate choice: Cell, Row,  or Column

 

Delete Cells, Rows and Columns
To delete cells, rows, and columns:

• Place the cursor in the cell, row, or column that you want to delete
• Click the Delete button on the Cells group of the Home tab
• Click the appropriate choice:  Cell, Row, or Column

Find and Replace 
To find data or find and replace data:

• Click the Find & Select button on the Editing group of the Home tab
• Choose Find or Replace
• Complete the Find What text box
• Click on Options for more search options

Go To Command
The Go To command takes you to a specific cell either by cell reference (the Column Letter and the Row Number) or cell name. 

• Click the Find & Select button on the Editing group of the Home tab
• Click Go To

Spell Check
To check the spelling:

• On the Review tab click the Spelling button

Manipulating Data - IV

Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting.

Select Data
To select a cell or data to be copied or cut:

• Click the cell

• Click and drag the cursor to select many cells in a range

Select a Row or Column
To select a row or column click on the row or column header.

Copy and Paste
To copy and paste data:

• Select the cell(s) that you wish to copy
• On the Clipboard group of the Home tab, click Copy

• Select the cell(s) where you would like to copy the data
• On the Clipboard group of the Home tab, click Paste

Cut and Paste
To cut and paste data:

• Select the cell(s) that you wish to copy
• On the Clipboard group of the Home tab, click Cut

• Select the cell(s) where you would like to copy the data
• On the Clipboard group of the Home tab, click Paste

Undo and Redo
To undo or redo your most recent actions:

• On the Quick Access Toolbar
• Click Undo or Redo

Auto Fill
The Auto Fill feature fills  cell data or series of data in a worksheet into a selected range of cells. If you want the same data copied into the other cells, you only need to complete one cell.  If you want to have a series of data (for example, days of the week) fill in the first two cells in the series and then use the auto fill feature. To use the Auto Fill feature:

• Click the Fill Handle
• Drag the Fill Handle to complete the cells