We are using Agile Programming skills & Macros in Excel, We have face many problems and solution.
Today we can do it very quick our job in with full exprerince knowledge.
I have worked with Excel for over 12 years, and have built solutions for top-tier investment banks using complex spreadsheet systems
The Advanced Excel formulas used include Pivots, data tables, slicers, timelines, Reverse Vlookup, 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). we can create our own formulas as per requirment clients.
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.
VBA programming (macros) are used to connect Excel with MS Access, MS Outlook, company systems and others to minimize manual intervention.