INTHEBLACK August 2025 - Magazine - Page 54
WORK SMART
EXCEL TIPS
SUBSCRIBE
to the podcast
PYTHON IN EXCEL — PART 2
Python, the popular programming language, is powerful
in data handling and data visualisation, and can now be
entered in an Excel cell. This article, the second of three
to be released over the coming months, will get you started
using DataFrames — an important Python concept.
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
Some things are hard to do — or impossible — with Excel’s formulas and functions.
Python can make them possible, or at least, easier. There are several different
libraries that contain pre-built functionality for specific Python tasks, from “numpy”
and “matplotlib” to “statsmodel” and “seaborn”.
This second article will get you started using DataFrames.
Read the full article
Python in Excel — part 2
INTHEBLACK, Neale Blackwood CPA: Excel Tips — Python in Excel — part 2
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
54 INTHEBLACK August 2025
NEALE BLACKWOOD CPA
