Excel Yourself: Small data sets - a podcast by CPA Australia

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.

Further episodes of With Interest

Further podcasts by CPA Australia

Website of CPA Australia