Word: Students will be able to: explain text formatting; utilize the Revel Formatting task pane; modify, override, and export styles; format a document outline; view documents using the Document Map and thumbnails; create and format sections of text; insert section breaks, headers and footers, and page numbers; format text into multiple columns; align text in a table; merge and split table cells; change text orientation and resize rows; change table borders and apply shading to cells; sort data in a table, split a table, and enter a formula in a table; repeat a header row on multiple pages; apply and modify table styles; prepare and print labels and envelops; create a document from a template; save a template and store a custom template; utilize the Building Block Organizer; use the Restrict Formatting and Editing pane; create and modify a graphic; insert text boxes; insert and modify shapes; format text using WordArt, drop caps and pull quotes; track changes while editing; review and accept revisions; view changes by different reviewers; merge revisions and insert, print, and delete comments; preview and save a document as a Web page; open an HTML document in a browser; edit an HTML document in Word; insert a hyperlink in a document; navigate using hyperlinks. Excel: Students will be able to: switch between workbooks; copy a sheet from one workbook to another; create and manage linked workbooks; create a workspace; apply built-in and custom number formats; use functions to modify text; create, apply, and modify styles; apply and modify themes; merge and change cells; create outlines; group and organize data; consolidate data from different worksheets; create automatic subtotals to summarize data in a worksheet; use names to make formulas easier to understand; utilize the Name Manager; manage 3-D names; organize data using lists; sort and filter lists; use the Custom AutoFilter and Advanced Filter dialog boxes; create and format tables; save a workbook as a Web Page; add and remove hyperlinks in a worksheet; save a workbook as a PDF file; send a workbook via e-mail; work with and adjust the scale of a chart; format data points; create combination charts; add and format graphic elements to a chart; add a picture to a worksheet; utilize auditing features; add and edit comments; protect a workbook; share workbooks; merge workbooks and track changes; change default application settings; create invoices using built-in templates; create and manage custom templates. PowerPoint: Use the Slide Master to build a custom presentation; insert slides from other presentations; rearrange and delete slides; crop and modify images; add sound and movie clips; add narration to a presentation; format SmartArt graphics; create a custom table; create a photo album using digital photographs; add animation to a presentation; create a custom slide show; use the Presenter View feature; publish a presentation as a webpage; share a presentation.