课程: Excel: Power Query?(Get & Transform)

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Query data from another Excel file

Query data from another Excel file - Microsoft Excel教程

课程: Excel: Power Query?(Get & Transform)

开始一个月试用 购买团队方案

Query data from another Excel file

“

It is possible to import data from another file. In this situation, we have survey data from a magicians conference, specifically the mentalism sessions. We've got survey results from Tuesday, Wednesday, Saturday. We've got averages being calculated. There's a lot happening. And let's say you and I are concerned about the food and venue results. Well, there's a lot to clean up. Like column C is empty. We've got these averages. We don't want those. We can calculate those when we need them. The main thing is to get a lot of stuff out of our way so that we can do our analysis. Now, what if we go straight forward and right-click, Get Data from Table/Range? I don't have all of my data. All right. Cancel this out. Here's what I am going to do. I'm going to go to File, blank workbook. All right. I don't like gridlines. I want to minimize this and then close the survey results and then go back to Book 1, Data, Get Data, From File, From Excel Workbook. Import survey data. Double-click that…

内容