If you don't keep up with the latest features in Excel, you might end up missing out on important time-saving tools. In this video, learn how to find useful tips on how to use the new features in Excel to enhance and optimize your workflow.
- [Instructor] There's a new feature in Excel, it's called a data type. It allows us to pull in information from the internet and store it into a cell. I'd like to get some nutritional information about the fruits listed in column A. The feature we're about to show you works better when your source data is converted to a table. So I'll press Control + T and click OK. It's now a table, that's not a prerequisite, but it is a suggestion. Highlighting just the cells of interest here. I'll go to the Data tab in the ribbon and we see various data types listed. Now in the past some of you may have seen Stocks and Geography, but now this list has been augmented. I'll click the drop arrow. And this is the same list that you see down below in the green panel, in the lower left corner of the screen. For the information that's been highlighted here, we're talking about the category of food, convert to food. Click this. There's a slight pause. Excel looks at the data, figures it out, and actually has stored information in here. Now we do have a quick analysis button nearby. We can click this. I'm interested in calories and I see some lists here, calories from carbohydrates, from fat, maybe just the totals what I'm interested in, but look at some of the other possibilities here as well. So a wealth of nutritional information. I'm going to choose calories, simply click this, and we have our information. So I can do this again for column C. We can also do this in a different way in cell C2, I'll type equal and click on apple there. And we see those same choices listed differently. Here I'm interested in carbohydrates. How about the total, double click and Enter, and we've got those. We'll have to adjust the heading later. And then at a later time, we'll come back and add another fruit here. Pear, Enter, slight pause, well Excel pulls in the information and we see the calorie count and the carb count there. Another list over in column E. Here too I'll make this a table, Control + T, click OK, highlight the cells in question, just these cities here down to row 28 and here too on the Data tab. Now sometimes you have different options might want to explore his geography, what about location? Could be using either one here. Location and here this takes a bit longer and it has to analyze the data. And when data is analyzed, we'll see an icon to the left just as we did over in column A and here too same general idea, I'm interested in the populations. I'll click the drop arrow here. City population looks good, click it. We got all those populations listed. I might later want to explore some more. I could use that equal sign over in cell G2, as I did with previous example over in column A. Again we can come back and choose the quick analysis button right here, I'm interested in different kinds of income levels and there's a wealth of information here, not only about households, but also population breakouts, demographic information, ton of information here. How about the median household income. Click it, all set. Universities. This is a different kind of list because Cincinnati for example is a city and a university and Oregon is a state and university and so on, but we have this category here all set up as well. And then going to the Data tab, we see the various options there, there's university and Excel we'll make an attempt to turn all these into universities, but when it doesn't, it stops for example, on Cincinnati, I'm clicking the search button is not coming up with universities here, but I'll simply in front of Cincinnati type U-N-I-V space and that should do it, as I click the search button and it gives us different campuses. I'll just select the first one. Same general idea in Oregon too, here too. We have to hone it down or make it be a little bit more precise by putting in a corresponding word. There's University of Oregon. Arizona state lists three different campuses there, we'll pick the first one, the OSU, Ohio, Oregon, or Oklahoma State Universities. We'll pick the first one and so on. So you can see how this is working too. And similarly here we can pull in additional information about just the student count. So tons of information, if I were to lose internet access right now, I could still get additional information here because that information that we're seeing is actually stored in each of these cells here. So even when we don't have internet access, once the information has been pulled in, it is available to us. We can also build our own lists, our own data types as well. Eventually there will be additional data types. Like we see on the list here and this will grow and grow and grow and over time be refined as well. So a great tool it's called data types, available in the Data tab in the ribbon, starting with these categories right here.
- Creating charts with keystroke shortcuts
- Expanding and collapsing ribbon and full-screen views
- Display shortcuts
- Efficiently navigating between workbooks and worksheets
- Selecting entire rows, columns, regions, and worksheets
- Data entry and editing shortcuts
- Rapidly creating formulas
- Operational and formatting shortcuts
- Data management techniques