Excel Expert Resume Examples

Excel Expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad range of industries. Skilled in VLOOKUP formula development, Pivot Table generation, and Pivot reporting. Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain quality control benchmarks.

• Compile and generate spreadsheets capturing key data related to company’s active contracts.
• Research, update, and validate data underlying spreadsheet production; strategically fill gaps.
• Create pivot tables and modify spreadsheets to achieve analytical goals.
• Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers.
• Develop and implemented standard operating procedures to bridge data gaps and resolve related issues.

• 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.

• Collected, organized, and documented infrastructure project attributes, data, and project metrics.
• Processed data load requests, manually entered data, reconciled data conflicts, and created data extracts and reports.
• Performed data manipulation, transformation, and cleansing.
• Prepared routine and ad hoc status reports.