
Sign up to save your podcasts
Or
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.
4.5
22 ratings
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.
11 Listeners
94 Listeners
45 Listeners
14 Listeners
6 Listeners
20 Listeners
2 Listeners
29 Listeners
34 Listeners
12 Listeners
19 Listeners
15 Listeners
1 Listeners
0 Listeners
0 Listeners
8 Listeners