Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Marc M. | Elance
 
176985602337900
Last Sign-in: Feb 22, 2016

Marc M.

Excel/ VBA Report Automation Expert
   United Kingdom
  |   Harlow, Essex
  |  3:37 pm Local Time

Overview

Minimum Hourly Rate $19

Advanced Excel expert with strong VBA skills to compliment. Adept in Excel reports of all levels of complexity. Rated top 2% by Elance in Microsoft Excel.

Read More »
Aug 4, 2014|Data Entry|$20|Completed
Jun 13, 2014|Statistics|$20|Completed
|
5.0
Jun 6, 2014|Database Development|$331|Working
Apr 2, 2014|Statistics|$224|Completed
|
5.0

View All »

Portfolio

This is the main viewing platform for this application. It shows all the events in the...
This table then powers the whole document, everything is in this one table.
This form shows different options based on the options you select. This form populates...
This form shows different options based on the options you select. This form populates...
The drop down shown is powered from all the headings in the database table. you can...
This shows the user inputting the criteria for the search.
This shows the resulting output from the search criteria.
This is the first screen you see on the Dashboard, it helps the user select the...
This picture shows the a view of the dashboard, this view is ranked data in a table and...
Following on from picture "Excel Dashboard showing ranked data". This screen...
This window shows the Dashboard with further filtering by year.
This dashboard view shows another dashboard that users can select.
This dashboard view shows another dashboard that users can select.
This sheet is where the user is allowed to write any found bugs or any feature requests.
This is the output from the bidding system I created for a client.
This table powers the spreadsheet everything is linked to this sheet.
This code will handle all scenarios the user can throw at it.
With the use of functions and subs you can easily put code that is reused into a...
This is the final (after all changed etc) output from the bidding system I created for...
This is the final (after all changed etc) output from the bidding system I created for...
This is the final (after all changed etc) output from the bidding system I created for...
This sheet allows the user to change how the bidding system behaves, the first 3...
This macro consolidates data into a summary sheet and outputs the sheet to a new...
This page helped the user to fix some small error's within their data before running...
This is the output the user required for the data. Yes he did want all the blank rows too.

Skills (10)

Tested
Microsoft Excel 2003 Test
My Score
avg
Microsoft Excel 2007 Test
My Score
avg
VBA
My Score
avg

Employment

Tesco's Ltd
Project Developer
2012 - 2012
Developing projects in Excel, VBA and SQL, based on requirements set out by clients. This includes full project testing, full development of the project and User Acceptance Testing (UAT).
Tesco's Ltd
Stock Coordinator
2011 - 2012
Reporting (incorporating data from SQL, Teradata, Outlook, Manual input and Mainframe files):- o Creation Using a variety of sources to create reports for daily/weekly runs and ad-hoc data...

Education

University of Teesside
Computer Studies Bsc
-
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

Excel
Microsoft Excel
Data Modelling
Report
VBA
Visual Basic for Applications
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
99moorem
Type
Individual
Member Since
August 2013
Elance URL
Verifications
0
Groups
Marc M. | Elance

Marc M.