Hi, I create creative and sophisticated financial, statistical and KPI modules in a simplified and logical manner. My Module in MS Excel analysis trends, performances, operating metrics, valuation methodology, and ratios based on chosen parameters. The reports show results per period, project, cost centre, person, working group and company levels. My modules allow filling information on forms (with drop-down list ) or pulling external databases, manipulating and merging the info in structured tables and populating results in build-in reports and forms. During the process, Excel validates the information and prepare graphical and visualisation reports and documents based on needed parameters and criteria.
I have considerable experience working with Excel, and I consider myself a guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts).