CPT Skills - Instructions

Word

Create a new document

1. In the task pane, in the New section, click Blank Document.

Save the document in the current folder

1. In the menu bar, go to File > Save As.
2. In the File name field, type in the new name of the document, and click Save.

Change the document orientation

1. In the menu bar, go to File > Page Setup.
2. Click Landscape, then click OK.

Change the margins on a page without using the ruler

1. Go to File > Page Setup.
2. Change the size of the margin using the up and down arrows, or by typing in a new value. Click OK.

Apply columns to text

1. Go to Format > Columns.
2. Select the number of columns requested. Click OK.

Indent first line of paragraph

1. Go to Format > Paragraph.
2. In the Special field, select First Line, and in the next field, use the arrows to select the length. Click OK.

Apply the default style of bullets to a list of items

1. Select the list of items, if it is not already selected, and click the Bullets on the toolbar.

Activate the header of a document and add text to the footer

1. Double click on the text in the header to activate it.
2. Click the Switch Between Header and Footer button on the Header and Footer toolbar to begin adding text to the footer.

Format the page number style on a document

1. Click the Format Page Number button.
2. Select a page number format from the Number format drop-down list and click OK.

Bold the selected text

1. Click the Bold button on the toolbar.

Delete the selected text

1. Hit the Backspace key on the keyboard.

Center the selected text

1. Click on the Center button on the toolbar.

Correct spelling

1. Go to Tools > Spelling and Grammar to start running Spell Check.

Insert symbols

1. Go to Insert > Symbol.
2. Choose the correct symbol and click Insert.

Insert a table

1. In the menu bar, go to Table > Insert > Table.
2. Use the arrows to enter the number of columns and rows you need, or just type in a number. Click OK.

Replace one word with another

1. Go to Edit > Replace.
2. In the Find field, type the word you would like to find, and in the Replace with field, type the word you would like to replace it with. Click Replace to just replace one instance; click Replace All to replace all instances of the word.

Print selected pages

1. Go to File > Print.
2. Enter the pages you would like to print and click OK.

PowerPoint

Create a new presentation

1. Click the New button on the toolbar.

Create a new presentation using the AutoContent Wizard

1. In the task pane, under the New section, click the From AutoContent Wizard.

Create a new presentation using a design template

1. In the task pane, under New, click From Design Template.
2. Click on a design template to apply it to the new presentation.

Enter text in the Outline pane

1. Click in the outline pane, next to the slide.
2. Type in the text, then hit the Enter key.

Change the slide layout

1. Go to Format > Slide Layout.
2. Click on a layout to apply it to the slide.

Delete slides

1. Go to Edit > Delete Slide.

Change text fonts

1. In the toolbar, click the drop-down arrow next to the Font box. Click on the name of a font to apply it to the text.

Change bullets and numbering formats

1. Go to Format > Bullets and Numbering.
2. Change tabs if needed, then click on a format, and click OK to apply it.

Change the layout of all slides at once

1. Go to View > Master > Slide Master.
2. Any changes you make will be applied to the entire presentation.
3. To exit the Slide Master, click the Close Master View button on the Slide Master View toolbar.

Add the date and time as a footer

1. Go to View > Header and Footer.
2. Click Date and time to add the date and time, and select Update Automatically to have them update themselves.
3. Click Apply to All to put the footer on each slide.

Move slides in the Slide Sorter

1. Click on a slide and drag it to a new location, then release the mouse button. The light grey line indicates where the slide will be dropped.

Insert clip art

1. Go to Insert > Picture > Clip Art.

Insert a chart

1. Go to Insert > Chart.

Change chart layout

1. Go to Chart > Chart Type. If you do not see the Chart menu, double-click on your chart to activate it, and the menu should appear.
2. Click on a layout in the Chart Type column.
3. In the Chart sub-type area, click on a sub-type. Note that there is a description of the type below. Click OK to finish.

Animate WordArt

1. Go to Slide Show > Custom Animation.
2. Click the Add Effect button, choose the type of effect, then the actual effect.

Print outlines

1. Go to File > Print.
2. In the Print what section, choose Outline View from the drop-down menu.
3. Click OK.

Print handouts

1. Go to File > Print.
2. In the Print what section, choose Handouts from the drop-down menu.
3. In the Hadnouts area, choose the number of slides per page from the drop-down menu.
4. Click OK.

Excel

Open a saved workbook

1. Go to File > Open.
2. Click on the name of the file and click Open.

Freeze cells

1. Go to Window > Freeze Panes.

Type a function to add two cells

1. To add cells B2 and C2, type the following: =B2+C2, then hit the Enter key.

Format decimal places

1. Go to Format > Cells.
2. Change the number of decimal places using the arrows or by typing in the value.
3. Click OK.

Save workbook in a new folder

1. Go to File > Save As.
2. Click the Create New Folder button.
3. Type the name of the folder and click OK.
4. Click Save.