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.

Fähigkeiten: Microsoft Access, Excel, Visual Basic, SQL, Visual Basic für Apps

Mehr darüber 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

Über den Arbeitgeber:
( 0 Bewertungen ) chennai, India

Projekt-ID: #20877197

22 Freelancer bieten im Durchschnitt ₹21707 für diesen Job


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.

₹25000 INR in 7 Tagen
(113 Bewertungen)

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 Mehr

₹12500 INR in 3 Tagen
(63 Bewertungen)

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.

₹15000 INR in 10 Tagen
(5 Bewertungen)

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 / Mehr

₹25000 INR in 7 Tagen
(4 Bewertungen)

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+ Mehr

₹12500 INR in 7 Tagen
(2 Bewertungen)

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 , Mehr

₹35000 INR in 12 Tagen
(1 Bewertung)

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 Mehr

₹25000 INR in 7 Tagen
(0 Bewertungen)

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 Mehr

₹25000 INR in 7 Tagen
(0 Bewertungen)

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 Mehr

₹25000 INR in 7 Tagen
(0 Bewertungen)

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

₹25000 INR in 7 Tagen
(0 Bewertungen)

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.

₹12500 INR in 7 Tagen
(0 Bewertungen)

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.

₹25000 INR in 10 Tagen
(0 Bewertungen)

Hi, I am Expert in Excel Vba . I can make a workbook's user interface just like a desktop application with graphics, which will be more convenient for a user to access his/her data. I am new in this Freelancer online Mehr

₹22222 INR in 10 Tagen
(0 Bewertungen)

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.

₹16666 INR in 2 Tagen
(0 Bewertungen)

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

₹12500 INR in 10 Tagen
(0 Bewertungen)

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 Mehr

₹16666 INR in 7 Tagen
(0 Bewertungen)

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 Mehr

₹22000 INR in 7 Tagen
(0 Bewertungen)
₹27777 INR in 10 Tagen
(0 Bewertungen)

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

₹22222 INR in 5 Tagen
(0 Bewertungen)

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.

₹25000 INR in 10 Tagen
(0 Bewertungen)