Find freelancers. Lose those costly delays.

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

or, Register with Elance »

William Smith | Elance
 
176985602337900
Last Sign-in: Aug 20, 2012

William Smith

excel, programmer
   United Kingdom
  |   London, England
  |  7:13 pm Local Time

Overview

Minimum Hourly Rate $14

I'm a certified excel specialist with experience of developing formulas and macros in excel. A few of the macros that I have developed include the following: Combining worksheets macro, VLOOKUP macro, extract URL from Hyperlinks macro, Inserting formulas macro, formatting worksheet macro, etc... I also have experience with data validation in excel using drop down lists. Some of the formulas I've worked with include Text formulas, Logical formulas, Lookup & Reference formulas, Database Formulas, Date & Time formulas, Financial...

Read More »

Skills (6)

Tested
Microsoft Excel
SQL Programming
Oracle Administration
Microsoft Access Administration
Microsoft Outlook
HTML

Employment

BBC
Data Cleanser
2011 - 2012
Data cleansing of media asset management data SQL Programming using Access 2007 Reconciling and matching data using VLOOKUP in Excel 2007 Using formula functions in Excel 2007
City & Guilds
Data Administrator
2010 - 2011
SAP data entry SAP Testing In-house database data entry similar to Access
Office Angels Temps
Data Entry Temp
2010 - 2010
Oracle HRMS Data Entry Excel data entry In-house database data entry
City Sprint
Commercial Analyst
2009 - 2009
Report Builder reports development Excel VLOOKUP matching project Excel Data Entry
Carphone Warehouse
HRMI Assistant
2007 - 2008
Oracle HRMS data entry Oracle HRMS UAT testing Excel Pivot Table reports Excel VLOOKUP project
Clarkson Research PLC
Data Technician
2007 - 2007
Excel Data Entry Access data entry Excel Macro running Chasing up tanker rates from analysts/brokers
HM Treasury
HRIS Assistant
2006 - 2007
Excel Pivot Table reports Excel data entry PSE data entry
Victim Support
Data Assistant
2004 - 2006
In-house database data entry Report running using Access Excel data entry
Hackney Housing
Data Entry Consultant
2004 - 2004
Saffron database data entry similar to Access
Rical Ltd
Data Entry Clerk
2004 - 2004
Excel data entry Word processing Google Searches
LFEPA
Performance Information Assistant
2003 - 2003
Excel data entry Word processing Access reports running
LFEPA
Performance Information Assistant
2002 - 2002
Excel data entry Word processing

Education

University of Westminster
Master of Science in Business Computing
2003 - 2006
Thames Valley University
Bachelor of Science Information Systems/Business
2000 - 2003

Keywords

My Snapshot
IT & Programming
1
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
excelhat
Type
Individual
Member Since
August 2012
Elance URL
Verifications
0
William Smith | Elance

William Smith