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: Mar 26, 2015

David Z.

Excel * PowerPoint * VBA * Macros * Automation *
   United States
  |   Berkley, MI
  |  2:17 pm Local Time

Overview

Minimum Hourly Rate $45

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 »
Mar 7, 2015|Other IT & Programming|$1,103|Completed
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
Microsoft Excel
Excel
My Score
avg
Microsoft Excel 2003 Test
My Score
avg
Knowledge of Microsoft Office
VBA
XML
Microsoft PowerPoint

Service Description

I strive to understand the project-specific requirements, and deliver thoroughly tested macros and VBA applications to make routine/repeated tasks easy. 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.

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

Keywords

Microsoft Excel
VBA
macros
spreadsheets
charts
Powerpoint
automation
My Snapshot
IT & Programming
2
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
1
0
25
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.