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 - Intermediate (247)*

40 hours (5 weeks).
Various approved locations throughout the United States.

December 2008 - December 2018.

Instructional delivery format: 
Traditional classroom model
Learner Outcomes: 

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.


Word: Major topics include: styles; sections and columns; formatting tables; printing labels and envelopes; templates and building blocks; graphics; managing document revisions; web features. Excel: Multiple worksheets and workbooks; advanced formatting; totaling and subtotals; cell and range names; lists and tables; web and Internet features; advanced charting; documenting and auditing; templates and settings. PowerPoint: Customizing presentations; graphics, movies, and sound effects; customizing graphics and tables; photo albums and animation; delivery options.

Credit recommendation: 
In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications (12/08) (5/14 Administrative Review). NOTE: Microsoft Office Trilogy - Basic (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.