Video: How to easily automate boring Excel tasks with Power Query!
Van: Mynda Treacy - MyOnlineTrainingHub
Duur: 17:10
Inleiding tot wat je met Power Query kunt doen
Power Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button!
0:00 Introduction 0:27 Where to find Power Query 1:14 Why should you use Power Query 3:44 Power Query example - get files from a folder 6:04 Power Query Editor - cleaning the data 13:37 Close & Load Options 14:27 Building PivotTables from Power Query data 15:37 Updating with new data with one click!
Functies: -
