Office Pro

Microsoft Word

2.2 Creating Documents

• Create a new blank document.
• Open a downloaded document and enable editing.
• Move the insertion point.
• Enter text into a document.
• Select words, lines, and paragraphs.
• Delete text.
• Copy and cut text to the Clipboard.
• Paste formatted and unformatted text from the Clipboard.
• Clear the Clipboard.
• Undo or redo an action.
• Close a document.
• Reorganize the content in a document.
• Paste text from a website into a Word document.

2.3 Managing and Printing Documents

• Modify document properties.
• View document statistics.
• Save a Word document in various formats, including PDF and plain text.
• Print a custom range of pages in a document.
• Print from a non-default printer.
• Collapse and pin the ribbon.
• Use ScreenTip help.
• Scroll through a document.
• Prepare a document to be uploaded to the Web.
• Prepare a document to be distributed within a company.

2.4 Modifying Fonts

• Bold, italicize, or underline a selection of text.
• Modify the case of a word.
• Change the font color of selected text.
• Apply a superscript.
• Apply a subscript.
• Change the font size of selected text.
• Change the font of selected text.
• Apply a Text Effect to selected text.
• Apply Text Highlighting to selected text.
• Format the fonts in a resume.
• Create a math worksheet.

2.5 Formatting Paragraphs

• Align a paragraph to the left, right, or center of the page.
• Show and hide formatting symbols.
• Clear formatting within a selection.
• Change the line spacing for paragraphs.
• Change the spacing before and after a paragraph.
• Change paragraph indents.
• Apply a border to a paragraph.
• Apply shading to a paragraph.
• Set orphan/widow paragraph control options.
• Create a numbered list.
• Create a bulleted list.
• Customize bullets.
• Adjust the indent level for lists.
• Format a series of lists in a document.

2.6 Formatting Pages

• Add a watermark to a page.
• Add a page border.
• Create and format multiple columns on a page.
• Insert and modify tab stops.
• Add dot leaders to tabs.
• Modify page margins.
• Modify page orientation.
• Insert a page break.
• Insert a column break.
• Align text vertically on a page.
• Format a report as a draft.
• Format only part of a document into two columns.
• Insert manual page breaks where needed in a document.

2.7 Editing Documents

• Find and replace a particular word within a document.
• Turn automatic spelling and grammar checking on and off.
• Use the spelling and grammar checker.
• Use the thesaurus to find synonyms.
• Count the total words in a document.
• Correct errors while typing with AutoCorrect.
• Customize AutoCorrect settings.
• Modify an AutoCorrect entry.
• Remove a hyperlink from text.
• Identify default AutoCorrect changes that might need to be modified.
• Ignore spelling and grammar suggestions when appropriate.

2.8 Inserting Illustrations and Other Elements

• Insert a picture from a file.
• Insert a picture from the Internet.
• Resize a picture or graphic.
• Move and align an image.
• Modify picture styles.
• Insert a symbol.
• Insert a shape.
• Insert the current date into a document.
• Delete a picture or graphic.
• Modify text wrap settings for visual appeal.

2.9 Creating and Formatting Tables

• Insert a blank table into a document.
• Add additional columns to an existing table.
• Add additional rows to an existing table.
• Modify cell alignment.
• Split or merge table cells.
• Format table cells.
• Convert a table to text.
• Enter or delete table data.
• Apply a table style.
• Resize table columns to fit contents.
• Center or align a table.
• Delete rows and columns.
• Format the header row and other table style options.
• Align table data for better readability.

2.10 Using Themes, Styles, and Templates

• Create a document from an existing template.
• Remove content controls in a template.
• Modify the theme font.
• Apply heading styles to paragraphs.
• Modify text formatting using Format Painter.
• Change the theme for a document.
• Select a style set for a document.
• Edit an existing style.

2.11 Managing References

• Insert a new citation source for a document.
• Edit a citation to add a page number.
• Insert a bibliography of current sources for a document.
• Insert a footnote at the bottom of the page.
• Insert an endnote.
• Modify the number format of footnotes.
• Edit a citation source.
• Convert a citation to static text.
• Import a citation source into the current document.
• Update a bibliography.
• Cite sources for an academic paper using the MLA, Chicago, and APA citation styles.

