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:
Courses 1, 2, or 3: April 2005 - December 2005.
Instructional delivery format:
Traditional classroom model
Learner Outcomes:
Course 1: Define spreadsheet software; start and exit Excel 2002; 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; 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; 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; 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; print a list; use AutoFilter to retrieve records; create a custom filter, filter a list with Advanced Filter, extract list data; create subtotals using grouping and outlines; look up values in a list; summarize list data; 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; 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; 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; 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
Instruction:
Course 1: Navigating Excel 2002; 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 (4/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.
