Length:
Course 1: 20 hours (2.5 weeks). Course 2: 20 hours (2.5 weeks). Course 3: 20 hours (2.5 weeks).
Location:
Various approved locations throughout the United States.
Dates:
Courses 1, 2, or 3: December 2009 - June 2014.
Instructional delivery format:
Traditional classroom model
Learner Outcomes:
Course 1: Identify Excel spreadsheet components; recognize the main components of an Excel window; utilize the Excel Help feature; open and navigate Excel workbooks; enter text values in an Excel spreadsheet; edit formulas in an Excel spreadsheet; insert and work with pictures; update and save a workbook; move and copy data and formulas in a worksheet; use absolute formulas in a worksheet; insert and delete worksheet ranges, rows, and columns; enter functions in Excel; insert SUM and AutoSum functions; explain additional functions available in Excel; format text to create different fonts, sizes, and styles; adjust columns, rows, and alignment; format values as currency, percentages, or numbers; apply conditional formats; copy formats, use styles and table styles to apply formats; format a worksheet for printing; preview how a worksheet will look when printed; control print options such as page orientation; print Excel worksheets; create charts based on worksheet data; move charts within a workbook; change chart types and format chart elements; move and resize embedded charts; print charts; manage large Excel workbooks; split a worksheet; use the Freeze Pane command; set print titles and page breaks; manage and print multiple worksheets. Course 2: 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. Course 3: 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.
Instruction:
Course 1: Basic spreadsheet calculation knowledge and skills; excel spreadsheet components; Excel workbook navigation; calculating formulas in a worksheet; inserting and deleting worksheet ranges, rows, and columns; formatting values as currency, percentages, or numbers; applying conditional formats; creating charts based on worksheet data; managing large Excel workbooks; managing and printing multiple worksheets. Course 2: Switching between Excel workbooks; creating and managing linked workbooks; applying built-in and custom number formats; using functions to modify text; merging and changing cells; grouping and organizing data; consolidating data from different worksheets; creating automatic subtotals to summarize data in a worksheet; using names to make formulas easier to understand; organizing data using lists; creating and format tables; saving a workbook as a Web Page; adding and removing hyperlinks in a worksheet; saving a workbook as a PDF file; formatting data points; utilizing auditing features; protecting a workbook; sharing workbooks; merging workbooks and track changes; creating and manage custom templates. Course 3: Logical functions; statistical functions; periodic payments; Excel advanced formulas; Excel functions; data tables; cell data; list values; PivotTables and PivotCharts; analyzing and comparing large amounts of data; applying styles and changing PivotTable settings; importing and exporting data; using query features to import data from external databases; installing and using the Analysis ToolPak; create scenarios to save input values; creating, editing and running macros; custom functions; conditional formatting; inserting and modifying SmartArt; XML schema systems.
Credit recommendation:
Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (12/09). 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.
