Hey Bill. It was great hosting you here in Albuquerque! Everyone had a great time and learned a lot! We look forward to your next visit to the Land of Enchantment. - Tom Downey
Hi Mr. Excel.. way cool.. we're now drowning in data we didn't even know we needed.. haha!. Can think of all sorts of ways to use this in business. Thanks for the great video. Thumbs up!
Great stuff, thanks! I'm loving all the new features in this version. Someday I may even get to use them at work! Quick question--did you use Excel or another tool to scrape the Twitter thumbnails?
Long ago, the Microsoft MapPoint program had an API for this. But that program was discontinued in 2014. Excel doesn’t natively support this. Any solution most likely would use calls to Google Maps API but I haven’t seen anyone do this from Excel.
Hey @MrExcel, great video! I got a problem with this feature of Excel though: when I convert the zip codes to geography data it looks as if it's been successful, however I don't get the insert column button to extract the cities and I can't pull up any cards for the cells. How do I fix this?
Same case for me; I asked about that few months ago and the answers was that the feature was just delivered to Office Insiders. The last news about that from James Spotanski is : Data types are available to 100% of Office Insiders, and 50% of the Monthly Channel (Targeted) ring so we still have to wait to get the feature ready for all the users. You can read the entire discussion here techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Stocks-and-Geography-New-Data-Types-in-Excel/ba-p/176185
Hey Bill. It was great hosting you here in Albuquerque! Everyone had a great time and learned a lot! We look forward to your next visit to the Land of Enchantment. - Tom Downey
Thanks Bill. I have been waiting for these new data types to rollout to my Office 365 to no avail. I will dig deeper as they will be very useful.
Hi Mr. Excel.. way cool.. we're now drowning in data we didn't even know we needed.. haha!. Can think of all sorts of ways to use this in business. Thanks for the great video. Thumbs up!
mine is showing a very limited data which is also a 365 excel but in your video there are many information. can you tell me why?
So amazing - AND: Thanks for the really fun video!!! I should I been on Twitter so I could have seen my Oakland, CA!!!!
These are great features...thanks for the video!
Great stuff, thanks! I'm loving all the new features in this version. Someday I may even get to use them at work! Quick question--did you use Excel or another tool to scrape the Twitter thumbnails?
I've had the new version of Excel in Office 365 for 2 weeks and I still don't have the Data Types section.
i cannot find the tab in data or in other hands there is no option of stock or geography, how can i find it?
great stuff .. wondering how to mass calculate travel time/road distance between two cities just like this.. possible?
Long ago, the Microsoft MapPoint program had an API for this. But that program was discontinued in 2014. Excel doesn’t natively support this. Any solution most likely would use calls to Google Maps API but I haven’t seen anyone do this from Excel.
One thing I couldn’t figure out is how to change a geo type it got wrong.. any ideas?
This *just* happened to me. Right-click the cell, choose Data Type, and Change. A panel opens on the right where you can search for the correct item.
Except now I don't have that choice anymore. Type a new value in the original cell and it should update.
Hey @MrExcel, great video! I got a problem with this feature of Excel though: when I convert the zip codes to geography data it looks as if it's been successful, however I don't get the insert column button to extract the cities and I can't pull up any cards for the cells. How do I fix this?
Bill, This is great stuff. And if winter comes, can spring be far behind? When shall we see your presentation on the other data type: Stocks?
I am not sure. I have a nice backlog of 30 videos that I want to create. Stocks are in there. But I don't know when they will bubble up to the top.
@@MrXL No sweat Bill. Take it easy.
How does one find source and date of Geographic data?
Does it work with zip codes(US)/postal codes (Canada)? If you put those then can you get the city and state/province?
what version of Office 365 is this in
This is great stuff. Can we get a video on the stock feature there too? Thanks.
My Office365 ProPlus dont have that Data Type option..
Same case for me; I asked about that few months ago and the answers was that the feature was just delivered to Office Insiders. The last news about that from James Spotanski is : Data types are available to 100% of Office Insiders, and 50% of the Monthly Channel (Targeted) ring so we still have to wait to get the feature ready for all the users. You can read the entire discussion here techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Stocks-and-Geography-New-Data-Types-in-Excel/ba-p/176185
Bayburtu Excel bile bulamıyo :))))
that is soooooo cool!!
👍