METRO Blue Line-The Blue Line offers fast, frequent service from downtown to Mall of America. Trains leave roughly every 10 minutes during most hours on weekdays, every 15-30 minutes on evenings and weekends. Travel time from end to end is 39 minutes. More about riding the train.
Add a query to an Excel worksheet (Power Query). Important This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel.
Create a new Web query. Do either of the following: In Office Excel, on the Data tab, in the Get External Data group, click From Web. In the browser, browse to the Web page from which you want to query the data, right-click the Web page, and then click Export to Microsoft Excel on the shortcut menu.The New Web Query dialog box appears. In the New Web Query dialog box, enter the URL for the Web page from which you want to get data.earn more about getting external data from a Web page. You can use a Web query to retrieve refreshable data that is stored on your intranet or the Internet, such as a single table, multiple tables, or all of the text on a Web page. Then you can analyze the data by using the tools and features in Excel.