INTHEBLACK June/July 2024 - Magazine - Page 56
WORK SMART
SUBSCRIBE
EXCEL TIPS
to the podcast
2 DIY FUNCTIONS
THAT USE LAMBDA
NEALE BLACKWOOD CPA
Learn how to create custom Excel functions using
LAMBDA, which can help to simplify complex
formulas and provide reusable solutions that
work across multiple files.
This article looks at two custom functions that can help with
accounting calculations – summing spill ranges, and handling
financial years, months and quarters.
Read the full article
INTHEBLACK, Neale Blackwood CPA: Excel Tips – 2 DIY functions that use LAMBDA
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
56 INTHEBLACK June/July 2024
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
