Python in Excel: Practical applications

In this second episode of a three-part series, you will build on the basics from part one to gain a clear understanding of how to use Python directly within Excel cells.

This includes using the Pandas library, for example, to merge datasets and create data-rich outputs with minimal code.

You'll gain the skills to:

• Learn key differences between Excel formulas and Python syntax

• Discover practical coding shortcuts and structure for writing Python in Excel

• Deploy a step-by-step process to create a merged table with sales and GST calculations

• Use the Pandas library to work with…