2.12 Managing Headers, Footers, and Sections

• Insert information into the header or footer, including date and time, page number, and filename.
• Suppress the page number on the first page of a document.
• Restart page numbering for a new section.
• Close the header and footer.
• Insert a Next Page section break.
• Format a section with a different page orientation.
• Begin numbering on a page other than the first.

Microsoft Excel

3.2 Creating and Managing Workbooks

• Open a workbook.
• Create a new blank workbook.
• Change workbook properties.
• Enable editing to exit the Protected View.
• Insert and delete worksheets.
• Navigate between worksheets.
• Save a workbook in Excel format, in a character-separated values format (both tabs and commas), and as a PDF file.
• Rename worksheets.
• Reorder and color worksheet tabs.
• Move and copy a worksheet.
• Import data from a comma-separated text file.
• Collapse and pin the ribbon.
• Import data from various applications into Excel.

3.3 Organizing and Entering Data

• Select a single cell and a range of cells.
• Enter worksheet titles.
• Enter column and row titles.
• Freeze column and row titles and panes.
• Enter text and numbers into cells.
• Use the Copy and Cut commands on cell ranges.
• Use paste options.
• Insert rows and columns into a sheet.
• Insert multiple rows in one operation.
• Delete and clear rows and columns.
• Hide and unhide rows and columns.
• Undo and redo actions.
• Manage a worksheet that contains a large data set.
• Insert new data between rows or columns.

3.4 Changing Properties and Printing Worksheets

• Lock and unlock cells.
• Protect worksheets and workbooks from changes.
• Preview and print a worksheet.
• Set and clear the print area for a worksheet.
• Change worksheet margins.
• Create and modify a worksheet header.
• Create a worksheet footer.
• Change worksheet orientation for printing.
• Scale a worksheet to be printed on a single page.
• Add print titles.
• Prevent particular cells from being modified.
• Print a particular section of worksheet data.
• Include relevant worksheet properties in a printout.
• Optimize the printing of a worksheet.

3.5 Formatting Cells

• Apply font style, size, and color changes to cells.
• Apply cell styles.
• Change the fill color (shading).
• Merge and center a range of cells.
• Apply number formatting to cells.
• Apply the percent style to cells.
• Increase and decrease decimal spaces.
• Enter and format dates.
• Adjust column widths (including AutoFit).
• Resolve the ###### error message.
• Adjust row heights.
• Align cell content.
• Rotate cell content.
• Clear cell formatting.
• Apply borders and border colors.
• Apply Word Wrap.
• Format cells as column or row totals.
• Adjust columns to display both numeric and textual data properly.
• Merge cells.

3.6 Entering Simple Formulas

• Enter a formula using the keyboard.
• Use the mouse to reference cells in a formula.
• Copy a formula using the fill handle.
• Copy a formula using the Clipboard.
• Sum a column or row using AutoSum.
• Use the MAX, MIN, AVERAGE, and MEDIAN functions.
• Use arithmetic operations properly in formulas.
• Add columns and rows of data.
• Copy formulas to cells that require similar calculations.
• Perform simple arithmetic that references cell values.
• Use AutoFill to enter data that follow a predictable pattern.

3.7 Using Advanced Functions

• Enter a function using the Insert Function box.
• Display and hide formulas.
• Enter a formula using absolute references.
• Enter a formula using relative references.
• Use the IF function.
• Use COUNTIF, SUMIF, and AVERAGEIF.
• Use functions with multiple arguments.
• Copy a formula with absolute references.
• Copy a formula with relative references.
• Correct or ignore error messages, as appropriate.
• Select appropriate functions to perform conditional operations.
• Determine when to use an absolute reference in a formula.
• Verify that the desired values have been properly referenced within a formula.

3.8 Analyzing Data in Charts

• Select a data source for a chart.
• Add a data series to an existing chart.
• Insert a clustered column chart.
• Create a pie chart.
• Move a chart on a worksheet.
• Move a chart to its own worksheet.
• Resize a chart.
• Modify a chart style and type.
• Format chart elements.
• Show and hide chart elements.
• Use recommended charts.
• Insert a chart to show changes over time.
• Insert a chart to display the aggregate of a set of values.
• Modify chart layouts to better visualize data.

3.9 Analyzing Data in Tables

