STANDARD COMPETENCIES:

 

 I.      Working with cells

 II.     Edit, move, copy, delete cell contents

 III.    Work with AutoFill, AutoSum and AutoFormat features

 IV.     Locate and open existing workbooks, save, create folders, and use templates

 V.      Apply formatting to worksheets

 VI.     Insert and delete, hide and unhide, and freeze and unfreeze rows and columns

 VII.    Use Paste Function and formula palette

 VIII.   Use date and financial functions

 IX.     Hide, display, and customize toolbars

 X       Record, run, and edit macros

 TOPICAL OUTLINE:

 

 I.      Preparing and formatting a worksheet

 II.     Moving data within and between workbooks

 III.    Writing and inserting formulas

 IV.     Creating, deleting, and changing charts

 V.      Inserting clip art images

 VI.     Using templates

 VII.    Displaying and formatting data

 VIII.   Using single and multi-level sorts

 IX.     Using analysis tools

 X       Entering functions and working with lists

 XI.     Introducing macros