Search

Home > With Interest > Excel Yourself: Small data sets
Podcast: With Interest
Episode:

Excel Yourself: Small data sets
Category: News & Politics
Duration: 00:07:54
Publish Date: 2020-11-24 00:42:05
Description:

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.
Total Play: 0

Some more Podcasts by CPA Australia

200+ Episodes
INTHEBLACK O ..    
80+ Episodes
INTHEBLACK