Python just arrived in Excel, here is everything you need to know

The expectation from us, the finance pros, is that we need to do much more than just keep spreadsheets in order.

We’re expected to dive deep into data, build financial models, and predict what’s coming next.

Excel has been our go-to for years, but let’s face it - handling big datasets or automating complicated processes can feel a bit limiting.

That’s where Python in Excel steps in.

As of now, Python is built right into Excel. You get the familiar Excel interface, but now, with the power of Python to manage more complex tasks, analyze huge datasets, and automate things we used to do manually.

If you’re in finance, this is a game-changer. It’s like taking your Excel skills to the next level, making your work faster and more efficient.

In this edition, I will share with you the first steps of learning how to use Python in Excel and show you a way to master it.

Here is what we'll cover:

1. Free invitation to my next webinar on AI for Finance
2. New video on how AI is going to impact Fractional CFOs
3. Python just arrived in Excel
4. Offer of the week: 70% off on the Python in Excel for Finance guide
5. Freebies of the week

Enjoy!

Nicolas

1. Finance AI webinar: the crawl, walk, run playbook

If you want to learn how the best finance teams use AI to maximize their impact, this is the right place for you.

Here's what will be covered:

• Crawl: Understand the foundational impact AI can have on finance. Learn how to ask the right questions and create effective AI prompts.
• Walk: Leverage generative AI with your data and integrate user-friendly, off-the-shelf AI tools into your daily operations.
• Run: Accelerate your finance processes by using generative AI to code, create predictive models, and even build custom GPTs tailored to your organization’s data.

Join me on October 8, 2024, at 1:00 PM ET as I will discuss with Dave Wiesenseck, Ramp's first-ever Expert-In-Residence. ?? Secure your seat now!

2. Video of the week: AI for Fractional CFOs

Michael King, the number one coach for Fractional CFOs, invited me to discuss about the impact of AI on Finance, Accountants and Fractional CFOs.

Enjoy the video:

3. Python Just Arrived in Excel (Continue learning here)

Python just became available in Excel, and here, I will reveal why using Python in Excel is a crucial skill to learn if you work in finance.

Python’s integration with Excel is more than just a new feature - it’s a breakthrough for finance professionals. With Python, you can easily handle larger datasets that would typically slow Excel down.

This allows for more efficient data processing using powerful libraries like pandas and NumPy.

Repetitive tasks like updating reports or reconciling data can now be automated, freeing valuable time for more strategic work.

When it comes to complex financial models, Python simplifies advanced calculations such as Monte Carlo simulations or risk models that would be difficult in traditional Excel.

The integration also enhances how we present data. Python’s robust libraries, like matplotlib and seaborn, provide better options for customized and clearer visualizations, making it easier to communicate insights to stakeholders.

Beyond that, Python expands Excel’s limitations, offering tools for more advanced analysis that Excel’s built-in functions just can’t handle.

In addition to all this, Python brings machine learning capabilities directly into Excel, allowing you to create more accurate forecasts and predictive models for revenue, expenses, and market trends- going far beyond traditional methods.

Here are some of the key libraries that finance professionals can leverage within Excel include:

• pandas
• NumPy
• matplotlib and seaborn
• scikit-learn
• Faker
• statsmodels

Keep learning why these libraries are important and how to install Python in Excel in my website article.

?? Continue learning how to use Python in Excel

4. Special Launch Offer

The First Python in Excel Guide

Are you tired of Excel's limitations?

Excel alone is great, but it wasn’t built for forecasting and machine learning.

This makes you probably spend too much time on manual work for forecasting, missing out on insights and faster results.

If you're still doing repetitive tasks in Excel or struggling with large datasets, you're leaving time and efficiency on the table.

Imagine cutting down hours of work by automating those time-consuming processes, all while performing more advanced analyses. That’s exactly what Python in Excel can do for you – and now, it’s more accessible than ever.

This new integration gives you the power to scale your work, automate your reports, and take financial analysis to the next level. And the best part? You don’t need to be a coding expert to start.

That's why I partnered with Christian Martinez, one of the biggest experts on AI for finance, to create the "Python in Excel for Finance" guide and help you join the top 1% of finance professionals who are already using it.

Here's what you get with this guide:

• 50+ pages of easy-to-follow instructions
• 10+ finance-specific use cases like advanced financial modeling and automation
• Step-by-step modules that take you from setting up Python in Excel to creating powerful visualizations and machine-learning forecasts

This guide isn't just another boring theoretical PDF.

It is a tool that will transform your work and make you more valuable to your boss.

And you can get it now and save 70% off!

As this guide is unique and new on the market, you are the one who has the chance to have prime access to it with a discount of 70%.

However, this special launch offer will be available only this week, and the opportunity to learn how to use Python in Excel is something you don’t want to miss. Get it now!

?? Click here to boost your excel skills with Python and get the guide now!

5. Freebies of the week

Download now

100 Productivity Tips

Download now

If you found value in this week's edition, just drop me a note ;)

Nicolas

P.S.: This unique guide is created based on our experience teaching the Advanced ChatGPT for Finance course, where we deep-dived into how to use Python for finance. Now is the chance for you to take advantage and learn this invaluable skill as Python became available in Excel. Use my special launch offer and get the guide by saving 70%!