• Wrote Excel VBA macros to identify common customers in old and new computer systems. • Wrote VBScripts to delete or modify data in legacy system. • Prepared spreadsheets of legacy system output for upload into new system. • Created Customer Creation Form spreadsheet using advanced Excel features. • Financial Calendar: automatically displays holidays and important business dates. • Employee Hours Journal: programmatically converts time data into pivot tables and charts.