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.