Excel thread.

Snarelure
Snarelure

/g/ was of little help, and I know that Veeky Forums is quite handy with Excel.

How do you become an Excel wizard? I'm wanting it for financial shit.

All urls found in this thread:
https://www.amazon.com/Microsoft-Excel-Analysis-Business-Modeling/dp/0735669139
TurtleCat
TurtleCat

@Snarelure
It's as easy to use as word. I don't understand what is so hard about opening up and using it? Not like you're learning R or Python.

VisualMaster
VisualMaster

Read john walkenbach's excel books and you will be a god.

Need_TLC
Need_TLC

youtube.com/excelisfun

Boy_vs_Girl
Boy_vs_Girl

@Snarelure
You have know financial/statistical formulas if you want to make any sort of model using Excel.

kizzmybutt
kizzmybutt

@Need_TLC

Oh sick, nice!

Gigastrength
Gigastrength

@Boy_vs_Girl
You have know financial/statistical formulas if you want to make any sort of model using Excel.
I'm already a maths undergrad, so I'm in a good position there.

Techpill
Techpill

@Gigastrength
Financial mathematics is based on very advanced probability. Your undergraduate mathematics isn't really sufficient.

StrangeWizard
StrangeWizard

@Techpill
Financial mathematics is based on very advanced probability. Your undergraduate mathematics isn't really sufficient.
I'm working on it, I'm doing mathematical finance stuff next year, followed by shit like black-scholes.

w8t4u
w8t4u

Fuck Excel. Learn RDBMS data modeling and SQL then Python and Numpy. You'll be way more successful and empowered.

Crazy_Nice
Crazy_Nice

Microsoft's online help for excel is actually based off this work:

https://www.amazon.com/Microsoft-Excel-Analysis-Business-Modeling/dp/0735669139

farquit
farquit

@Snarelure
nigga, just look up the key shortcuts

takes2long
takes2long

@Snarelure
Just fucking open it and use it? You're not actually coding so what's the problem?

BunnyJinx
BunnyJinx

@Snarelure
Chandoo is your friend, google it

Excel is largely muscle memory when it comes down to it. Use it a lot for different stuff. Learn how to use things like vlookups, ifs, nested functions etc. until you can move data around really comfortably.

Excel can be a pain in the ass (particularly on OSX), so if you end up doing the same tasks over and over again, automate them through python using Pandas, thank me later

Stupidasole
Stupidasole

why are you not using google spreadsheet ? i mean seriously ?

Supergrass
Supergrass

@Techpill

college kids really believe this

New_Cliche
New_Cliche

@Supergrass

As a FINC major, any math major could transition into FINC easily. It'd be mostly definitions and understanding why you're using the formulas, but the math part is fuckin' ez

Ignoramus
Ignoramus

@Techpill
How advanced probability are we talking about? Do you need to use measure theory?

Stupidasole
Stupidasole

@Supergrass
still using those pixelated 4k pics

TurtleCat
TurtleCat

Bump

hairygrape
hairygrape

@Ignoramus
Are you trying to bring Lebesgue integration into this?

King_Martha
King_Martha

@Snarelure

Auditor here. I use it everyday.

The most common tools I use are sorting, text to columns, matching functions, v lookups, pivot tables, ect.

It's all about seat time. You have to use the program everyday to become a wizard. I now want to get into making macros.

What financial shit are you wanting to do?

haveahappyday
haveahappyday

@King_Martha

financial analyst here for a small-medium sized company.

This guy pretty much sums it up. I've only been working 4 months and my skills have improved at a very fast rate.

CodeBuns
CodeBuns

Always remember to use "at the beginning and ending" of each formula.

Just because. lol.

Sir_Gallonhead
Sir_Gallonhead

It's literary as simple as googling how to learn excel advanced. Fucking normies

Disable AdBlock to view this page

Disable AdBlock to view this page