• Create a table.
• Apply table styles.
• Insert table rows and columns.
• Add a total row.
• Sort a table.
• Remove duplicate rows.
• Filter a table using AutoFilter options.
• Apply highlight cell rules for conditional formatting.
• Apply data bars for conditional formatting.
• Determine when a data set should be converted to a table.
• Sort rows of data based on the values in particular columns.
• Use both text and number filters to display only desired information.
• Conditionally format cells that contain the most important data.

Microsoft PowerPoint

4.2 Creating and Managing Presentations

• Create a new blank presentation.
• Create a presentation using a template.
• Delete slides.
• Reorder slides.
• Duplicate slides.
• Save presentations in various formats.
• Copy and paste slides.
• Change presentation properties (e.g., author).
• Create new slides.
• Hide slides.
• Collapse and pin the ribbon.
• Add and remove sections in a presentation.
• Reorganize and modify an existing presentation.
• Organize a long presentation into relevant sections.

4.3 Formatting Textual Content

• Increase or decrease list levels.
• Modify a bulleted list style.
• Enter text into a placeholder.
• Add text to a shape.
• Change fonts and font styles.
• Change font colors and sizes.
• Align paragraph text.
• Change line spacing.
• Align text within a placeholder.
• Clear text formatting.
• Use Autofit to shrink text on overflow.
• Divide content into multiple slides.
• Use italics or a different font color to emphasize important content.

4.4 Designing Slides

• Change the presentation theme.
• Use theme variants.
• Apply font and color themes.
• Change the size of slides.
• Insert a fill or picture into the slide background.
• Modify background transparency.
• Insert a slide with a particular layout.
• Change slide layouts.
• Keep the design of slides consistent across an entire presentation.
• Select the slide size based on the delivery platform.
• Select themes, styles, and images that complement the presentation topic.

4.5 Using the Slide Master

• Insert a new slide master.
• Insert a new slide master layout.
• Modify text placeholders on a slide master.
• Insert a graphic into a slide master.
• Modify the font style in a slide master.
• Insert a placeholder.
• Delete a placeholder.
• Change the size of a placeholder.
• Copy and paste slide elements.
• Insert the slide number and date into slide footers.
• Determine when a new slide master or slide master layout is needed for a presentation.
• Modify an existing slide master layout to meet the needs of a presentation.
• Use slide master layouts to keep content consistent across slides.

4.6 Formatting Illustrations and Tables

• Insert a table.
• Modify table layouts and design.
• Apply Quick Styles to drawing objects.
• Apply fill colors to drawing objects.
• Align and distribute objects.
• Add SmartArt diagrams.
• Convert a bulleted list into a SmartArt diagram.
• Change the stacking order of selected objects.
• Add WordArt to a new placeholder.
• Insert a shape.
• Select and modify SmartArt to graphically represent processes and organizational structures.
• Maintain a style for graphics that is consistent with the overall theme of a presentation.
• Use WordArt without detracting from the professionalism of a presentation.

4.7 Formatting Pictures and Other Media

• Add pictures within content placeholders.
• Use the Picture Styles gallery.
• Change the size of images.
• Change the shape of a picture (e.g. crop option).
• Format picture borders.
• Insert videos.
• Adjust video brightness and contrast.
• Add video playback options.
• Resize a video.
• Add online pictures (i.e. clip art).
• Insert an audio file.
• Add a hyperlink to text.
• Incorporate high quality and relevant images into a presentation.
• Format images to match the overall theme of a presentation.
• Adjust the timing and visual quality of videos.

4.8 Applying Animations and Transitions

• Apply animation effects (entrance, exit, and emphasis).
• Modify the start timing of animations.
• Change the sequence of animations.
• Customize the direction of animations.
• Preview and test animations.
• Apply slide transitions.
• Modify the duration and timing of transitions.
• Test transitions.
• Adjust the timing of animations to match the flow of a presentation.

4.9 Delivering Presentations

• Check the spelling in presentations.
• Use the thesaurus pane.
• Add speaker notes to a presentation.
• Deliver a slide show presentation.
• Navigate a slide show in Presenter View.
• Use presentation tools.
• Preview and print handouts.
• Print speaker notes.
• Add headers and footers to notes and handouts.
• Format and print handouts to help the audience retain important information.

‍