Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

David Z. | Elance
 
176985602337900
Last Sign-in: Nov 20, 2015

David Z.

Excel * PowerPoint * VBA * Macros * Automation *
   United States
  |   Berkley, MI
  |  8:44 am Local Time

Overview

Minimum Hourly Rate $75

If you need Excel- or PowerPoint automation I'd love to help you out.

I have 5+ years professional experience as an Excel/VBA developer; and 8+ years experience in research & analytics for a leading market research company. There, the bulk of my VBA development work over the past 2 years has been building, maintaining, and enhancing a ribbon-based enterprise Add-In for PowerPoint, to facilitate the production of charts and tables from respondent data, in addition to ad hoc macros and other applications to support the research processes.

My...

Read More »
Apr 10, 2015|Other IT & Programming|$1,103|Completed
|
4.9
Oct 31, 2012|Other IT & Programming|$395|Completed
Oct 15, 2012|Other IT & Programming|$90|Completed
|
5.0
Sep 26, 2012|Other IT & Programming|$144|Completed
|
5.0

View All »

Portfolio

A basic dashboard to configure charts, to be created in PowerPoint.
This file consists of a hidden data sheet, and several chart sheets. The chart sheets...
Example of a price calculator dashboard for Excel, which allows the user to select...
Displays some custom data, floating & concatenated data labels, etc., all of which...
This file contains a macro "Anonymize" which will parse text from shapes,...

Skills (5)

Tested
Excel
My Score
avg
Microsoft Excel 2003 Test
My Score
avg

Service Description

A large part of any project is fully-understanding the terms and requirements -- it's not uncommon to spend more time discussing the business rules associated with a product, or hashing out the nuances over several iterations, than is actually spent on "development". My job is to work with you and understand the requirements, so that I can do the development.

With this in mind, I will spend the time up-front, and in collaboration with you to make sure that the project's scope and SOW accurately capture the requirements, identify specific areas for improvement, testing/benchmarking, and any additional enhancements, feature and/or design requests you would like to incorporate.

From there, we can develop a timeline and payment terms for the project milestones and deliverables.

As a graphics programmer I specialize in using VBA in Excel to automate:

* Dynamic reporting tools like "dashboard" chart views
* Ad hoc macros to simplify often-repeated tasks
* Ribbon customization and ribbon-based applications for Office products
* Macros/interface to export charts & graphics from Excel to Powerpoint presentations or Word documents.
* Development of GUI/User Forms to accept user inputs to drive macros, etc.
* Customized deliverables like charts and data tables
* Data and text sorting, manipulation, transposition, transfer, etc.
* De-duplication and validating lists with multiple parameters



Read More »

Education

Walsh College of Business
Master of Arts, Economics
2005 - 2007
Central Michigan University
Bachelor of Arts, Business Administration
1998 - 2003
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

Microsoft Excel
VBA
macros
spreadsheets
charts
Powerpoint
automation
My Snapshot
IT & Programming
4
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
dzemens
Type
Individual
Member Since
September 2011
Elance URL
Verifications
0
Groups
David Z. | Elance

David Z.