Microsoft Word: Students will be able to: create form letters using the mailing tab; create a recipient list; sort and filter records; use a recipient list to create mailing labels and envelopes; insert and modify new objects; apply background colors, fill effects, watermarks, and themes; protect document formatting; create forms by adding labels and content controls; protect forms; utilize the Compatibility Checker and Document Inspector; use digital signatures to share and secure documents; record and run macros to automate tasks; modify, copy, and delete macros; customize the Quick Access toolbar; customize keyboard shortcuts; create a master document; add cover pages; create, modify, and update a table of contents; create indexes, bibliographies, table of authorities, and footnotes; describe bookmarks and cross-references; add frames to Web page documents; create an XML document; attach an XML schema; use XML options and create a transform. Excel: Students will be able to: use logical functions to calculate values; apply math and statistical functions; calculate periodic payments; display and print formulas; use Excel functions to find values in a worksheet list; utilize the MATCH and INDEX functions to find values; create data tables; validate cell data; summarize list values; create a PivotTable; analyze and compare large amounts of data; apply styles and change PivotTable settings; create a PivotChart; export data from Excel to a text file; import data from a text file into an Excel workbook; import XML data into a workbook; export data from a workbook to an XML data file; use query features to import data from external databases; utilize the Goal Seek and Solver utilities; install and use the Analysis ToolPak; create scenarios to save input values; create views to save worksheet settings; create and run macros; edit a macro using the Visual Basic Editor; create custom functions; apply conditional formatting; insert and modify SmartArt. PowerPoint: Add, remove, and rearrange buttons on the Quick Access toolbar; create and apply a custom design theme; apply a custom template; modify presentations; modify images; add sound and movie clips; apply animation effects; create a photo album; format SmartArt graphics; make changes to objects; create and format a custom table; add interactive elements to a slide; add and modify actions buttons; create a custom slide show; review a presentation using comments; share a presentation; publish a presentation; create a presentation using a Word document; add content to slides by embedding or linking from Word or Excel; and create a hyperlink to a Word document or Excel spreadsheet.