INTHEBLACK April/May 2024 - Magazine - Page 58
WORK SMART
SUBSCRIBE
EXCEL TIPS
to the podcast
AUTOMATE REPORTS
WITH DYNAMIC ARRAYS
NEALE BLACKWOOD CPA
Creating reports in Excel has become easier, thanks
to dynamic arrays. Single formulas can populate
ranges in a process called spilling, which reduces
maintenance and shortens development time.
This article is part 2 of a series and shows how to use dynamic array
formulas to automate a standard month and year-to-date (YTD)
report with variances, including prior year comparisons. It also
enables reporting by state.
Read the full article
INTHEBLACK, Neale Blackwood CPA: Excel Tips – Automate reports with dynamic arrays
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
58 INTHEBLACK April/May 2024
UPSKILL
with CPA Australia’s
webinar on
reporting using
dynamic arrays
