*MS SQL Server/MS Access/VB/VBA RDBMS software application architect/business analyst/programmer/tester/implementer/system and DB administrator; *MS Office/MS Excel programmer. *B to B Sales & Sales Executive/Director, Direct/Indirect Marketing Executive *Technology, Real Estate, Financial/Banking, Tourism/Travel, Public Utilities, etc. *Translator, writer, editor, proofreader, and teacher - experience on 4 continents; *Native spoken/written in English and Spanish, and experience with additional languages, including French, German, Italian, and Tagalog; *Teachers and English/Spanish translation/instruction training in USA, Europe, and Latin America; *ESL/EFL/TOEFL/TESOL/business/conversational/pronunciation (phonetics/phonology) instruction; *Kindergarten through high/prep school, and private tutoring of all ages and materials; *EN-ES/ES-EN translation of general text, business, web, medical and information technology materials; *Freelance, creative, travel, journalistic, medical and information technology writing; *Proofreading.
Get Your VBA Development Project Started Today!
Post your VBA project on oDesk and find freelance VBA programming experts. These professionals can write VBA code for Excel (e.g. web scraping and graphic charts generation functions), create a visual environment with entry forms, write VBA scripts to change formatting or fill in data from your software, or clean up Excel or Access files (rearranging columns or removing special characters). They can also add FTP upload functions or design VBA-based templates for your Microsoft Word documents, create custom contact forms for Outlook, write VBA macros to export Microsoft Access data in custom formats, and add or remove features in your Access database.
Visual Basic for Applications (VBA) is a Microsoft programming language that enables the development and process automation of user-defined functions. On oDesk, the world’s largest online workplace, experienced VBA developers can manage your Microsoft Office automation or UI modification, review and fix your VBA functions, and help you transfer data automatically between MS Office applications.
VBA Job Cost Overview
Typical total cost of oDesk VBA projects based on completed and fixed-price jobs.
oDesk VBA Jobs Completed Quarterly
On average, 191 VBA projects are completed every quarter on oDesk.
Time to Complete oDesk VBA Jobs
Time needed to complete a VBA project on oDesk.
Average VBA Freelancer Feedback Score
VBA oDesk freelancers typically receive a client rating of 4.79.
Have 5+ years of experience in Excel Reporting, Dashboards, Data processing and report automation using VBA and integrating multiple office applications. Such as Excel with Outlook/Word/Powerpoint. Have developed various tools/reports/dashboards using Advanced excel and VBA over these years. Looking out for jobs to utilize my analytical and Excel skills and to provide value add services. I also have experience in Creating multiple labels (Address Labels, Bar Code Labels etc), SQL, MS Access and Salesforce.
- Microsoft Excel VBA Macros Programming , Macro Automation Expert; Android Application Development - Coordination and implementation of automation projects; - Dashboard and Automated Reports Project; - Pivot, Power Pivot, VLOOKUP, HLOOKUP, Data Connections, Emails - Implementation of Supply Chain software; - Office automation projects (Access, Excel, VBA); - Oracle, MySQL, SQL Server, Stored Procedures - Microsoft Excel, VBA, MSAccess & SQL: 5 years experience; - Software Development & Testing , Software Implementation
I've been working for 13 years in several of the best consulting & development firms in Spain, performing almost every possible role of my career: developer, analyst, consultant, trainer, etc. Nowadays I'm comfortable working as software architect or technical lead / project manager, however I still enjoy programming. My wide experience as a technician gives me background enough to provide the best solutions even in the most critical and tough projects. Several years as freelance developer/consultant prove my capacity of joining and getting the best results from any team, as well as my autonomy and effectiveness providing solutions for tough requirements. Right after finishing my profile here in ODesk last year I found a nice project in Cork-Ireland. After spending one year there I'm back eager to make my way in remote work. Enthusiastic with my team and projects, my commitment grows up when problems arise, especially with high responsibility roles. Sometimes, if excellence is not reachable, I believe that there always exist a clean, dignified and effective solution; extra doses of constancy and tenacity are needed in order to approach successfully any challenge.
Do you want automation in Excel? Are you tired of making same reports every day? Do you want your job/project get done effectively and efficiently? Being an Expert of Microsoft Excel (VBA), I can help you out from those tedious circumstances that trouble you most. Since I got 6 years of extensive experience in designing and coding complex Excel based Application. A wide range of small utility software or program has been developed through the use of Excel VBA (portfolios attached). I believe my capabilities are perfect for building any excel related projects. Besides, I have got very good control over using different software and methods of VBA which allow me to migrate or scrub data from PDF to Excel, Word, PowerPoint, Access and Vice Versa and to scrape or mine required data from web too.
I have remained engaged with modeling and predicting healthcare claim and disease risk in Life and Health Care Insurance and then Disease Management Company, providing VBA Development, data modelling, algorithmic development and implementation and other technical services in the following areas: Algorithm Development and Implementation for Disease Risk Prediction VBA Programming Spreadsheet Development (Excel / VBA with cross-application COM based programs), Data Analysis Building Actuarial Models Predictive Modelling for Group Health Care Claims Financial Modeling (including cashflow projections), Copy Writing / Creative Writing, Report Writing / Research Writing Database Design (MS Access)
When I was 11, my parents showed me how to use Excel to track my trading card collection. Today, I'm a spreadsheet ninja. I know pivot tables like the back of my hand, I can script you out a macro in a matter of hours, and I can nest functions together in ways you've never thought possible. Big words, sure, but I back it up. I have built reports, ad hoc and repetitive, that have gone as high as the board of directors of Fortune 500 corporations. My VBA-enabled smart forms are used by front-line operations personnel, and are robust enough to handle transactions from any end user. I also have many years of experience developing business procedures and workflows. I can map out a workflow and easily identify where efforts are being duplicated or wasted. My expertise in automation has helped large companies reduce their staffing costs while reducing manual error rates and increasing overall productivity. As a business person who "speaks tech", I make a fantastic liaison between end-users and developers, thereby reducing complications during the business application development process, and making sure that the product you need is what is actually delivered. I also know a thing or three about coding and web design. Self-taught mostly; I took the intro to Comp Sci courses in college, but I picked up most of my chops modding video games and automating repetitive tasks at work. I've also taken a few Codecademy courses to round out my knowledge base. I've never spent too long in any specific language, so I actually think I have a better understanding of how computer science works than a dedicated coder who stays in one language all day does. In essence, a lot more breadth than depth. Languages I know today and are comfortable taking on work for include C/C++/C#, Java, Python, HTML, CSS, and PHP.
James T. Agency Contractor
Sunil P. Agency Contractor
Ranked in Top 10 Canadian Odesk Consultants from August 2013! More than 500 oDesk hours! Sr. Web Developer and Project Manager(PMP) helps you create intellectual websites that leaves better impression on your brand.
Microsoft Excel MVP Microsoft Excel VBA Guru Microsoft Excel based analysis expert Designs and automates Dynamic Dashboards I only provide high quality work. Achievements · Expert level use of Microsoft Excel, MVP Award from Microsoft, and VBA for business analysis and reporting. Made and automated reports that go directly to company CEO & COO. · Designed and built custom reports from raw CDRs to track sales/revenue growth, attrition rate and customer behavior (to promos and popular events/days) for a telecoms company, · Designed a dashboard that tracks key metrics used in making revenue forecast and determining average customer’s lifetime value for a telecoms client, · Designed and automated performance tracker for country business operations managers and project heads for a corporate client, · Helped Comviva Airtel Africa CRBT team beat the month’s target of $1,000,000 in just the 5th month of full operations, as a consulting Business Analyst.