Locate and Download the EIA Table

Locate and Download the EIA Table

Hi, my name's Vera Cole. And this is a quick demo showing you how to locate and download the EIA Table that you're going to need for the Lesson 9 activity. Before doing this step, you should have already gone to Angel and downloaded the Lesson 9 workbook. You should have renamed that, and saved it to your computer.

What we want to do now is open that file. So I'm going to navigate over on my computer to the folder where I've saved the Cole Lesson 9 workbook. Again, this is the workbook that I downloaded from Angel and renamed.

So I'm going to open mine, you'll open yours. And when you do, you'll see that there are two tabs, Population Data, and the other one's named Analysis Questions. And this is directly just as you download it from Angel.

OK, we're going to leave this file open. It's very important you leave this workbook open. And now we're going to go to find our data on the EIA website. So let's go to the internet, and we want to type in the URL. In this case, it's

And now to find our data, we need to go under Sources and Uses, select Total Energy. Under Data you want to select Annual. And then in our Category, we want to go under Energy Overview, and here's the table we're looking for-- Table 1.1 Primary Energy Overview. We want to download it in an Excel format, so we're going to click this icon, XLS, which is going to give it to us in an Excel format. It's asking me do I want to open it with Microsoft Excel. Yes, I do, so I say OK.

Now Excel has a question for me. It's at a slightly different file extension, that's OK. So I want to say yes, I do want to open the file, and there we have it.

So this is Table 1.1 now open in Excel on our computer. This is a spreadsheet. We want to put this spreadsheet in our Lesson 9 workbook. So to do that, move your cursor over the tab, right-click and select Move or Copy.

And we want to move the selected sheet to a different book. So we're going to click here, and we say I want to move it to My Cole Lesson 9 Workbook, and I'm going to say OK. Now I'm in my Lesson 9 workbook, and now you see I have a new spreadsheet. I still have my population data, still have analysis questions. But now I have a new spreadsheet which is the EIA data.

We want you to rename that one. So again I'm going to right-click on this tab, say Rename, and I'm going to call this spreadsheet EIA Data. OK, now I'm ready to go. At this point, you're ready to prepare your Excel worksheet for analysis.