Modelling jobs?

poiu

Active Member
Joined
Sep 13, 2011
Messages
384

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Poiu,

No expert on the financial sector but stockbroking companies, hedge funds and banks would be seem to be the logical choice.

Like a lot of jobs that you think would suit anyone with an internet connection, many may want you in their offices.

If you are going to work for the financial sector, I suggest you have some experience or qualifications in the area. Being an Excel expert would not be enough. You have to know what the figures 'mean' (ie the difference between current and non current liabilities, the difference between profit and free cash flow).

hope that helps.
 
Thanks very much. I am a qualified accountant but in an (blue chip) engineering firm. Do you think a London city finance company would be interested in me? I was pondering doing some contract work to get my foot in the door...
 
Having an accounting degree and experience within a commerical environment, would be a big plus.

London would be a start, being a major financial hub within Europe.

Contracting would be a good start but remember you might have to compete with cheaper options from around the world.
 
Last time I looked into work in London (a few months back), the jobs were demanding considerable skills and qualification for comparatively little money. London is expensive to live in or commute to so I think there are better options outside of London. Course I could be very wrong, but when I was looking for Excel/Finance related contracts in London that was the impression I got. Seems that to land any decent job I either need to have significant SQL/C programming skills, or be a blooming mathematician... I was admittedly looking at the banking industry.
 
Amongst other things, I employ modellers in banking / financial services industry. Some random thoughts:

1) No-one will give you a modelling job because you know excel quite well.
2) When considering your career, distinguish between modelling and analysis. Successful analysts do things like automate things for fun. Successful modellers read new developments in probability theory for fun.
3) Without direct domain experience, you need **** good, proven, well above average modelling skills to get a foot in the door in a modelling role that's not paying peanuts
4) Modellers in banking do a lot less modelling than you think (imagine all the regulatory stuff they have to deal with, before you even start on the documentation, meetings etc etc etc)
5) Modellers in firms that contract to other firms that would like to have more modellers than they can afford full time tend to do more actual modelling
6) There are other routes in. In banking, models need to be validated so there are model validation teams. You can, sometimes, get into validation teams more easily with less domain expertise, then move into 'proper' modelling once you've proved yourself.
7) Think creatively about how you demonstrate your modelling skills. If someone came to me, said they hadn't really had the chance to demonstrate the range of their excel skills in their current job, but had 8000 posts on MrExcel and had recently been recognised as an MVP, I'd pay quite a lot of attention. Ditto modelling. There are 'model-off's out there, as you have identified. You could, without too much total effort, find other 'non-traditional' ways to prove your interest and skills.
8) There are a very large number of people who call themselves 'modellers' who work in marketing firms. (Think propensity to respond to marketing offers etc). Some are very good. But, as a general rule, the less regulated the firm using the model, the easier it's going to be to get into the modelling department.

…which may or may not help.
 
Thanks everyone, that's great advice.

I think I was way to vague in my search - at the end of the day I'm not a professional computer programmer so all the C++/C# jobs are way over my head, and I'm nowhere near a maths degree graduate.

But given my accountancy qualification and some management accounts experience, I'm narrowing down my search to:

1. Creating models of profit & loss statement, balance sheet and cash flow statements for forecasting / investment appraisal
2. Scenario analysis / What-if analysis / Montecarlo analysis for the above.
3. Maybe some 'bid modelling' if that's similar to 1.

That seems to pay £40k-£50k in London and £40k outside of London so hard to justify the expense of living in London. Although these jobs are sparse so it seems hard to string together jobs in one place outside of London? I'm not sure it's practical at all.... :-(
 
You know, I bet a lot of people started off thinking that Excel was way over their head, then VBA was too much, then C# / C++, etc was too much. I know that's how I started...you just have to roll up your sleeves and give it a go. Before too long, you'll have a good handle on C#/C++ and ready to tackle some other language. Don't sell yourself short on what you can accomplish with a little effort and time investment. Have you had a look here: Microsoft Virtual Academy <Microsoft Virtual Academy

There are a ton of free resources in just about every one of Microsoft technologies (Excel included) in that link.
 
Amongst other things, I employ modellers in banking / financial services industry. Some random thoughts:
...
7) Think creatively about how you demonstrate your modelling skills. If someone came to me, said they hadn't really had the chance to demonstrate the range of their excel skills in their current job, but had 8000 posts on MrExcel and had recently been recognised as an MVP, I'd pay quite a lot of attention.

A few more posts & I'll be there, Paddy. :-)

Happy new year & thanks for sharing your random thoughts.

regards, Fazza

PS
And there I was thinking I'd need to lose a few kg & be taller & slimmer to do a modelling job
:laugh:
 
Last edited:
I've been impressed for a good few thousand posts already, Fazza :)

Seasons greetings & all that….P
 

Forum statistics

Threads
1,223,727
Messages
6,174,146
Members
452,547
Latest member
Schilling

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