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
Aug 20
176. The TRUTH Behind Who REALLY Controls Rates Plus The SPAC King is Back & Europe’s Yield Curve Warning
Send us a textThis week on The Skinny on Wall Street, Kristen and Jen dive into the resurgence of SPACs and yes, Chamath Palihapitiya, the once-dubbed “SPAC King,” is back with a brand-new deal. We unpack what a SPAC really is, why they exploded in 2020, changes in the new struct ... Show More
49m 26s
Aug 19
175. How to Protect Your Wall Street Career from AI
Send us a textWorried AI will take your Investment Banking job? There's no avoiding AI these days, so how do you understand it, use it to your advantage, and outperform it in Investment Banking and high finance roles?We asked our community for their toughest questions about the f ... Show More
36m 3s
Aug 16
174. Canaries in the Coal Mine? Perplexity's $34bn bid for Chrome; Fed Cut Fallout, and Private Credit PIK Concerns
Send us a textThis week, Kristen and Jen dive straight into the finance headlines with a M&A story: Perplexity, an AI startup valued at $18 billion, has made a $34 billion all-cash bid for Google Chrome. Kristen unpacks why this is virtually unprecedented in dealmaking, explainin ... Show More
57m 29s
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
Aug 15
Investing: The Greatest Show on Earth
Thanks to my friends at Public.comAll 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 Investi ... Show More
12m 14s
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
Jun 2
Is there a 'right' way to invest?
What can history teach us about investing? Is there a right way? Russell Napier—financial historian, author of The Anatomy of the Bear, and founder of the Library of Mistakes—shares what centuries of market behavior reveal about asset allocation, financial repression, and why eve ... Show More
1h 11m
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