STANDARD COMPETENCIES:

 

 I.      Apply basic spreadsheet skills to the accounting task of: (I)

         A.      payroll

         B.      depreciation schedules

         C.      accounts receivable aging

         D.      inventory data and evaluation

         E.      interest calculations and payment schedules

         F.      fixed and variable cost analysis

         G.      cost, volume and pricing strategies

         H.      capital budgeting analysis.

 II.     Create and copy formulas. (IV)

 III.    Create standard financial statements using a spreadsheet. (I)

 IV.     Use descriptive accounting and financial functions. (IV)

 V.      Use large worksheet and multi-page worksheets for multiple period or multi-part analysis. (II)

 VI.     Create charts and graphs to analyze and illustrate business data. (III)

 VII.    Setup variables and formulas for what-if analysis of business data. (IV)

 VIII.   Troubleshoot spreadsheet problems. (V)

 TOPICAL OUTLINE:

 

 I.      Spreadsheet Application for Accounting

 II.     Worksheets

 III.    Charts and graphs

 IV.     Variables, Functions and Formulas

 V.      Problem-solving