Excel Expert up to VBA : Compile and generate spreadsheets Research, update, and validate data underlying spreadsheet production Create pivot tables and modify spreadsheets to achieve analytical goals. Manage spreadsheets and maintain data Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables. Designed, recorded, and executed macros to automate data entry inputs. Formatted spreadsheets and workbooks for print, document reproduction, and presentations. Processed data load requests, manually entered data, reconciled data conflicts, and created data extracts and reports. Performed data manipulation, transformation, and cleansing. Cleaned old financial data and uploaded required data into new financial systems. Prepared source data for computer entry; compiled, sorted, and prioritized data. Completed routine database backups to safeguard and secure data. Compared data with source documents and re-entered data in verification format to detect errors