Any Excel Learning Resources for Traders?

[TheNegotiator 13]

I was trying to do some work in excel on some data and came across something I wasn't able to do. The thing is, it's all there on the net but it can be a bit of a headache to trawl through. So my question to you guys is whether you know of or think it would be worth creating a resource for excel learning targeting the types of exercises traders might wish to perform?

[NYC 10]

Not really excel for trading, but I got a great excel course on groupon for $25,

it takes me though to British NVQ level 2.

After banging through a few hours of course, I creating my own sheet married with Finviz.com data. It's a great end of day screener.

I hope someone does come up with some templates for you though.

[SIUYA 11]

i think it is a great idea.....the challenge may be in keeping it simple.

otherwise you end up trawling through and trying to decipher other peoples formatting.

I am sure we all have plenty of excel sheets that get discovered with a wow, but hell i will never use that.

 

Plus any excel i use usually involves macros which mainly format and automate those pesky things, but still require an understanding of how it all fits together. I also dont want to be dealing with a set of instructions (been there before - its a pain)

 

as a suggestion maybe you are better off using this as a place for people to request certain simple straightforward requests?

People can offer suggestions that either perform the specific task, or provide a way of doing it simply and easily, or help direct to a source that can do it.

[TheNegotiator 13]

At some point I'll put a resource together for some tutorials for basic and intermediate spreadsheets for traders using excel/libre and perhaps create some templates to work off too - if of course there's any interest...

[syswizard 10]

One of the best ways to learn is to get on the msdn/social forums and just browse the posts.

It's a treasure chest/trove of information.

MSDN Forums

For Excel alone, there are several specific forums.

Got a specific problem ? Just post a question !