INTHEBLACK October 2026 - Magazine - Page 58
WORK SMART
SUBSCRIBE
EXCEL TIPS
to the podcast
PYTHON IN EXCEL —
SENTIMENT ANALYSIS
NEALE BLACKWOOD CPA
Python in Excel allows professionals to run Python code within a spreadsheet.
In this article, learn to take that feature and perform sentiment analysis
on text feedback.
Excel works well with numbers and text, but it cannot interpret text like language-based models.
This is where sentiment analysis comes in.
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
Sentiment analysis reviews text and provides a score on the scale from negative one (-1) to positive
one (+1), with zero being neutral. Professionals can use these scores to categorise and aggregate
responses from surveys or feedback. Internal and external survey results could be reviewed
and scored to see trends over time.
Read the full article
Python in
Excel —
Sentiment
analysis
INTHEBLACK, Neale Blackwood CPA: Excel Tips — Python in Excel — part 4
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
58 INTHEBLACK October 2026
