I will build complex excel vba based macro and functions

5.0
5.0

India

I speak English, Hindi

32 orders completed

Corporate Finance Professional

Start-up fund raising, Corporate Finance and Project Financing professional, having 10+ years of experience with Ernst & Young, corporate house and private equities. I can help a new age start-ups ...
About this Gig

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

Platform:

Excel

Google Sheets

Development technology:

VBA

Python

RStudio

Expertise:

Formatting

Fixing

Forms

Pivot tables

Formulas

My Portfolio

Reviews

1 reviews for this Gig
5.0

(1)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Recommend to a friend
    5
  • Service as described
    5
Sort By
Most relevant
  • V
    image-docs

    vipinvince

    IN

    India

    5

    Pretty easy going

    Helpful?
    Yes
    No
Reviews

1 reviews for this Gig
5.0

(1)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Recommend to a friend
    5
  • Service as described
    5
Sort By
Most relevant
  • V
    image-docs

    vipinvince

    IN

    India

    5

    Pretty easy going

    Helpful?
    Yes
    No