Hi, this is Wayne again with a topic “Using the Excel Data Types Tools”.
In this article, i’m going to show you how to use the excel data types tools. As you can see, i have three spreadsheets in this workbook one with a list of u.s states, one with a list of countries and a third with a list of just a few companies jumping back to the us states spreadsheet. I want to point out that in microsoft, 365 versions of excel – and that includes windows, mac online and perhaps some other versions of excel. Also, if you go to the data tab and look in the data types group, you should see stocks and geography if you’ve seen those and wondered what they are. What they’re for this video is for you, but basically what these buttons do is they enable you to easily and quickly pull in information about stocks and also about geography? Now, if you don’t see the data types group on the data ribbon, something to check is go to file and go down to account and make sure that you’re signed in here at the left that you’re signed into onedrive and that you have that connection. It’S not enough just that you’ve activated microsoft. 365.
You have to be signed in to your online onedrive once you’ve done that you should see stocks and geography in the data types group on the data ribbon. Okay, let’s take a look at how this works. I’M going to click a to select the entire column, a the whole list of us states and then i’ll just go over here and click geography and what happens is i get this interesting little card that appears here at the left of each of the states.
Now, if i click on a state, i get a little button that pops up. That lets me insert data about alabama. In this case. Maybe i’m interested in the median household income, so i click it and there it is. I could do the same for alaska. Just click on the cell that has the card click the pop-up button, median household income.
There we go now. In most cases, this isn’t going to be good enough, you’re not going to want to just pull in information about one or two of the items in the list. Instead, typically you’ll want information on all of them, so i’m going to undo to take away the cards that were placed there and now i’m going to select column a insert table, click, ok, and now that this is a table watch what happens when i again select A go to data select geography.
Now, yes, i get the cards again. I get the button, but now this button works for all of the items in the table, so i’ll click the button i’m interested in media and household income. I get a warning that it may take some time: that’s okay! I just clicked. Ok and it’s now pulling in information on household income about each of the 50 states in the united states, and this is being pulled from the internet. It’S current information! Now i get another pop-up button here, so i can click that and choose something else that i’m interested in okay, maybe the largest city. Again, i’m getting the warning, i’m going to check this box, don’t show this message again.
I understand it’s going to take a little time and there we have the largest city as always in excel. If the information doesn’t fit inside the column, i can just double click between the column, letters. So, between c and d i double clicked, and it’s now the perfect width and the popup button appears again how about persons per household. That sounds interesting to me, so i select it and now that information is going to be added to this spreadsheet. So this is a great way to build a spreadsheet quickly. Anytime, your spreadsheet has anything to do with geography.
It can be for cities for states for countries and so on now. Another thing you can do with this is you can click on the actual card symbol here at the left and look what it does it gives you basically an overview of, in this case the state of arizona i get the flag. I get the capital city, the current leadership of the state and on and on and on all sorts of information.
The data comes from wikipedia the us census and perhaps other sources as well all right. Let’S try the same kind of thing, but with countries i’ll click column, a i’ll go to insert to turn this into a table. Click, ok i’ll, go to data and click geography. It looks like it worked. It’S added cards next to all of the countries that it recognized. It looks like i have some mistakes in my list of countries, and so some of these it couldn’t understand and it put a question mark next to them, but just like with the states, i can click on the card here at the left to see an overview Of the country, and then i can click this button that popped up to select the information that i want to display in the spreadsheet i’ll just pick one more how about birth rate and it pulls in that information. Now, let’s move on to the third spreadsheet in the workbook stocks, stocks work similarly insert a table. Click: ok go to the data tab, but this time i’ll click, the stocks, button, excel searches for and tries to identify the companies in my list now in the case of ebay, it’s having some trouble over here in the data selector panel. They have some suggested results to choose from and a lot of these look good i’ll, just click this one here and now it has fixed the error that was there, i’m going to double click between a and b to make sure the information fits in the column And then i can click this symbol here, the add column pop-up button and then i can go down and choose the information. I would like to display how about the number of employees in the company and i’ll pick one more i’ll go to the current price of their stock, and there we go now, especially in this case. It might have been better instead of me, selecting the entire column.
A i probably should have just clicked and dragged to select the six companies that are listed here. The reason why is because it’s trying to fill in this information all the way down as far as my table exists, and that is overwhelming, excel a little bit. But hopefully you can see the potential in using the stocks and geography buttons in microsoft excel in the future. Hopefully more data types will be added into excel thanks for watching. I hope you found this tutorial to be helpful. If you did please like follow and subscribe, and when you subscribe click the bell so you’ll be notified. When i post another video, if you’d like to support my channel, become a supporter through my patreon account and you’ll see a link to that in the description below .