Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Most of the time the data you summarize in Excel will have been entered or copied directly into the workbook. However, if you need to summarize data from a database or an external data source, you can create a link to that other file from within Excel. In this case, I happen to have data that's stored in an HTML, or web file, so I am going to bring it in and work on it in Excel. The first thing I need to do is actually import the data into Excel. To do that, I go to the Data tab, and then in the External Data Sources group, because I'm bringing in a web file, I will click the HTML button.
If I wanted to bring in a file from the FileMaker database, I would click that. Another database program, I could click here. A text file, which I did in the previous movie, well, I could click that button. But in this case, we're working with an HTML file, so I'll click that button and start the process. So I am in the Chapter07 exercise files folder, and you'll see that the only HTML file available is highlighted here, and it's called WebData.htm. When I click it, I get my preview, and I'll click Open.
Normally this message box won't appear, but because I saved this file as an HTML file from Microsoft Excel, Excel recognizes that and says, "This file was created from an Excel spreadsheet. Do you want to work with the original file?" In this case, the answer is no, because the scenario in my head, when I created this exercise, I was assuming that you would not have access to the original Excel worksheet; instead, you would just be able to work with the HTML version of the file. So I'll click OK, because I am okay with working with this file.
And if you don't want to see this message box again, you could check this box, but I would like to see it in the future, just in case I do make a mistake and I do have access to the original file, but in this case I won't bother. I'll click OK, and Excel brings the data in. And you'll notice that it didn't bring it in to the original workbook; instead, it brought it in - change the window - to a separate workbook. So now I can save this workbook and begin working with my data. In this movie, I've shown you how to bring data from a web file into your workbook.
If you want to bring in data from a database, such as MySQL, which you'll also here pronounced as 'mysequel,' you'll need to contact your IT department to get the software you need to make that connection.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98941 Viewers
80 Video lessons · 141711 Viewers
59 Video lessons · 60059 Viewers
52 Video lessons · 73222 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.