Standard

R State Standard £ Developed College:

ACC 160 – Advanced Spreadsheet

Course Description:

Provide the fundamental, intermediate and advanced Microsoft Excel competencies to provide user with the skills necessary to obtain the expert user certification. Topics include spreadsheet creation, financial statements, forecast, amortization schedules, workgroup editing and advanced features such as macros, using charts, importing and exporting data, HTML creation, formulas, Web queries, built-in function, templates, and trends and relationships.

Competency Areas:	Hours:
Importing and exporting data	Class	4
Use templates	D. Lab	2
Use multiple workbooks	P. Lab/O.B.I.	0
Formatting numbers	Credit	5
Work with named ranges
Collaborating with workgroups
Using macros and analysis tools
Printing workbooks and using toolbars
Auditing a worksheet

Prerequisite: ACC 106

Corequisite:

Course Guide

Competency	After completing this section, the student will:	Hours
		Class	D. Lab	P. Lab/
				O.B.I.
IMPORTING AND EXPORTING DATA		4	1	0
	Export to other applications Import data from text files (insert, drag and drop).
	Import from other applications.
	Import a table from an HTML file (insert, drag and drop - including HTML round tripping).
USE TEMPLATES		2	1	0
	Apply templates.
	Edit templates.
	Create templates.
USE MULTIPLE WORKBOOKS		2	1	0
	Using a workspace.
	Link workbooks.
FORMATTING NUMBERS		4	2	0
	Apply number formats (accounting, currency, number).
	Create custom number formats.
	Use conditional formatting.
PRINTING WORKBOOKS AND USING TOOLBARS		6	2	0
	Print and preview multiple worksheets.
	Use the Report Manager.
	Hide and display toolbars.
	Customize a toolbar.
	Assign a macro to a command button.
WORKING WITH NAMED RANGES		6	3	0
	Add and delete a named range.
	Use a named range in a formula.
	Use Lookup Functions (Hlookup or Vlookup).
COLLABORATING WITH WORKGROUPS		4	2	0
	Create, edit and remove a comment.
	Apply and remove worksheet and workbook protection.
	Change workbook properties.
	Apply and remove file passwords.
	Track changes (highlight, accept, and reject).
	Create a shared workbook.
	Merge workbooks
USING MACROS AND ANALYSIS TOOLS		8	4	0
	Record, run and edit macros.
	Use PivotTable auto format.
	Use Goal Seek.
	Create pivot chart reports.
	Work with Scenarios.
	Use Solver.
	Use data analysis and PivotTables.
	Create interactive PivotTables for the Web.
	Add fields to a PivotTable using the Web browser.
AUDITING A WORKSHEET		4	4	0
	Work with the Auditing Toolbar.
	Trace errors (find and fix errors).