logo
episode-header-image
Sep 2024
1h 3m

99. Financial Modeling & Excel 101 x Mac...

Kristen and Jen
About this episode

Send us a text

Our nerdiest episode ever, and we’re darn proud of it.  Today we’re diving into Microsoft Excel and its role in Investment Banking. 

We’re discussing financial modeling, Excel culture, mechanics, best practices, and productivity enhancing tools like Macabacus, the gold standard for Investment Bankers around the world.

Kristen gives a crash course in how to set yourself up for success, answering questions like "do I need to use a Mac or a PC?", "do I need an external keyboard?", "how can I memorize shortcuts?", and of course: "how do I get faster in Excel?".

We then sit down with Macabacus founder and CEO Ryan MacGregor and Rahul Gill, Director of Product & Customer Enablement, to explore the role of productivity add-ins that will make you feel like an insider before you ever set foot in an Investment Bank. Tools like these can be the critical edge for a candidate looking to differentiate themselves and get up the curve faster than the competition.

Ryan MacGregor is a serial entrepreneur and former investment banker (Credit Suisse and Lehman Brothers), who earned an MBA from the University of Chicago Booth School of Business after serving in the U.S. Navy as a submarine officer. He founded and served as CEO of Macabacus, which was acquired by Corporate Finance Institute® (CFI) in 2021. Ryan currently heads CFI’s enterprise software division and is the driving force behind Macabacus’ business, sales, and product strategies.

For a free trial of Macabacus, click here:  https://macabacus.com/free-trial?_gl=1*s5fo4c*_up*MQ..&gclid=EAIaIQobChMIoKvq8qDBiAMV8jnUAR377wk3EAAYASAAEgJiTPD_BwE&gbraid=0AAAAA

Sign up for our Talent Accelerator HERE today!

Visit Vanta.com/wallstreet for $1,000 off

Start your FREE TRIAL of Training The Street's Turbo Macros HERE

Our Investment Banking and Private Equity Foundations course is LIVE:

Or for our "Express Workout", our one hour top 5 technicals you must know for investment banking Masterclass, purchase for $49 HERE

Our content is for informational purposes only. You should not construe any such information or other material as legal, tax, investment, financial, or other advice.

Public Disclosure: All investing involves the risk of loss, including loss of principal. Brokerage services for US-listed, registered securities, options and bonds in a self-directed account are offered by Public Investing, Inc., member FINRA & SIPC. Public Investing offers a High-Yield Cash Account where funds from this account are automatically deposited into partner banks where they earn interest and are eligible for FDIC insurance; Public Investing is not a bank. Cryptocurrency trading services are offered by Bakkt Crypto Solutions, LLC (NMLS ID 1890144), which is licensed to engage in virtual currency business activity by the NYSDFS... See full disclos...

Up next
Jun 23
167. Real Estate Private Equity 101 with MSIM's Lauren Hochfelder
Send us a textIn this long-awaited episode of The Wall Street Skinny, we’re breaking down Real Estate Private Equity with Lauren Hochfelder, Managing Director and Co-CEO of Morgan Stanley Real Estate Investing. If you’ve ever wondered what real estate investing looks like at the ... Show More
1h 5m
Jun 16
INDUSTRY S3E1 | IPOs, VCs and Founders Cashing Out, ESG and More!
Send us a textIn this episode we delve into the intricate world of finance depicted in the Season 3 premiere, "Il Mattino Ha L’Oro in Bocca" breaking down the complexities behind the IPO process, how pricing works and setting "price talk", the IPO discount and more. We also touch ... Show More
2h 20m
Jun 13
165. Biotech Investment Banking 101 Feat Sonia Gupta of Goldman Sachs
Send us a textIn this episode, we sit down with Sonia Gupta, Partner and Co-Head of Biotech Investment Banking at Goldman Sachs. Sonia walks us through her unique journey—from studying public health at Brown, to working in healthcare consulting, to getting her MBA at MIT, and ult ... Show More
1h 4m
Recommended Episodes
Sep 2024
Millionaire Diaries: How Thamina Went from $2K to $1M with a 9-5 Job
Welcome to Millionaire Diaries, where Sim chats with millionaires from the Girls That Invest community to uncover the secrets behind their success! Get ready to dive into their stories as they reveal how they turned their dreams into millions. From childhood influences to career ... Show More
37m 23s
Oct 2024
Girls That Startup: How to Become a Great Public Speaker
Welcome back to Girls That Startup, a weekly series where we spill the tea on how to create a seven-figure side hustle - because no one saves their way to wealth. You’re joined by Sim, a seven-figure business owner, and Maia, an entrepreneur in the making.This week, Sim and Maia ... Show More
20m 4s
Oct 2024
Girls That Startup: How We Manage Stressful Periods
Welcome back to Girls That Startup, a weekly series where we spill the tea on how to create a seven-figure side hustle - because no one saves their way to wealth. You’re joined by Sim, a seven-figure business owner, and Maia, an entrepreneur in the making.This week, Sim and Maia ... Show More
19m 3s
Sep 2024
Investing in Private Equity 101
This week, Sim and Maia delve into the world of private equity, exploring its history, functions, and how individuals can invest in it. They discuss the evolution of private equity from the 19th century to its modern-day implications, the role of private equity firms in acquiring ... Show More
18m 59s
Sep 2024
Girls That Startup: Why I Love Being a Lifestyle Entrepreneur
Welcome back to Girls That Startup, a weekly series where we spill the tea on how to create a seven-figure side hustle - because no one saves their way to wealth. You’re joined by Sim, a seven-figure business owner, and Maia, an entrepreneur in the making.This week, Sim and Maia ... Show More
20m 54s
Jul 7
How much money do you need to start investing?
"I don’t have enough money to invest.” We hear this a LOT. It’s a common misconception that to be an investor, you have to be earning a high income or have a chunk of spare cash, but that’s not true at all. In this episode we teach you how to get started investing on any budget.W ... Show More
17m 35s
Aug 2024
Q&A: Retirement Investing for High Earners, the 1% Rule, & the Dow Jones Industrial Average
⭐ Join the Rich Habits Network! ⁠Click Here!⁠ --- In this week's episode of the Rich Habits Podcast, Robert Croak and Austin Hankwitz answer your questions! --- 👉 Public is your one-stop-shop for all things investing! Crypto, bonds, T-bills, stocks, and more. Be sure to sign ... Show More
32m 6s
Nov 2023
A beginner’s guide to investing
Knowing how to invest is an important skill to set you on the road to securing your financial future. Getting started, however, can be overwhelming if you are a beginner. While there’s a lot of advice on the likes of TikTok and YouTube, this is something you need to be wary about ... Show More
20m 25s
Feb 2025
What to Do With $100K: Invest or Keep It Safe?
In this episode of the Personal Finance Podcast, we're going to talk about what to do with $100k invest or keep it safe. How Andrew Can Help You: Don't let another year pass by without making significant strides toward your dreams. "Master Your Money Goals" is your pathway to a f ... Show More
35m 54s
Jul 2024
How To Turn $10,000 To $100,000 Step By Step
Ever wondered how to transform $10,000 into $100,000 or even more? In this episode, Jaspreet breaks down the step-by-step process to achieve this financial goal. Jaspreet explores four different strategies: saving, investing, earning, and building your way to $100,000. He offers ... Show More
19m 28s