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; use object linking and embedding; apply background colors, fill effects, watermarks, and themes; record, run, modify, copy and delete macros; 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; customize the Ribbon; customize the Quick Access toolbar; customize keyboard shortcuts; create a master document; add cover pages; create, modify, and update a table of contents and table of figures; create indexes, bibliographies, table of authorities, and footnotes; work with 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: Use logical functions to calculate values; use nested functions and ROUND function; apply math and statistical functions; use PMT function to calculate periodic payments; use date and time functions to calculate duration; use array formulas to perform multiple calculations on multiple sets of values; 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; 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 and run macros; edit a macro using the Visual Basic Editor; create custom functions; PowerPoint: Format SmartArt graphics; create and format a custom table; customize a chart; add interactive elements to a slide; add and modify actions buttons; create a custom slide show; use the Equation tool to create a mathematical formula; review a presentation using comments; share a presentation; broadcast a presentation; create a presentation using a Word outline; add content to slides by embedding or linking from Word or Excel; create a hyperlink to a Word document or Excel spreadsheet. Labs Include: Word: Mail merge; themes and linked objects; macros; forms; toolbar and keyboard customization; table of contents; XML features. Excel: Advanced functions; lookups and data tables; advanced table management; exporting and importing; goal seeker and solver; macros and custom functions. PowerPoint: create and customize Smart Art graphics; custom presentation options; action buttons; custom slide shows; distributing a presentation; integrating Microsoft Office files.