INTHEBLACK November 2023 - Magazine - Page 54
WORK SMART
EXCEL TIPS
HOW TO USE EXCEL FOR DATA VISUALISATIONS
SUBSCRIBE
to the Excel Tips
podcast
Charts and other data visualisations can identify movement,
trends and relationships better than reports alone.
Data visualisations are important because they can reveal insights
that would otherwise be hard to identify in reports. Excel can
generate charts, sparklines, conditional formats, formulas – and even
emojis. This article uses sales information from July 2021 to October
2023 as the data source for the reports. The reports compare the
current month to the same month from the previous year.
Although this example compares months, the techniques can be
applied to comparisons between any two metrics, such as actuals
versus budget.
Read the full article
Email your questions
CPA Australia, INTHEBLACK – Neale Blackwood CPA
Excel Tips: Data visualisations
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
54 INTHEBLACK November 2023
NEALE BLACKWOOD CPA,
A4 ACCOUNTING
