Expert level Google Spreadsheets user. Two years experience designing sheet based tools and systems, one plus year experience incorporating complex Google Scripts to allow for more sophisticated features. Expert in the use of high level, complex, and often novel formulas. Google Spreadsheets and Scripts experience: 1) Automatic Mail Merge: Created a Mail Merge system tailored to the specific needs of my former company - designed to dynamically populate and automatically deploy hundreds of template based emails at once, attaching files from standardized Google Drive folder paths as needed, automatically updating a Status tracker, intuitively building HTML for more complex email structures, and preventing errors by recognizing and documenting predicted problems. 2) Client Index: Assembled an index of all client data in a single location by combining standardization mechanisms and programmatically ascertained fields. This index was imported into the background of every subsequent sheet used by the company to allow for rapid, accurate, and seamless data integration. 3) Client Status Document: Developed the governing procedural document for the company. Through a combination of data validation, complex spreadsheet functions, and Google's built-in Scripting service, the document was able to easily incorporate any pertinent client data into the process, generate timestamps on status changes to track efficiency and allow for the use of formatting based warnings for inefficiency, and display sophisticated procedural statistics. High level Microsoft Excel user. Experience using MS Excel in migrating hundreds of thousands of rows of contact data to a new CRM.