Real Estate Skills: Excel and VBA Courses

REStudent12345's picture
Rank: Chimp | 14

Whilst recruitment only seems to be slowing (and stopped at some firms I have reached out to), I want to make this period of downtime as productive as possible. Could people recommend the best courses for Excel and/ or VBA for RE. If not general courses would be much appreciated! Please also provide a realistic timeline for a RE student to learn the courses.

Thank you in advance!

Comments (5)

Mar 17, 2020

Hey REStudent12345, I'm the WSO Monkey Bot and I'm here since nobody responded to your topic! Bummer...could just be unlucky but one of these topics will help shed some light:

You're welcome.

Mar 24, 2020

REFM would be the best in my opinion. Focus on the inputs and not the "modeling" itself. Don't waste your time learning VBA. Walk before you run, and keep "Garbage in, garbage out" at the front of your mind at all times.

In commercial real estate, it's mostly used by people wanting to waste their time to stroke their own ego. These are the same people that will spend hours working until midnight to calculate something for which their MD with 30+ years of experience told them "just use 10-12%." Understand the fundamentals of real estate, your finance classes, and proficiency-level Excel features/functions.

Mar 26, 2020

too many people try and learn VBA without grasping Excel

Also why would people even want to learn VBA when its not applicable to 98% of RE analyst gigs? To me it seems like a waste of time unless someone can prove me wrong otherwise. At the end of the day get your shit done and work hard. Listen to boss and do the grunt work. You won't be doing VBA....

Mar 26, 2020

In commercial real estate, it's mostly used by people wanting to waste their time to stroke their own ego. These are the same people that will spend hours working until midnight to calculate something....

Completely agree. My boss is one of these people. In the office until midnight switching a normal distribution to a beta distribution (whatever the fuck that is) on a forecast tool that's wrong the second it goes out the door. IMHO unless you're using a quick copy paste macro (which can simply be recorded) that doesn't require a whole lot of thought to test and implement on files that constantly get rolled week to week, month to month, etc... there's no real point.

    • 1
Mar 26, 2020
Comment