How to use Python in Excel for sentiment analysis

Excel's core strength is working with numbers. And we love how it makes our data work more efficiently.

However, what happens when the data is words?

Python in Excel closes that gap, allowing you to analyse short-form feedback such as customer surveys, employee comments, training feedback and help desk responses.

This episode explains how sentiment analysis works and how to combine Python with Excel formulas to create a practical feedback analysis workflow.

You will learn:

• How sentiment analysis can help analyse large volumes of written feedback

• How Python in Excel gives Excel capabilities it does not have natively

• How VADER scores negative, neutral, positive and overall sentiment

• How to turn raw sentiment scores into useful descriptions with XLOOKUP

• How spill ranges, LET, DROP, HSTACK and VSTACK extend the analysis

• Where sentiment analysis can struggle, including sarcasm, irony and jargon

• Why human judgement is still needed to interpret and act on feedback

Tune in now.

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

There is a useful companion video to go with this episode of Excel Tips.

And you can read more of Neale's Excel articles on INTHEBLACK.

You can find a CPA at our custom portal on the CPA Australia website.

Loving this content?

Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

With Interest

INTHEBLACK

Excel Tips

INTHEBLACK Out Loud

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au