Excel expert has 4 years of experience in delivering projects in Reporting, Analytics, involving designing MS Excel dashboards, templates, intelligent spreadsheets, calculators and automating using VBA programs.
These dashboards uses advanced excel formulas, VBA macros, multiple goal seeks, linear optimization, drop downs, pivots, slicers, timelines, conditional formatting wherein the data flow logically from back-end via calculation sheet to summary sheet in a fully automated manner.
The advanced excel formulas used include Pivots, data tables, slicers, timelines, VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, OFFSET, COUNTIFS, SUMIFS, Nested IF, AND, OR, COUNTIFS( criteria range, {}), Array Formulas, TEXT Functions, TRANSPOSE, SUBTOTALS, DATE FUNCTIONS and others (formulas using named ranges, formulas created using VBA Functions)
VBA programming (macros) are used to connect Excel with MS Access, MS Outlook, SharePoint, company systems and others to minimize manual intervention.
Typically, these dashboard calculates, counts, tracks and depict various KPIs such as sales trend, price trend, gross margin, discounts, counts etc by various filters using visually appealing graphs and tables, compares budget v/s actual, provide download functionality to extract graphs and tables