Word: Students will be able to: format text; utilize the reveal formatting task pane; modify, override, and export styles; format a document outline; 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 envelopes; 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 diagram; 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; insert a hyperlink in a document; navigate using hyperlinks. Excel: Switch between workbooks; copy a sheet from one workbook to another; create 3-D formulas to link worksheets and add a watch window; 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 to 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; 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 invoices; create and modify PivotTables; create and display a PivotChart. PowerPoint: Modify a presentation using a template, use the Slide Master to make global changes; utilize transitions and timings; add speaker notes and set up a slide show for a speaker and a kiosk; proof and preview a presentation; print presentation, handouts, notes pages and outline; customize toolbar, Ribbon and themes; crop and modify images; add video and audio clips; apply animation effects; create a photo album using digital photographs. Labs Include: Word: Styles; breaks and page numbers; formatting tables; printing labels and envelopes; templates and passwords; process charts; managing document revisions; web features. Excel: 3-D Formulas and multiple worksheets and workbooks; formats, styles and functions; outlining and subtotals; cell and range names; autofilter; web and Internet features; advanced charting; documenting and auditing; templates and settings; creating PivotTables and PivotCharts. PowerPoint: Customizing presentations; running & printing presentations; customizing tool bars and themes; clip art, sound effects and animation.