Gained extensive experience in MIS reports on various scenarios. Database management using Advance Excel - Macros, Advance Filter, Functions & Formulas, Pivot table, Goal Seek, Importing & exporting data, validations, Develop Excel Templates.
Skill to an advanced Excel functions which able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion that brings faster and accurate reports
Maintain constant communication with internal departments - keeping track on various correspondences and office communications to ensure smooth office operations. Proficient in MS Office Suite (Excellent knowledge of Excel (Pivot tables, formulas, macros, conditional formatting, Data validation, V / H lookup, Developer, etc.).Develop financial models to support valuation, planning, and forecasting
Ability to create auto updating Dashboard reports allow managers to get high-level overview of the business. dashboards is power method that can provide analysis, insight and alert managers in timely manner.
Create auto generate visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers.A chart is a powerful tool that allows you to visually display data in a variety of different chart formats.