digest
Welcome to Excel 2013 Statistical Analysis video number three. Hey, in this video I'm looking up at my ribbon tabs and I don't see Power Query. Now, I'm teaching this class at Highline College, and although the computer labs don't have it installed yet, they will have it, and I want to show you how to install it on your computer because it will help us immensely in transforming data. Remember, this is a statistics class, but it's a statistical analysis class, and what are we analyzing? Raw data. So Power Query is going to help us a lot.
Just like our last video, where we installed the Data Analysis Tool, it's super easy. However, the Power Query add-in is not automatically in Excel, but it's as easy as this. Let's go to Google, and I'm simply going to type "download Power Query." I can't type, so I'm going to down arrow and then enter, and there it is. Right there, we click on this link. Now, when we download this, you are going to have to decide which type of computer you have, 32-bit or 64-bit. How do you know which one you have? I'm going to show you a great keyboard shortcut to get to the Control Panel with all your system information. You have to find the Windows key, which is between Control and Alt, and then the Pause/Break key, which is up in the right-hand corner. Watch: Windows key plus Pause/Break gets you right to the Control Panel, and here it is. It'll tell you right there. I have 64-bit; you may have 32-bit. All right, I'm going to click on this one. Next, it simply wants to know where it's going to save this add-in on your computer. This is just the install part, so I'm going to click the Desktop and save it there. Now, it appeared down here because I'm using Chrome. If you need to get to your desktop, Windows key plus D to show the desktop, and then wherever it is, double-click and open it, then click Run.
I have Microsoft Excel open, so you have to close it. I've closed it, and now I'm going to click Finish. You've got to be kidding me, it's that easy. Now I go back and open up Excel, go up to File, just like our last video, then down to Options, just like our last video, down to Add-Ins, just like our last video when we did Data Analysis, except for now, down in Manage. You don't want Excel Add-in; you want COM Add-ins. I click COM Add-ins from the dropdown, I click Go, and now I check Microsoft Power Query for Excel, click OK, and look at that, there it is. Now, we're not going to use it here, but later we'll use Power Query to import data, and it makes our job so amazing. Remember, what are we analyzing? Raw data. So being able to get data in with Power Query is the best tool available.
One last thing about the ribbons that you see here in my Excel: you don't have to have Developer, Inquire, or Power Pivot. Those are extra ribbons I have. But Home, Insert, Page Layout, Formulas, Data, and our Data Analysis right here that we added last video, Review, View, and Power Query. All right, we'll see you next video.