How to create improved data visualisations in Excel
Excel Tips1 Marras 2023

How to create improved data visualisations in Excel

If you're looking for ways to display diverse types of data using Excel's charts and visualisation tools, this podcast, loaded with tips, will show you how.

The example in this episode compares one month's data from this financial year with the corresponding month from the previous fiscal year.

For fast access, use these timestamps:

  1. Column charts: 2:13
  2. Variance charts: 3:22
  3. Recommended charts: 4:23
  4. Cleaning up charts: 5:24
  5. Moving Labels: 6:58
  6. Sparkline charts: 7:51
  7. Waterfall (bridge) charts: 8:44
  8. Conditional format - data bar: 9:45
  9. Making charts for accessibility: 11:01
  10. Conditional format – icons: 11:28
  11. Emojis 😍: 11:28

Tune in now.

Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au

Tämä jakso on lisätty Podme-palveluun avoimen RSS-syötteen kautta eikä se ole Podmen omaa tuotantoa. Siksi jakso saattaa sisältää mainontaa.

Jaksot(50)

Create interactive Excel charts

Create interactive Excel charts

Wouldn't it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays?  This expert-led episode introduces the core techniques behind fle...

3 Elo 7min

How to create accounting reports with DAX

How to create accounting reports with DAX

From trial balances to profit and loss statements, reporting sits at the centre of modern finance.  This episode explores how finance professionals can use DAX (Data Analysis Expressions) formulas a...

1 Heinä 9min

Why Excel macros still matter in 2026

Why Excel macros still matter in 2026

Excel macros are far from obsolete. And here's why.  This episode explores why VBAs (Visual Basic for Applications) still play an important role in workflow efficiency for accountants and finance pr...

1 Kesä 9min

Template tips to boost workflows

Template tips to boost workflows

Most finance professionals have made this mistake at least once.  You open last month's file, update the numbers, hit save, and only then realise you should have saved it as this month's version of ...

1 Touko 7min

Increment dates easily in Excel

Increment dates easily in Excel

What if you could simplify Excel date calculations with one powerful custom function?  Well, this episode explains how.  You'll learn:  How to handle different date increments including days, ...

1 Huhti 7min

Master your messy data

Master your messy data

Messy, unstructured data.  It slows reporting, creates errors, and tests everyone's patience. Right?  This episode breaks down how the new Regular Expressions (REGEX) work and how they help you fi...

2 Maalis 6min

Build Better Excel Models

Build Better Excel Models

You may know The Seven Habits of Highly Effective People as a cornerstone of modern business thinking.  But what happens when those same principles from this book are applied to one of the most wide...

2 Helmi 12min

Smarter, faster, easier: Here's what's new in Excel

Smarter, faster, easier: Here's what's new in Excel

Excel Tips Summer Season Encore presentation from October 2025 In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance...

1 Tammi 14min

Suosittua kategoriassa Liike-elämä ja talous

sijotuskasti
mimmit-sijoittaa
psykopodiaa-podcast
rss-rahapodi
hyva-paha-johtaminen
ostan-asuntoja-podcast
pomojen-suusta
rss-inderes
rss-startup-ministerio
rss-sami-miettinen-neuvottelija
rss-karon-grilli
rss-laakispodi
rahapuhetta
rss-seuraava-potilas
rss-levosta-kasin-yrittajyys
rss-3-vinkin-podcast
rss-wtf-markkinointi-by-dagmar
rss-porssipuhetta
rss-uskalla-yrittaa
rss-ammattipodcast