Salary requirements for a low-skilled Excel spreadsheet and report designer?

Glory

Well-known Member
Joined
Mar 16, 2011
Messages
640
Tried asking this in the more general forum, but haven't gotten any response.

What should I be expecting as compensation for doing this?

I can create a couple of really simple formulas. I'm not that great with them.

But I've written userforms and scripts to automatically generate and color-format pivot reports, and then print them. I've also coded ADO connections that autoupdate key employee and material lists.

What sort of salary would be considered reasonable for a position like this one ("Professional Services Analyst")?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Hi
Gee, that's a "How long is a piece of string" type question.
Also depends on what country you are in ?
If your in Australia, you could have a look here to give you an idea, but it depends on your skill set, type of analyst required, etc.
you could be doing statistics, finance, Risk based and all will pay at different levels.

Code:
http://content.mycareer.com.au/salary-centre/financial-services/financial-services-analyst
 
Upvote 0
Personally, based on my experience, pivot table creation and any kind of coding at all seems to be a fairly rare (and thus at least somewhat more valuable) skill, so should be compensated accordingly. Personally, I don't think that there are many full-time positions just doing Excel reports, usually that will be a small part of some sort of Administration or clerical position.

The main problem you may run into, is that the people who could most use the kinds of services you offer have, generally, no idea what Excel can be used for and would have a hard time putting your skills in context.

if you are looking at hanging out an internet shingle, I would guess that the wage rates are pretty low (by North American standards anyway). SEe here for some discussion of this industry.

http://www.productivity501.com/ultimate-virtual-assistant-guide/813/

Cheers, :)
 
Upvote 0
I'm with shawnhet - most people that could use your services, don't know they could. There's room in the market for some strong (like, Mr Excel moderator strong) coders to form a company that could contract this sort of stuff out to large companies.

My personal story (the end result of which is that I became a VBA Programmer and now a statistical analyst/programmer) is that I just worked in Call Centres and Support Centres for a few years, and through a little ingenuity, a keen eye for detail, and strengths in process improvement and 'screw-tightening', I would undertake small projects, in my own time, to drastically remove double handling and manual input from mundane tasks. Might be a good place to start :)

I now build bespoke VBA applications/forms/reporting tools for Excel, MS Project, and starting some Access powered stuff.

In London, this sort of work gets you anywhere from 28,000GBP to 50,000GBP, depending on (again, as already mentioned) experience and the industry. Banks/Finance companies pay way more than anyone else. I've managed to find a home in Media/Telecommunications IT/Reporting.

VBA is still quite powerful, especially if you can learn enough .NET and/or C/C# or even just SQL to widen the scope of your 'powers' - and because it is simultaneously becoming an 'antiquated' language (people doing PERL/Python rolled their eyes when I was hired), it becomes as said, rarer and more valuable.

There are people now knocking on the door of 50/60yrs old, who never learned another language, but know the stuff that hasn't been taught by anyone for 20 years - and is the stuff a lot of Financial insitutions have their entire systems structured upon. Nowadays, on a major migration project, that person could expect over 150,000GBP to lead the project team
 
Upvote 0
And 130 miles north of Climoc the pay is about £24k for the same skills (but I don't have to put up with London at rush hour - so it evens out).
 
Upvote 0
Yeah... I live within the M25 and it STILL takes me nearly 2hrs to get to said workplace... Had one job for 40k (contracting though) near Piccadilly - that was good. Wouldn't want to have to get to Canary Wharf though, f*** that for a joke
 
Upvote 0

Forum statistics

Threads
1,225,609
Messages
6,185,981
Members
453,333
Latest member
BioCoder84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top