QUICK how do i learn excel for a financial analysis role? i've

>>1460697
did you not do an internship first? what the fuck
they made you use excel in college projects too

>>1460697
youtube dude, ever been on the internet before?

>>1461010
This. There's not a single, more simpler method.

>>1460697
>an excel test
Is this real? Can't anyone learn Excell in a day? Is it actually a marketable skill?

>>1461156
You'd be surprised, some people think pivot tables are magic.

>>1461156

shut the fuck up

>>1460697

sorry it's impossible to learn

if you aren't using all hot keys and have to use your mouse your not going to make it

>>1461158
Pivot tables indeed.

>hiring manager says You have 15 minutes to complete proforma analysis, 3 merger options * 3 financing options = 9 total scenarios with 3, 5, and 7 year NPVs. Assume Rf 3%, everything else is either in the prospectus provided or was in our 10k filed last month.
>oh and one more thing..
>disconnects the mouse from every PC and walks to the door
>14 minutes

>>1460697
Depends on how advanced the test is I guess. I'd imagine the test is pretty simple and they just want to make sure you have a basic/intermediate knowledge.

>absolute references
>conditional formatting
>if functions
>pivot tables
>VLOOKUP
>HLOOKUP
>maybe how to graph some shit
>get familiar with formatting tools
>maybe how to record a basic macro

I doubt they'll ask you to do any VBA shit but who knows.

>>1461164
the amount of mad in this post is making me laugh