Hi, I am a financial expert and guru in Excel and 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.
I also have an experience in accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, bank reconciliation and financial reports.
With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, S-Curve, correlation, and regression, etc.). The financial models incorporate complex components of business in a simplified and logical manner.