CRE Analyst - What I need to know for Excel

I am trying to land a position in Commercial Real Estate -- Hotels to be precise, but i'm not gonna be picky for the short-term.

I have been trying to re acquaint myself with Excel again: so far i'm working on PivotTable, IF and Vlookups.
I understand the likes of BIWS, WSP, etc but I have a few questions:

1. Can I get BIWS 2nd hand from someone?

2. Alternatively, can I just gather what I need to know from Youtube's ExcelisFun Channel? If so, what videos should I concentrate on?

3. Can you recommend the top Excel functions I should know in regards to this subject?

4. Where can I teach myself to build DCFs and valuate CRE? What other investment formulas should I know?

I do not have the financial capacity at the moment to pay for the expensive programs such as BIWS.

Thanks a lot guys!

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)
Start Discussion

Total Avg Compensation

May 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (35) $364
  • Associates (195) $233
  • 2nd Year Analyst (110) $151
  • Intern/Summer Associate (96) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (404) $131
  • Intern/Summer Analyst (330) $82