INTHEBLACK June 2026 - Magazine - Page 60
WORK SMART
EXCEL TIPS
SUBSCRIBE
to the podcast
6 QUICK AND
USEFUL MACROS
NEALE BLACKWOOD CPA
Excel’s macros are now more accessible with the assistance
of artificial intelligence. AI can help write Excel macro code
and explain any code you may not understand.
Macros have been automating Excel for decades. They can be used to streamline
a multitude of tasks. This article focuses on six short macros that save time:
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
1. unhiding all the sheets
2. entering yesterday’s date
3. red brackets format
4. delete blank rows
5. populate blank cells with zero
6. trimming spaces.
Read the full article
6 quick and useful macros
INTHEBLACK, Neale Blackwood CPA: Excel Tips — 6 quick and useful macros
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
60 INTHEBLACK June 2026
