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 Excel - Basic (297)

Formerly Microsoft Excel 2010 Basic (297) Microsoft Office Excel - Intermediate (301) (Formerly Microsoft Excel 2010 Intermediate (301) Microsoft Office Excel - Advanced (305)
Location: 
Various approved locations throughout the United States.
Length: 
Course 1: 18 hours (6 weeks) Course 2: 18 hours (6 weeks) Course 3: 18 hours (6 weeks)
Dates: 

Course 1, 2, and 3: January 2013 - December 2018.

Instructional delivery format: 
Traditional classroom model
Learner Outcomes: 

Course 1: Students will be able to: start Microsoft Excel, identify the components of the Excel interface, open an Excel workbook, use the Help window, and navigate worksheets; enter and edit text, values, and formulas; manipulate pictures; and save and update a workbook; move and copy data and formulas; use relative and absolute references; and insert and delete ranges, rows, and columns; use the SUM, AutoSum, AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations; create and apply text and conditional formatting; customize cells, rows, and columns; format values and numbers; copy and apply cell and table styles and formatting, and sort data; check spelling, find and replace text and data, preview and print, and format page layout; create, format, modify, and customize chart types and styles; freeze panes and split a worksheet; manipulate content, hide and unhide, set print titles, page breaks, and headers on a worksheet; and manage multiple worksheets; use graphics as conditional formatting for data; and insert and modify SmartArt graphics and screenshots. Course 2: Students will be able to: link worksheets by using 3-D formulas; add a Watch window; create and manage links between workbooks; and create a workspace; apply special and custom number formats; control the display of zero values; use functions to format text; create, apply, and modify styles; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations, and add a background color and a watermark; create an outline and consolidate data; create subtotals in a list; use multiple subtotal functions; and create custom views to save different sets of worksheet display and print settings; define and apply cell and range names; use names in formulas; and define and apply 3-D names; sort data by columns; filter data based on complex criteria and copy filtered results to another range; create, format, and name a table, and add rows and columns; and use structured references; save and publish a worksheet as a Web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an e-mail attachment; format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects, shapes, and images; use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final; change Excel's default application settings and customize the Ribbon; work with Excel templates; and create and manage templates; create a PivotTable for analyzing and comparing large amounts of data; modify the PivotTable view by using slicers to filter data and by rearranging fields; improve the appearance of a PivotTable by changing its field settings and applying a style; and create a PivotChart to graphically display data from a PivotTable. Course 3: Students will be able to: use the IF and SUMIF functions to calculate a value based on specified criteria; use a nested IF function to evaluate complex conditions; and use the ROUND function to round off numbers; use the PMT function to calculate periodic payments for a loan; use Date and Time function to calculate duration in years, months, and days or time; display, print, and hide formulas; create array formulas to perform multiple calculations on multiple sets of data at one time; and change calculation options and iteration limits; use the VLOOKUP and HLOOKUP functions to find values in worksheet data; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position in a range; and use data tables to project values; use the Data Validation feature to validate data entered in cells; and use database functions to summarize data values that meet criteria you specify; export data from Excel to other formats, and import data from a text file into an Excel workbook; import XML data into a workbook, and export data from a workbook to an XML data file; and use Microsoft Query and the Web query feature to import data from external databases; Use the Goal Seek and Solver utilities to meet a target output for a formula by adjusting the values in the input cells; use the Analysis ToolPak to perform statistical analysis; and create scenarios to save various sets of input values that produce different results; Run a macro to perform tasks automatically; recorded macros; assign a macro to a command button and a button in the worksheet; use a button to run the macro; create an Auto-Open macro; edit a macro by editing VBA code; and create a custom function to perform calculations when built-in functions are not available.

Instruction: 

Course 1, 2, and 3: The Microsoft Office Excel - Introduction, Intermediate and Advanced courses are designed for participants to enhance their computer applications skills. Each course covers the various level functions and features of Microsoft Office Excel. Instruction is offered in a traditional classroom format with instructor led demonstrations, hands-on practical exercises, individual assignments and final examinations.

Credit recommendation: 

Course 1: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications or Microsoft Office Excel - Introductory (1/13) (5/14 Administrative Review). Course 2: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications or Microsoft Office Excel - Intermediate (1/13) (5/14 Administrative Review ). Course 3: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications or Microsoft Office Excel - Advanced (1/13) (5/14 Administrative Review).

Top