Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Dave B. | Elance
 
176985602337900
Last Sign-in: Feb 14, 2015

Dave B.

expert Excel solutions
   United States

Overview

Minimum Hourly Rate $55

Excel developer with a focus on the end user. Skilled at assembling, manipulating, analyzing and presenting data while ensuring the files are user friendly and exactly what is expected. Many times users are unaware of existing Excel functionality that would easily accomplish their data needs. Spreadsheets created for my current employer's diverse employee requests typically include formulas (protected or visible, simple and complex), validation, cell referencing, custom views, PivotTables, macros, change tracking, grouping and/or charts &...

Read More »

Skills (4)

Tested
Excel
My Score
avg

Service Description

I enjoy transforming user's need for data into simple, easy to use, yet robust Excel spreadsheet files. Excel is so flexible and powerful that users are sometimes astonished at what works of art can be created to help them manage budgets and projects, store and share data and most anything else that involves data.

Previous (pre-elance) Major Accomplishments:

designed Access database for nursing staff data collection and analysis specifically for continuing education research. Nurses were published in national journal. Cited in acknowledgments "for the development of the data collection tool".

customized campaign data "walking lists" created for local city mayor's staff created by using voter data and arranging for campaigner's requested order of specified zip code, street and even/odd address patterns.

recurring yearly interactive patient chart audit files generated to comply with audit requirement for numerous physician practices using imported mass amounts of qualifying data and random criteria to select records. Tablet and laptop nurse auditors used via corporate network to document audit findings. All of which was later imported to a master Access database for storage, retrieval and further analysis.

replicated purchasing dept customized spend usage data Excel reports after system change and loss of report. Using four database table or SQL extractions and numerous Access queries, procurement data is analyzed against warehouse inventory values to...

Read More »
Overview  |  Job History  |  Resume/C.V.

Keywords

Excel database spreadsheet import analyze
export report functions PivotTable Crystal Reports Access
My Snapshot
All Categories
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
Private
Private
Total
Per Client
Identity
Username
burnhamd
Type
Individual
Member Since
October 2011
Elance URL
Verifications
0
Dave B. | Elance

Dave B.