Skip to main content

National College Credit Recommendation Service

Board of Regents  |  University of the State of New York

EdTech Institute, LLC (formerly The Sage Group, LLC) | Evaluated Learning Experience

Microsoft Office Trilogy - Advanced (248)*

Location: 
Various approved locations throughout the United States.
Length: 
40 hours (5 weeks).
Dates: 
December 2008 - June 2013.
Instructional delivery format: 
Traditional classroom model
Learner Outcomes: 
Word: 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: 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; create a hyperlink to a Word document or Excel spreadsheet.
Instruction: 
Word: Mail merge; objects and backgrounds; forms; macros; toolbar and keyboard customization; long documents; XML features. Excel: Advanced functions; lookups and data tables; advanced table management; pivot tables and pivot chart; exporting and importing; analytical options; macros and custom functions; conditional formatting and SmartArt. PowerPoint: custom presentation options; graphic and multimedia content; customizing SmartArt; action buttons; custom slide shows; distributing a presentation; integrating Microsoft Office files.
Credit recommendation: 
In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications (12/08). NOTE: Microsoft Office Trilogy (052), Microsoft Office Trilogy - Intermediate (247), and Microsoft Office Trilogy - Advanced (248) are sequential and when taken consecutively are comparable to a 3 semester hour course in Computer Software Applications. *NOTE: Course numbers on transcripts may reflect different prefixes depending upon where a course is offered.

Top