I will build complex excel vba based macro and functions

Experience profession having 6+ years of experience in Data handling, Data Manipulation, Data Validation and Data Analytics.

I will help in automating day-to-day tasks using the following excel based functions:

• Conditional and Loop statements
• Append data from different worksheets
• Append data from different workbooks when source workbook names are known
• Append data from different workbooks when source workbook names are unknown
• User Forms
• User Defined Functions
• Passing values by Val & by Ref
• Error Handling
• Arrays
• Addins
• Charts & Pivot Tables
• Connecting to external datasources/ADO objects
• Addins
• Data Analytics using Pivot Tables
• Alternatives of Pivot Tables (Sumif (s), Countif (s) etc. )
• Consolidating Worksheets (using Vlookup, Index, Offset etc. )
• Charts (Simple charts, pie charts, curve fitting and distributions)
• Dashboards