Standard

ACC 160 – Advanced Accounting Spreadsheet Applications

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/Corequisite:  ACC 106

 

 

 
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).

 

 

 

 

Trace precedents (find cells referred to in a specific formula).

 

 

 

 

Trace dependents (find formulas that refer to a specific cell).

 

 

 

 

Suggested Resources

 

Books:

 

New Perspectives on Microsoft Excel 2000 - Comprehensive Enhanced, Parsons, Oja, & Ageloff, Course Technology, 2000.

MOUS Essentials:  Excel 2000 with CD,  Fox & Metzelaar, Prentice Hall, 2000.

Microsoft Excel 2000.  Parsons, June J., Dan Oja, and Beverly Zimmerman.  Cambridge, MA.  Course Technology, 2000.

Microsoft Excel 2000 Core and Expert Certification, Rutkosky. St. Paul: EMC Paradigm, Benchmark Series.

Excel Spreadsheet Applications for Accounting Principles, South Western Publishing.

Learning Accounting App w/Excel-Singleton, 2000 ed.

Excel 2000 Advanced, P. Koneman, Prentice Hall.