With Interest

Excel Yourself: Small data sets


Listen Later

Part of our Excel Yourself series about skills you should know in Microsoft Excel for your day to day use. In this episode learn about small data sets. Excel is not a database, but it can handle small datasets. These can be useful for data that isn’t available in existing databases, but is still required for reports or dashboards. This podcast looks at how to convert a data entry layout that is easy to input, into a layout that works best with PivotTables and other reports. The solution uses Power Query and is very flexible.

...more
View all episodesView all episodes
Download on the App Store

With InterestBy CPA Australia

  • 4.5
  • 4.5
  • 4.5
  • 4.5
  • 4.5

4.5

2 ratings


More shows like With Interest

View all
CommSec Market Update by CommSec

CommSec Market Update

11 Listeners

Motley Fool Money by LiSTNR

Motley Fool Money

94 Listeners

The Money Puzzle, with James Kirby by The Australian

The Money Puzzle, with James Kirby

45 Listeners

The Rules of Investing by Livewire Markets

The Rules of Investing

14 Listeners

Your Wealth by NAB

Your Wealth

6 Listeners

Australian Investors Podcast by Rask

Australian Investors Podcast

20 Listeners

Super Insider by Australian Retirement Trust

Super Insider

2 Listeners

Australian Finance Podcast by Rask

Australian Finance Podcast

29 Listeners

The Money Café with Alan Kohler by Intelligent Investor

The Money Café with Alan Kohler

34 Listeners

Friends With Money by Money Magazine

Friends With Money

12 Listeners

Chanticleer by Australian Financial Review

Chanticleer

19 Listeners

The Fin by Australian Financial Review

The Fin

15 Listeners

Excel Tips by CPA Australia

Excel Tips

1 Listeners

INTHEBLACK by CPA Australia

INTHEBLACK

0 Listeners

INTHEBLACK Out Loud by CPA Australia

INTHEBLACK Out Loud

0 Listeners

15 Minutes with the Boss by The Australian Financial Review

15 Minutes with the Boss

8 Listeners