Artwork

内容由CPA Australia提供。所有播客内容(包括剧集、图形和播客描述)均由 CPA Australia 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal
Player FM -播客应用
使用Player FM应用程序离线!

How to create improved data visualisations in Excel

14:48
 
分享
 

Manage episode 407475551 series 3560917
内容由CPA Australia提供。所有播客内容(包括剧集、图形和播客描述)均由 CPA Australia 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal

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 [email protected]

  continue reading

42集单集

Artwork
icon分享
 
Manage episode 407475551 series 3560917
内容由CPA Australia提供。所有播客内容(包括剧集、图形和播客描述)均由 CPA Australia 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal

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 [email protected]

  continue reading

42集单集

所有剧集

×
 
Loading …

欢迎使用Player FM

Player FM正在网上搜索高质量的播客,以便您现在享受。它是最好的播客应用程序,适用于安卓、iPhone和网络。注册以跨设备同步订阅。

 

快速参考指南

版权2025 | 隐私政策 | 服务条款 | | 版权
边探索边听这个节目
播放