I have around 16 years of experience in software development and management. I have worked extensively on Microsoft Excel, automating processes using VBA, and performing data analysis/management for various organizations. I have specialization in the following areas:
• Building Advanced Excel Spreadsheets & Dashboard Reports.
• Data Cleansing, Analysis, Reconciliation of Complex & Large Data Sets
• Management & Performance Reporting
• Graph, Charts, Tables, Pivot Tables And Pivot Charts Generation
• Automation Of Spreadsheet Reports Using Advanced Functions
• Expert In Vlookup, Hlookup, If, And, Or, Index/Match, Sumif(S),
• Countif(S), Trim, Len, Concatenate, Mid Etc
• Data Validation,Conditional Formatting,Consolidation
• Vba (Excel Macros)
• Financial Reporting In Excel
• Google Spreadsheet Reporting
• Data Extraction From Website To Excel
• VBA based Excel Applications
• Data Visualization
• Visio - Diagrams
• Microsoft Project Plan - Handling multiple prjs in one MPP