Use of spreadsheet software to demonstrate competencies in using formatting techniques, features and functions with hands-on experience; managing and auditing multiple worksheets and workbooks; working with formulas and functions; charting and graphic capabilities; developing lists and Pivot Tables; creating and using templates; collaborating with work groups; creating and editing macros; using data tables, scenario management and solver; importing and exporting data.