Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Iain Watson | Elance
 
176985602337900
Last Sign-in: Jul 9, 2014

Iain Watson

Excel and VBA Developer
   United Kingdom
  |   Windsor, Berkshire
  |  3:32 pm Local Time

Overview

Minimum Hourly Rate $22

Ranked by Elance in the top 1% of Excel 2010 experts. Professional designer of Excel / VBA macro solutions. Trying to build a rating and reputation, so hiring at a discounted rate.

Read More »
Jul 8, 2014|Other IT & Programming|Private|Working
Jun 25, 2014|Other IT & Programming|Private|Completed
|
5.0
Jun 23, 2014|Statistics|Private|Completed
|
5.0
Jun 19, 2014|Other IT & Programming|Private|Completed

View All »

Portfolio

An example of a price calculator I developed for a small business incorporating...
Developed a retirement funding calculator for a small independent financial adviser.
This is an interactive price list I designed for a major multinational company to...
Example of a small database-style sheet used by a client to record and edit bookings.
I have extensive experience in aggregating and presenting very large volumes of complex...
I am particularly skilled at using advanced multipart lookups to combine disparate...
I am particularly skilled at using advanced multipart lookups to combine disparate...
Some tasks in Excel, such as the quick generation of bubble charts with particular...
Pivot Table from a Sales Analysis I designed for my firm on behalf of an Australian...
Example of a reporting dashboard for a manufacturing client (data scrambled to preserve...
Designed and produced a custom pricing calculator with complex, dynamic lookups to...
A commission calculator for the owner of a franchise sales business with very complex...

Skills (1)

Tested
Microsoft Excel
Microsoft Excel 2010 Test
My Score
avg

Service Description

My day job involves creating custom excel spreadsheets with advanced formula and macro functionality to national and international clients' specifications.

After briefings and calls for changes, I always summarize my plan in writing, to ensure clear communications, timelines and to avoid wasting your time.

I fervently believe that nothing is impossible in Excel - if the data is there, I'll make it do whatever you need! My work reflects on me, and I'm very proud of my history of spreadsheets that do their job consistently and elegantly.

As well as my technical skills, I can bring to the table excellent communications, flexibility and a positive and polite attitude. I'm flexible and personable, and am always happy to follow-up and iterate on any work I do.

Read More »

Employment

Brand View Ltd
Analytical Commercial Liason
2011 - Present
My current role primarily involves producing custom Excel spreadsheets for our national and multinational clients to their specifications. These dashboards and reports use advanced Excel...
(Small Photography Business)
Freelance Access Developer
2011 - 2011
I designed a custom Access database to help a small business owner keep track of her clients, their payment status, what needed to be done for them etc. I designed a custom front page form to her...
Regus
Pricing Analyst
2009 - 2011
My role involved monitoring sales figures and pricing strategies for our global office letting company. I had to perform analyses on data and produce custom spreadsheets for middle and senior...
London Technology Network
Technology Team Facilitator
2008 - 2009
My role here involved liaising with high-ranking university academics, gathering data from them and performing analyses in Excel, The results of these analyses were presented to the CEO, regional...
Westminster Council
Freelance Excel developer
2008 - 2008
Designed a custom dashboard for Westminster Council's street lighting division, including a lookup tool that scraped data from large and poorly-cleansed source material.
TIES IT Consultancy
Freelance Analyst
2007 - 2008
A variety of freelance Excel and Access work for a diverse range of public- and private- sector clients.
UCLH NHS Trust
Data Analyst
2005 - 2007
Analysing and auditing pharmaceutical data on behalf of the NHS, including making presentations to middle and senior management.

Education

University College London
Physiology & Pharmacology BSc
2002 - 2005

Keywords

Excel
VBA
Macros
Charts
My Snapshot
7
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
Total
Milestones
Hours
Reviews
4.9
Recommend
Clients
Total
Repeat
Earnings
Private
Private
Total
Per Client
Identity
Username
iainwatson
Type
Individual
Member Since
January 2013
Elance URL
Verifications
0
Groups
Iain Watson | Elance

Iain Watson