Ha, even better would be to furiously scribble down some calcs on a piece of paper, maybe even looking at a quarter as you do so, and then produce the exact answer.

GgeenyusG

One of my fav quotes these days, that i cant get out of my head.

"Whatever you practice you get good at- including BS"

-Denzel Washington, when he confronted a journalist from the mainstream media.

I think my boy jeff beck made this one with bit coin in mind

WAT?



and yet you keep arguing and debating

MIT friend got one on estimating how high the water level rises if he steps in a boat. It may have been funny as he was a lineman on their football team.
OR just that MIT has a football team.

agree

Is this for graduates / entry level? Otherwise it’s pretty bad

Awesome [ossum] embroidery on that skin. She should totally wear shorts all the time they are in, and probably can because Florida.

Mostly analyst level which is one above entry (which would be junior). So these are people with 1-2 years experience.

What part you think is bad? I'm not disagreeing, fwiw, I think the entire process is a joke.

I got my current analyst II position in an entirely different industry without a single technical question asked tho.

I can also say this has been the exact same process across the 2 corporations I've worked at, and appears similar elsewhere from what I've gathered from contacts/interviews.

My oldest has just finished an EE bachelors and is job hunting. Maybe I should nudge him toward Junior Analyst in Corporate Finance?

Lol, electrical engineering?

Tell him he'll be doing the same stupid sh*t as me but getting paid alot more.

Yeah, he's got some big spending dreams. I told him landing a job would be a smart first step.

My industry is different and people aren’t trying to hire drones but the fact that both companies use the same structure should give a clue that its not good. Seems super easy to prepare for and therefore not a differentiator at all

Either way HBR published a research paper 15 years ago that found that 90% of opinions have been decided upon by the time a candidate has sat down

Does he favor a location/industry?

I am very confident in my "how to life" in this area. I was doing quite nicely before my (first?) breakdown.

Played 3 hockey games in just the last 2 nights, and now I'm planning on playing volleyball tonight (thankfully very very very low key). Still, good chance I wake up dead tomorrow.

GfeelingandlookingeverybitofmyageG

Right feely i agree but can you tell me what you look for in a candidate? Senior analyst role is complex bc you need the deep analytics but also approaching leadership role so you need those skills as well.

Its actually one of the hardest roles bc once you hit manager level you lose the need for analytics.

The unfortunate problem with corporate is they are significantly weighted to soft skills at all levels. Its a problem bc 1)these can be faked in an interview and 2) because a senior position is a very analytically heavy position.

We have several analysts on our team that are significantly more qualified than our senior, but she had an mba and knew our hiring manager personally and that was that. This is pretty common.

The most important thing I look for is a track record of achievements and success. Not necessarily just in work, but successful people are generally focused on success and achievement in other areas of their life as well.

Then I look for passion (which I break down into enthusiasm and determination) humility, honesty & integrity and intellect, which are my 4 ‘determinants’ for pure talent and I’m doing this as I ask them about specific projects they’ve worked on - eg I ask career questions in a deliberately way that reveals stuff about their character and beliefs.

And lastly 1. I need to be convinced about their thinking - because influencing ability is the key success factor for corporate advancement and 2. I want to feel energised during and after the meeting - if it’s hard work, people won’t listen to them/want to work with them

I think I'd do ok. I tell a story about buying linens (one of my largest projects ever) and make it into an epic saga.

My biggest problem is modesty. Might be hard for you internet friends to believe but I have a hard time talking about my accomplishments and why I'm a good candidate.

Yesterday I was asked to rate my Excel skills. I said 7/10. Which is hilarious. I literally teach classes on VBA at work.

OK so I've been lurking this thread for a while but wtf

I'm an accountant and I'd assume anyone ranking themselves 5/10 was grossly incompetent

6 or 7/10 means not actively a ****up

literally knowing what VBA is instantly makes you at least a 9/10

Thanks. Yea i was pretty upset about this, Mrs Ava gave me a really hard time (she was listening in our living room, it was a phone interview) I was trying to be honest/sincere bc I know the vastness of excel and between us gentlemen I am a 7, maybe an 8 (considering all that it is capable of I mean)

But like literally compared to the workforce I am probably a 15. Lol

This is the first interview I've had in a long time where I wanted the job. Pretty upset.

This conference is such an odd mix of advisors, big finance insiders, market soothsayers and visionaries. People that manage 10's and 100's of millions of dollars (in some case billions). And yet as a populace there are still the same number of goof balls and mouth breathers. Good to remind myself of that periodically


Sent from my iPhone using Tapatalk

Tbf also some incredibly smart people


Sent from my iPhone using Tapatalk

there are basically five levels of excel at most

#1 - still uses a pocket calculator instead of SUM functions (yes, these guys still exist, I've ****ing worked with them)
#2 - still uses SUM functions instead of just highlighting the cells they want to sum when asked what the total is, making you want to grab the mouse whenever you ask them anything
#3 - is basically fine
#4 - can use sumifs and index match etc without ****ing up several times first, can design a vaguely sensible model
#5 - ****ing macro VBA dickhead who will create something that works incredibly until a year after they leave the company when it will break irreparably

which level do I get for stubbornly using vlookup for everything

I can muddle through VBA coding if I have to l, but largely suck at it. I'd rank myself 9/10, and explicitly caveat the VBA issue.

In my experience, "I'm ****ing great at excel unless you want me to build a macro to solve everything in which case **** that ****" has been far more than enough for every interview I've ever done, because 99% of companies are not looking for a macro to solve everything.

Heh, I'm a 4.5 on that scale.

I use sumifs and index/match every day. Nested ifs and such as well.

When talking to someone that actually understands like you (rare), i say my biggest Excel advantage is building models that are transferable. I always build as clean as possible such that an intern should be able to trace what is happening.

I only use VBA for my personal files, or in spots where I absolutely have to. This is one of the things I stress in my classes. To not use vba just bc you can.

I also always make a "how to" tab in the file that explains like I'm 5 what the vba is doing and how to change it.

Its something I really pride myself on actually.

But yea for example this week I was asked to write vba to change a p&l by director, preferably in a drop down list. I did it with a nested sumif.