Advanced knowledge of Microsoft Excel required including the ability to import, clean and reformat data from various sources; use advanced formulas to create relational connections, apply business rules and perform calculations; create pivot tables, graphscharts, dashboards and professional summaries