Excel developer with a focus on the end user. Skilled at assembling, manipulating, analyzing and presenting data while ensuring the files are user friendly and exactly what is expected. Many times users are unaware of existing Excel functionality that would easily accomplish their data needs. Spreadsheets created for my current employer's diverse employee requests typically include formulas (protected or visible, simple and complex), validation, cell referencing, custom views, PivotTables, macros, change tracking, grouping and/or charts &...
Read More »
I enjoy transforming user's need for data into simple, easy to use, yet robust Excel spreadsheet files. Excel is so flexible and powerful that users are sometimes astonished at what works of art can be created to help them manage budgets and projects, store and share data and most anything else that involves data.
Previous (pre-elance) Major Accomplishments:
• designed Access database for nursing staff data collection and analysis specifically for continuing education research. Nurses were published in national journal. Cited in acknowledgments "for the development of the data collection tool".
• customized campaign data "walking lists" created for local city mayor's staff created by using voter data and arranging for campaigner's requested order of specified zip code, street and even/odd address patterns.
• recurring yearly interactive patient chart audit files generated to comply with audit requirement for numerous physician practices using imported mass amounts of qualifying data and random criteria to select records. Tablet and laptop nurse auditors used via corporate network to document audit findings. All of which was later imported to a master Access database for storage, retrieval and further analysis.
• replicated purchasing dept customized spend usage data Excel reports after system change and loss of report. Using four database table or SQL extractions and numerous Access queries, procurement data is analyzed against warehouse inventory values to...
Read More »