Free Model-Formatting Course
Summary This is not a financial modeling course like the one that is offered at Wall Street Prep, Investment Banking Institute or Analyst Exchange. Mod Note Not WSO competing products. Rather this is a series of free tutorials that help modelers on best practices on how to do modeling (formatting, structure, setting up).
I completed the 30 days challenge and I can definitely see that my modeling skills have improved a lot. Would highly recommend “experienced” Monkeys to tried it out. Once again, it does not teach you modeling. It is more focused on best practices on setting the cells, formatting and building a structure to make your modeling easier and standardized across the banks.
F1F9Academy 31 Days Challenge
Main Page: http://www.f1f9academy.com/free-31-day-financial-modelling-course
Day 1: http://www.f1f9academy.com/31days/welcome
Day 2: http://www.f1f9academy.com/31days/excel-productivity
Day 3: http://www.f1f9academy.com/31days/column-structure
Day 4: http://www.f1f9academy.com/31days/formula-construction
Day 5: http://www.f1f9academy.com/31days/row-totals
Day 6: http://www.f1f9academy.com/31days/formula-consistency
Day 7: http://www.f1f9academy.com/31days/F11-quick-chart
Day 8: http://www.f1f9academy.com/31days/customising-the-f11-quick-chart
Day 9: http://www.f1f9academy.com/31days/heading-columns
Day 10: http://www.f1f9academy.com/31days/inputs
Day 11: http://www.f1f9academy.com/31days/fast-format-macros
Day 12: http://www.f1f9academy.com/31days/assignment-part-1
Day 13: http://www.f1f9academy.com/31days/assignment-part-2
Day 14: http://www.f1f9academy.com/31days/errors-in-financial-modelling
Day 15: http://www.f1f9academy.com/31days/calculation-blocks
Day 16: http://www.f1f9academy.com/31days/navigating-using-links
Day 17: http://www.f1f9academy.com/31days/daisy-chains
Day 18: http://www.f1f9academy.com/31days/copying-links
Day 19: http://www.f1f9academy.com/31days/assignment-revisited
Day 20: http://www.f1f9academy.com/31days/copying-calculation-blocks
Day 21: http://www.f1f9academy.com/31days/row-anchoring-in-calculation-blocks
Day 22: http://www.f1f9academy.com/31days/placeholders
Day 23: http://www.f1f9academy.com/31days/listing-placeholders
Day 24: http://www.f1f9academy.com/31days/timing-flags
Day 25: http://www.f1f9academy.com/31days/cross-worksheet-links
Day 26: http://www.f1f9academy.com/31days/paste-link
Day 27: http://www.f1f9academy.com/31days/advanced-productivity-paste-link
Day 28: http://www.f1f9academy.com/31days/advanced-productivity-shortcut-macros
Day 29: http://www.f1f9academy.com/31days/modelling-balances
Day 30: http://www.f1f9academy.com/31days/template-sheet
Day 31: Link to the seminar, useless
Previous post: http://www.wallstreetoasis.com/forums/nyssa-equity-research-initiation-…
NYSSA IRC Timeline: http://www.box.com/s/1cef775bf8f209f27078
NYSSA IRC Previous Year Winner NYU on PVH: http://www.box.com/s/a086141839effba4c25e
NYSSA IRC Judging Criteria (Presentation): http://www.box.com/s/9163f162c5eb145298d8
NYSSA IRC BITS Report: http://www.box.com/shared/p1n6t7vggi
NYSSA IRC BITS Model: http://www.box.com/s/c4a49d276c687078b3da
NYSSA IRC BITS Presentation: http://www.box.com/s/a85867fc5e429f3ff859
NYSSA IRC BITS Presentation Q&A: http://www.box.com/s/ecb1963a5bab5a3f3489
Quick Overview on Valuation: http://www.box.com/s/810cdfb62535f3081456
Equity Research Analyst Handbook: http://www.box.com/s/95be1f229c51661b9cd9
Another useful post: http://www.wallstreetoasis.com/forums/personal-development-0
To keep you guys motivated http://www.wallstreetoasis.com/forums/get-motivated-move-forward
15% Off wall st. prep Financial Modeling Training Click Here
Thanks buddy
I've been on this full course ( 2 days in person), for which this "challenge" (did it in a day like a baawss) is the intro course and i wouldn't wholly recommend it. They teach a very unique style of modelling which isn't very transferable.
I get MS for offering an opinion on a course which people seem to be interested in and which I have (on the firms money of course) completed, wow what has this site come to....
These courses are expensive ! What was the actual content of it ? what about the average age of the class?
The course we had was in-house so can't say really opine on the normal clientele.
Content was from scratch modelling, with a focus on project finance. They teach a very individual style of modelling. they use A LOT of rows for the reason that EVERY (and i mean every) calculation has to have its constituents above it in a "calculation block", (you will never see SUM(A6,A45, A50) it'll be SUM(A51:A53) with A6 etc. copied) this does made reading models easy, no finding where things are from (which lets be honest isn't hard anyway) as all the parts are there for you, however this is time consuming and makes the models huge with a lot of repeated information. This approach is implemented with IFs (i.e. no nested IFs) which further increase the rows of superfluous calcs. in favour of easy reading.
They also insist on having spaces between every thing in your formulas (e.g. IF(A1=1,1,0) would be IF ( A1 = 1 , 1 , 0 )) which gets very boring, very quickly.
But the major disadvantage of this approach is that when you're teaching novices this method they become stumped when they're shown a normal model (so any model that you're sent from any other firm). They'll have no idea what they're looking at so, and this is where their business model comes into it's own, you can pay them to take the model apart and put it back in the way that you're able to read it. sounds wonderful, but what happens when you don't have time, when you move firms to a company who doesn't subscribe...you're fucked.
They also fail to use real world case studies on the course which I think is pivotal to the success of modelling courses.
Thanks dude
Wow!
You have awesome threads dude, thanks!
The links to the days does not work for me, if you could kindly PM them, it would be greatly appreciated. Also, for someone with no modeling experience, would this be beneficial?
Lots of helpful tips in here for people who are just starting out or think they could be faster in Excel. Thanks Human.
SB'd. Thanks for posting.
thx bruv
None of that here, please.
you mad bra?
got some autoritah complex? dilusional boss wannabe?
thx bruv
Would SB you but was taxed all my remaining bananas by the establishment
thx blud
Its stuff like this why I keep reading this sight. Signed up and stoked to do this modeling course. thanks human, great post!
Human, thanks for this. +1 SB.
Don't do it; you'll just receive dozens of emails containing animal pornography. Just kidding, thanks, I signed up
Thanks for the SBs.
Lots of great stuff. I thought I was getting pretty decent with the models at work, but this definitely showed me a few tricks that I wasnt aware of (even after taking TTS)
Sit voluptate tenetur sunt ratione. Non laboriosam tempora ad nostrum magnam non illo. Iusto odio et dolorem sit dignissimos impedit et. Quae nihil distinctio quas voluptates inventore. Ea aperiam enim voluptatum voluptas qui ipsum autem officiis.
Velit neque iusto eligendi non aut nobis consequatur. Aliquam aut rerum sed fugit omnis. Itaque dolores et voluptates hic earum aut ea.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Ut perspiciatis inventore quidem debitis sed cum sunt. Voluptatum autem molestias similique tempore accusantium natus. Perspiciatis dolores pariatur excepturi occaecati eveniet nisi quod quisquam.
Illo magnam magnam ut est. Quibusdam ex quos blanditiis doloremque ducimus nemo similique sequi. Expedita laborum delectus non natus cupiditate doloribus reprehenderit. Omnis adipisci aut nisi ut enim neque reiciendis. Et cupiditate natus illo corporis qui. Quas autem officia tempore sed nostrum sit molestiae.
Ullam id dolores qui commodi aliquam tempora. Unde doloribus pariatur beatae ea qui ut. Architecto quia optio in tenetur voluptas quas.