Fermé

Vba macro developer

Created Macros for Business Development.

Automating, modifying, and optimizing reports in Excel Access.

Experience in the development of financial applications using Excel and Access.

Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel Access 2007 / 2010.

Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, etc.

Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.

Experience in SQL statements, stored procedures using SQL server 2005/2008.

Experience in extracting, transforming and exporting data between different RDBMS and from flat file to Excel and vise-versa.

Used MS Excel/Access VBA SQL to send system generated e-mails, manage and report embedded Excel documents.

Created Dashboard in MS Excel.

Developed macros for accounting and financial purpose.

Built macros for updating customer orders in MS Excel Application.

Implemented several built-in excel functions and formulas.

Implemented pivot tables and charts in Excel for summarizing data.

Imported data into excel from flat files.

Developed and maintained Access Application for data retrieval. Previous method was taking Excel workbooks, translating to MS Access database, then exporting to SQL database.

Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Excel/Access/VBA.

Define reporting requirements and gather data, using Access and create management reports, also export data from MS access to MS Excel to create Pivot table for management do more analysis.

Created Access database from scratch.

Created physical tables and link tables.

Assist in Migrating prior versions of MS Office applications to 2010

Prepared program-level and user-level documentation.

Developed Excel based application to move / format data between sheets based on selection criteria using the Excel Object Model, VBA, Events Combo boxes.

Enhanced an existing Excel applications consisting of several VBA programs and macros.

Developed VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries and linked the based module to enable automatic updates for excel workbooks.

Created advanced formulas, user defined functions and formulaic arrays for data analysis.

Converted Excel formulas into VBA code including VLOOKUP HLOOKUP .

Performed testing, maintenance, debugging and documentation for every process.

Environment: Windows 7, MS Excel, VBA, MS Access, MS PowerPoint, SQL Server, Oracle, Test Cases, Oracle.

Assisted in the development of internal applications for marketing and customer relations departments.

Developed macros for financial reports.

Compétences : Microsoft Access, Excel, Visual Basic, SQL, Visual Basic pour les apps

en voir plus : excel multiuser vba access table, ole access table vba 2000, export word access vba macro, access database word document using vba macro, access 2007 vba macro save pdf file, vba macro add line table, access table google maps vba, access pdf files vba macro, access vba excel access table, excel table word table vba macro, import number access table vba, put excel values access table vba, transfer multiple sheets access table vba, vba excel access table, vba macro developer, vba code import excel data access table, vba macro developer jobs

Concernant l'employeur :
( 0 commentaires ) chennai, India

Nº du projet : #20877197

23 freelance font une offre moyenne de ₹21850 pour ce travail

periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(110 Commentaires)
6.2
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(63 Commentaires)
5.6
NoSonforhim

I am interested in your project. I am an Excel expert and have a great experience in excel automation with formulas and VBA since my first career 20 years ago. I assured that you will get high quality / high accuracy / Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(4 Commentaires)
2.3
Panggumsok

Hi, I am pleasure to edit excel document with sheet function and VBA. And I've made the VB program for simple task. Your require stimulates me. I think we can chat in detail.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(2 Commentaires)
2.1
elmorabit90

Hello, I read your offer and I can help you. With my vast experience and my knowledge of Excel and macros, I will be able to realize this project that meets your requirements. I'm Expert in Microsoft Excel, I have 4+ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(2 Commentaires)
1.3
alokes

Hi, I am a Software Professional developing software in MS Access with VBA for last 22 years. I would like to develop the database using MS Access as per your requirement and input provided by you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 10 jours
(2 Commentaires)
1.5
aryan2008shah

Dear sir , Have developed tools like generation of report to ppt and charts , also macro programming for generation of salary [login to view URL] 12 + yrs experience in VBA , .net , c# , mvc , sql server , access , postgres , Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 12 jours
(1 Évaluation)
0.4
sarahdh30

I am a passionate finance professional with 5 years of diversified experience in multidimensional and multicultural working environments, combining broad exposure in many aspects of Accounting and Financial Services, B Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
sanjyotsalgar

Hi, Giving a brief of the projects that will interest you that have been done in Excel automation. Some of the projects have recently completed are : 1. Farmguru (Agri Retail company) : Simple search based form develo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
dineshkumar0906

Being an expert in VB,VBA, Excel and MSAccess for the last 12 years. Also holding Microsoft certification in SQL Server having work experience in all third part controls of VB like Silver light controls, Sheridian DB G Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
Jim1276

I am a retired MBA with decades experience working with excel and VBA. I have both expertise and time...

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
dgonzalez12

Hi. I´m new to this site but I can help you with what you need. I have experience working with VBA, Access 2007 and SQL Server 2008. I would like to be part of your team.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
Sangha016

A VBA expert and a Senior Business Analyst for over 4 years. Urgently in need of money, hence ready to go turn in quality work in a short span of time.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)
0.0
balajidataanalys

I am a software professional, with experience in Developing Macros and i have created more than 50 Macros. i have more than 5 years of experience in Developing Macros.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 10 jours
(0 Commentaires)
0.0
ektamargaret94

I have 3 years of experience in SQL, Excel ,VBA macros.I aim to deliver efficiently within the fixed span of time.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 10 jours
(0 Commentaires)
0.0
yesubabu10203

Dear , This is Yesu ,I had 5 years of experience in VBA automation with excel ,outlook,word,power point and msoffice products of SQL,access I give you assurance of clearing your project by given timeline I can give Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
GKEvans

Hello, I have a 2:1 BEng in Software Engineering and I have 15 years experience with Excel macros and Access. I can also write in SQL which I learnt from my degree and also by becoming a CIW Web Development Profession Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 10 jours
(0 Commentaires)
0.0
divikwebscrapper

I have 7 yrs experience in Excel VBA macros and automation and also have experience in web scrapping and data extraction using VBA. will provide you the quality output. currently I am working as business analyst

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 5 jours
(0 Commentaires)
0.0
madhanbabu2010

I have more than 2 years of experience in excel macros and access database. I can create a proper data base and interface for the user.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 10 jours
(0 Commentaires)
0.0