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.
23 freelancere byder i gennemsnit ₹21850 på dette 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.
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.
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.
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.
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.
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.
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