Rss Coordinator (Contract/Temporary)
Contract extended twice. Tasks included learning internal CRM such as CloudCME & Northwestern Qualtrics to migrate, maintain or update data between or within CRMs including new data entry; auditing internal records for required industry compliance, engaging dozens of staff building relationships regarding necessary workflow adjustments. Microsoft Office 365 proficiency utilized including advanced level Excel formulas working with data, mail merge, and document format/creation promoted drastically reduced completion times vs. manager expectations. Some examples of excel formulas used in projects to reduce completion times: =TEXTSPLIT(A4,"%")=TEXTJOIN("; ", TRUE,A21:B82)=TEXTJOIN(("; ", TRUE,E2:E800)=IF(A251="Excellent",A251,IF(A251="Very Good",A251,IF(A251="Satisfactory",A251,IF(A251="Fair",A251))))=IF(A1="Excellent",A1,IF(A1="Very Good",A1,IF(A1="Satisfactory",A1,IF(A1="Fair",A1,))))=IF(A251="Excellent",A252,IF(A251="Very Good",C251,IF(A251="Satisfactory",C251,IF(A251="Fair",C251))))=IF(A1="Excellent",A2,IF(A1="Very Good",C1,IF(A1="Satisfactory",C1,IF(A1="Fair",C1,))))=IFERROR(TEXTSPLIT(A3," - "),"")