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

1. Microsoft Excel 2003 Basic 2. Microsoft Excel 2003 Intermediate 3.Microsoft Excel 2003 Advanced

Length: 
Course 1: 21 hours (7 weeks). Course 2: 24 hours (8 weeks). Course 3: 24 hours (8 weeks).
Location: 
Various approved locations throughout the United States.
Dates: 
1, 2, or 3: November 2005 - November 2010.
Instructional delivery format: 
Traditional classroom model
Learner Outcomes: 
Course 1: Define spreadsheet software; start and exit Excel 2003; view the Excel window; open, save, and close a workbook; enter labels and values in a worksheet; name and move a sheet; preview and print a worksheet; and get Help; plan and design a worksheet; edit, copy and move cell entries; enter formulas and create complex formulas; identify and use frequently used functions; copy formulas with relative and absolute cell references; format values; use fonts, font sizes, and change attributes and alignments; adjust column widths; insert and delete rows and columns; apply colors, patterns, and borders; use conditional formatting; and check spelling; plan, design, and create a chart; move and resize a chart; edit, format, and enhance a chart; annotate and draw on a chart; preview and print a chart; create a formula with several operators; use names in a formula and dates in calculations; generate multiple totals with AutoSum; use statistical functions; calculate payments with the PMT function; display and print formula contents. Course 2: Freeze columns and rows; insert and delete worksheets; consolidate data with 3-D references; hide and protect worksheet areas; save custom views of a worksheet; control page breaks and page numbering; create a hyperlink between Excel files; and save an Excel file as a web page; plan, record, edit and run a macro; use shortcut keys with macros, add a macro as a menu item, and create a toolbar for macros; use the Personal Macro Workbook; plan and create a list; add records with the data form; find and delete records; sort a list on one field or multiple fields; and print a list; use AutoFilter to retrieve records; create a custom filter, filter a list with Advanced Filter, and extract list data; create subtotals using grouping and outlines; look up values in a list; summarize list data; and use data validation for list entries; select a custom chart type; customize a data series; format a chart axis; add a data table to a chart; rotate charts and text; enhance a chart with WordArt; and add a picture to a chart; set up a shared workbook for multiple users and track revisions; apply and modify workbook passwords; create an interactive worksheet and a PivotTable list for the Web; add Web hyperlinks to an Excel file; work with XML data; and run Web queries to retrieve external data. Course 3: Define what-if analysis; track a what-if analysis with Scenario Manager and generate a scenario summary; project figures using a data table; create a two-input data table; use the Goal Seek feature to solve a what-if analysis; set up a complex what-if analysis with Solver; and run Solver and generate an Answer Report; plan, design, create, and update a PivotTable report; change the summary function, the structure and format of a PivotTable report; analyze three-dimensional data; create a PivotChart report; use the GETPIVOTDATA function; plan a data exchange; import a text file and database table into Excel; insert a graphic file in a worksheet; embed a worksheet; link a worksheet to another program; embed an Excel chart into a PowerPoint slide; import a list into an Access table; find files using Excel search tools; use Excel auditing feature to track errors and check worksheet logic; use Excel Outline command; control worksheet calculations; create custom AutoFill lists; customize Excel; add a comment to a cell; save a workbook as a template; view, analyze, and write VBA code; add a conditional statement to a procedure; prompt the user for data while a macro is running; debug a macro; create and run several macros into one main procedure.
Instruction: 
Course 1: Navigating Excel 2003; building and editing worksheets; formatting a worksheet; working with charts; working with formulas and functions. Course 2: Managing workbooks and preparing them for the Web; Automating worksheet tasks; using lists; analyzing list data; enhancing charts and worksheets; sharing Excel files and incorporating Web information. Course 3: Using what-if analysis; analyzing data with PivotTables; exchanging data with other programs; customizing and advanced worksheet management; programming with Excel.
Credit recommendation: 
Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (11/05). NOTE: Courses 1, 2, and 3 must all be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses.

Top