Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Luke L. | Elance
 
176985602337900
Last Sign-in: Jun 15, 2015

Luke L.

EXCEL VBA SPECIALIST
   United Kingdom
  |   London, n/a
  |  2:20 pm Local Time

Overview

Minimum Hourly Rate $11

Self taught Excel VBA specialist with over 3 years experience in developing and implementing cost reducing customised spreadsheet solutions.

Read More »
Nov 13, 2012|Database Development|$0|Completed
Nov 13, 2012|Database Development|$40|Completed
Nov 6, 2012|Software Application|$120|Completed
Sep 21, 2012|Software Application|$54|Completed
|
5.0

View All »

Skills (2)

Tested
EXCEL VBA PROGRAMMING
Microsoft Excel 2003 Test
My Score
avg
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg

Service Description

Most business users have a basic working knowledge of Excel, but few realise its powerful potential when combined with VBA. With an in-depth knowledge of over 100 functions, as well as the major VBA Objects, Properties, Methods & Loop constructs, I am able to create models which determine the most effective solutions to seemingly unsolvable problems.

My previous experience in developing Excel/VBA applications have generally involved applying VBA in order to automate tasks/processes to the greatest extent possible. Eg, automated process of data extracting imported data into appropriate format, via a variety of TEXT functions and the assignment of Dynamic Named Range Variables to the VBA Autofill method & Offset property.


SAMPLE OF EXCEL/VBA CAPABILITIES
Familiarity of over 100 Functions.
Familiarity of over 50 Properties and 20 Methods of the major Objects.
Event Handler Procedures.
Dynamic Named Ranges.
Dynamic Charting Formulas.
Dynamic Pivot Table Reports.
In-depth knowledge of the Chart Object Model.
UserForms & Custom Dialog Box Alternatives.
User Defined Functions.
Monte-Carlo Simulation.
Data Analysis tools such as Pivot Tables, Anova, MMA.


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

Keywords

EXCEL
VBA
MACROS
FORMULAS
FUNCTIONS
DYNAMIC CHARTS
EVENT HANDLER PROCEDURES
DYNAMIC NAMED RANGES
PIVOT TABLES
USERFORMS
USER DEFINED FUNCTIONS (UDF)
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
Total
Per Client
Identity
Username
LL1980
Type
Individual
Member Since
January 2012
Elance URL
Verifications
0
Groups
Luke L. | Elance

Luke L.