Excel Expert with success in maintaining and organizing data, including dictionaries, and cross-reference indexes across a broad range of industries. Skilled in excel 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.
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.