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
Oct 6
186. Quant Investing 101 feat. PGIM’s Head of Quantitative Equity, Stacie Mintz
Send us a textWhat does it really mean to be a "quant investor"? How do quantitative strategies fit into a modern portfolio? And what does it take to break into a quant investing career path?In this episode, we sat down with Stacie Mintz, Head of Quantitative Equity at PGIM (one ... Show More
53m 38s
Oct 3
185. Largest LBO Ever: EA vs. TXU, What the Govt. Shutdown Means for Markets, & Why We Should Ditch the Fed Funds Rate
Send us a textTwo days into a government shutdown, we break down what it actually means for markets when key data go dark—like today’s missing non-farm payrolls—and how that uncertainty can ricochet through trading desks, air travel, the SEC/IPO pipeline, and year-end seasonals. ... Show More
57m 14s
Sep 26
184. Quarterly Earnings: OUT?! Plus Trump's H1-B Shock, and Should We Ditch the Fed Funds Rate?
Send us a textThis week on The Skinny on Wall Street, Kristin and Jen tackle three headlines where markets and policy collide. First up: Trump’s call to shift public companies from quarterly to semi-annual earnings reporting. We lay out the real trade-offs—less bureaucracy and “s ... Show More
44m 46s
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
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
Aug 29
Big Ideas From The Art of Spending Money
Pre-order my new book The Art of Spending Money here. ***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 Pu ... Show More
10m 47s
Sep 12
Playing Your Own Game
From the archives: one of my favorite topics -- the importance of playing your own game. 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-di ... Show More
20m 20s
Aug 21
Mohnish Pabrai (Billionaire Investor): The $100 Investment Hack That's Disappearing Fast! The Fastest Way To Financial Freedom!
Is copying Warren Buffett the fastest way to get rich? Mohnish Pabrai reveals the strategy to turn 1K into 10K in 30 days, quit your job safely, build passive income, and master the step-by-step formula millionaires actually use! Mohnish Pabrai is a renowned value investor and fo ... Show More
1h 46m
Aug 2024
Should I Invest Aggressively If I Am Behind In My 50’s? - Money Q&A
In this episode of the Personal Finance Podcast, we're going to do a Money Q&A about should I invest aggressively If I am behind in my 50’s. Today we are going to answer these questions: Should I invest aggressively if I am behind in my 50s? Should I invest money? Should I put my ... Show More
33m 4s
Sep 15
No.1 Money Saving Experts: Do Not Buy A House! Putting Money In A Bank Makes You Poorer!
Are we falling for the biggest money traps of our generation? And what are the money habits that actually build millions? Raoul Pal, Jaspreet Singh, and Humphrey Yang reveal the truth about renting vs buying, escaping credit card debt, mastering passive income, and investing with ... Show More
2h 10m
Jan 2025
How To Build Generational Wealth Without A Big Salary
“True generational wealth isn’t just a home—it’s income that lasts beyond your lifetime.” This is a mindset shift we all need. Learn from Jaspreet on how to redefine generational wealth and how to create it, even if you don’t make a high salary. From owning cash-flowing assets to ... Show More
26m 12s
Aug 2024
The 10 Laws Of Investing (Andrew's Investing Rules!)
In this episode of the Personal Finance Podcast, we're going to talk about the 10 laws of investing. 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 future where your asp ... Show More
48m 32s
Feb 2025
104: Exposing Unknown Hedge Fund Strategies w/ Chris DeMuth
In this week's episode of the Rich Habits Podcast, Robert Croak and Austin Hankwitz sit down with hedge fund manager Chris DeMuth to uncover the lesser-known investing strategies of the "smart money."We discuss merger-arbitrage, 2025 expectations, and how Chris was able to profit ... Show More
45m 58s