 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. I'm going to open mine. I'll open yours. When you do, you'll see that there are two tabs, population data and the other one is named analysis questions. This is directly just as you downloaded it from Angel. Okay, 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 www.eia.gov. And now to find our data we need to go under sources and uses, select total energy. Under data we 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 on this icon, XLS, which is going to give it to us in Excel format. It's asking me, do I want to open it with Microsoft Excel? Yes, I do. So I say okay. Now Microsoft has a question. Excel has a question for me. It's in a slightly different file extension. That's okay. 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. But we want to put this, 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 say I want to move it to my co-lesson 9 workbook. And I'm going to say okay. Now I'm in my lesson 9 workbook and you see I have a new spreadsheet. I still have my population data. I still have analysis questions, but now I have a new spreadsheet, which is the EIA data. We want 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. Okay. Now I'm ready to go. At this point, you're ready to prepare your Excel worksheet for analysis.