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 freelance font une offre moyenne de ₹21850 pour ce travail
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.
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
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
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.
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
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.
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
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
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
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
I am a retired MBA with decades experience working with excel and VBA. I have both expertise and time...
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 3 years of experience in SQL, Excel ,VBA macros.I aim to deliver efficiently within the fixed span of time.
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
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
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
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.