Marty L.

Successful and competent Excel / VBA Guru/freelancer Skill sets: 1. Creating / developing informational databases 2. Create ad-hoc reports as required from existing excel data, files 3. Creating / developing spreadsheets (simple to complex) 4. Customizing existing spreadsheets to be more robust, automated, and less labor intense a. Use visual basic to write macros as needed b. Data is automatically linked to other worksheets where applicable 5. Automate Data Inputting using other Excel or CSV files a. Make use of OPEN FILENAME macro to access data to input b. Make use of drop downs, checkboxes, etc. 6. Providing complex data manipulations / data summaries / dashboards & metrics 7. Use advanced formulas (SUMIFS, COUNTIFS,SUMPRODUCT), Defined Names, Dynamic Data Range updates using OFFSET, automated emailing 8. Pivot Tables 9. Creating templates, automated input sheets, and data transfers as needed 10. Creating professional presentations / training materials / process flow charts