Import and Transform CSV File with Power Query: In this tutorial, we will create a beautiful looking map with data coming from a CSV file. All in just a few clicks! You will learn to use Power Query to:
1) Import info from CSV
2) Clean the data
3) Group by the data to aggregate the information
4) Use the map feature in Excel (2019 and onwards)
Content: import csv in power query, excel filled map chart, excel dynamic map, excel power query extract text, group by in power query excel, grouping text values using group by in power query, import csv file to excel sheet, use power query to create a map chart, how to load csv file in excel, csv file in excel power query, power query transform and group by, transform and group by in excel, import and transform csv file with power query, extract data from csv file with power query
#Excel #MsExcel #powerquery
Ещё видео!