Vivek Chaturvedi

Financial Analyst @Invact Metaversity

In my role at Invact Metaversity, I create financial models by using advanced Excel formulas like Pivot, Vlookup, Xlookup, Hlookup, data validation, countifs, sumifs, and other financial structures like depreciation, capital loans, P&L sheet, balance sheet, NPV, IRR, profitability ratios, market ratios, and other financial structures.I applied a variety of financial structures, including capital loans, investment decisions, inventory handling, and asset management, ensuring accurate financial analysis.My responsibilities also included data cleaning and visualization, as well as developing detailed reports and dashboards using advanced Excel formulas.I leveraged spreadsheet tools for budgeting, forecasting, and variance analysis, which were critical in maintaining optimal financial management.One of my key achievements was creating user-friendly dashboards to identify critical business areas, contributing to improved profit margins and enhanced overall business performance.