Banner Image

Skills

  • Macro
  • Data Extraction
  • Estimate
  • Excel Advanced Formulas
  • Excel Analyst
  • Excel Automation
  • Excel Training
  • Format & Layout
  • Formula
  • Microsoft
  • Pivot Table
  • Power Query
  • Project Management
  • Reports
  • Risk Analysis

Sign up or Log in to see more.

Services

  • Data Analyst - Excel and VBA

    $10/hr Starting at $25 Ongoing

    Dedicated Resource

    I am IT professional, Well versed with Excel dashboards, data analysis, reporting. Trained many professionals in corporate sector on Advance excel concepts like pivot, vlookup, conditional formatting,data...

    Data ExtractionEstimateExcel Advanced FormulasExcel AnalystExcel Automation

About

EXCEL, VBA, macro,Excel Automation

My Name is Jyoti. Motivated achiever with 18 years of significant, progressive experience in IT Industry. Worked with Canadian Comp. CGI.ltd as a Project Manager. Managed Projects of UK, USA, CANADA, and AUSTRALIA based Client.

My expertise:
 Excel Data Analysis
 Bulky and Multiple File Processing with VBA Script
 Automation of existing or new System using Excel VBA/ Macro Script
 Dynamic Dashboards, Charts
 Data Conversion
 Advance Excel Trainer

Of course, I can help with complicated formula, conditional formatting rule, drop-down lists, Pivot table, macro, Power Query, Power Pivot, MS-Access Database, and Forms. I can troubleshoot any Excel file, fixing issues like broken formulas, heavy file size, locked sheets, buggy or slow VBA code.
Key highlights about my Project:
 Delivering cost effective and 100% quality product to the client
 On time delivering Project
 Through Testing with different scenarios of data
 I provide free support to clients to train them initially as well free support for any issues with my work.
 I document and clarify all project requirements and Testing scenarios with clients before starting the project. These documents can be used by clients for quick reference.
 Quick Responsive to client’s queries.

Pls check various same type of projects executed on freelancer site.
1. Sales Analysis reports - Done for the fashion beachwear shops. Based on the sales data of the different shops,pivot reports are updated as well user can get idea of sale base on the reorder quantity. This is done with the VBA macro and pivot report.
Check the video :
https://photos.app.goo.gl/yPBD2hAckxBywLRw5


2. Generated Dynamic Dashboard for the Europe based factory,where user can edit data which is reflected automatically on the chart.This is done with the VBA macro.

https://photos.app.goo.gl/pDEgh47xrLWfsNEu8

3. Billing - Generating Invoice for each Customer in PDF file and generating CSV file based on the data updated on control panel.
https://photos.app.goo.gl/dwkTXgYimP86NAyr9

4. Timesheet generation: Generating the various timesheets for different companies as per their requirements. This is done with VBA Macro.


I believe in maintaining long term project relationship with Clients. Hope to get positive response from your end.

Work Terms

20-30 Hours in a Week.EXCEL and VBA EXCEL

Attachments (Click to Preview)