I find your voice so relaxing. I think it's years of being stressed out over excel problems and then finding the solution in one of your videos. Thanks Bill, for making me employable and enabling me to have a good life.
I love to hear this, Stu! I've met a few people who said they've gotten good promotions at work because of their Excel skills from watching Excel videos on TH-cam. Thanks for being a subscriber!
Thank you so much for taking the time to make this video! For my purpose, I need a forecast based on a dynamic date. Is that possible with this data? It seems like it would be based on the +4 you added to the weeknum but I haven't worked it out yet. I would greatly appreciate your response!
Do you have a website that you use for getting a forecast that far ahead? If you can provide the URL of the website, I can see if this technique will work (it depends on how the weather website is set up.)
Good to know. Thank you! Why are you not using Ctrl+Enter when entering something in cells? It would be easier to immediately edit with F2 or make fewer clicks.
Hello, so I am trying to input some data for a small town but I am not sure how to go about it. Ive been using "Underground Weather". and the town is Taft, Tx. How do I go about extracting that data for this town? Thank You
How does one get all these new functionality. I have an active 365 subscription and I am on the insider preview channel,yet I don't have any of these....what is the point if I can't use it..
I share your frustration. They are being very cautious rolling these out. There are a lot of chances for errors. Microsoft doesn't want it to arrive at corporate desktops until the home subscribers have had a chance to test it out. I can report that I've found some errors in the W-A data, AND crashes happening several times an hour.
hi Bill. location data looks to be so good and i'm trying to add this as a feature for a travel planning tool however; i can't see the location data type, only stock, currency & geography. can you advise how to expand the list of data types; i'm using MS 365.
The Location data type was part of a partnership with Wolfram and Microsoft. That deal was not renewed and Microsoft removed Location in June 2023. The workaround would be downloading all data from somewhere else (Weather Underground perhaps) and then creating your own Data Type using Power Query. I have a video on using Power Query for Data Types: th-cam.com/video/z-WDstDUzyA/w-d-xo.html
@@MrXL bummer. i've been doing as you suggested but the Wolfram partnership method would have been so much easier to build in. anyway....thanks for your help. cheers
@@sjt042 I agree. However, the Wolfram data had obvious inaccuracies and Wolfram would not fix them. So, it would have been easy but potentially not accurate.
My Excel doesn't show me any kind of weather data. I can see coordinates, Mayor, population and some other but not weather. Is there any possibility to change that?
There are two icons in the Data Types for a city. One is called "Geography" and one is called "Location". The Geography does not offer weather, but Location does. Make sure you are using the correct icon. If you don't have the extra icons (they are in a section called Wolfram|Alpha, then it depends on your license type for Microsoft 365. If you have an Enterprise license, your I.T. department can disable these choices through group policy. If you do have the Location data type, trying using a nearby larger city.
@@MrXL Thanks for your quick response. Unfortunately I can only pick between Stocks and Geography. Theres no option for me to choose location or any other. Just those two. It doesn't work with a nearby larger city, sadly. Is there any option to still make it work?
It's been 2 years since this video. I still don't see a Location option under data types. Any idea if this was never fully implemented? Or if there is something I must do to add this data type? I am currently using M365 Apps for Enterprise. Thanks in advance.
The functionality was removed from Enterprise. The wolfram data had inaccuracies. Wolfram wouldn’t fix those. Many people count on Excel to be accurate. The features in this video are still in the Home edition. But I would never trust them.
Right now, you need a Home or Student subscription to Microsoft 365. Plus you have to opt in to the Beta channel of Office Insiders. Plus you have to be in the lucky 50%.
Word of warning here; The Wolfram datatypes or which the weather is one, are going away in June 2023 according to MS. Not worth investing time and effort IMO. Thats what you get when you hitch to an external source
Microsoft recently announced that the Wolfram data (including Weather) will only be available for people with a Home license of Microsoft 365. That means anyone with an Enterprise or a Education license will not be able to use Wolfram. There were a number of inaccuracies with the Wolfram data and Wolfram was unwilling to correct those. So, to me, this is no great loss. I would rather have no data instead of wrong data.
Excel 2016 is now five years old and won't have any new features. I am surprised you have Stock and Geography, since they did not debut until Office 365. Try doing File, Account. On the right side at the top, does it say Excel 2016 or Subscription Product? If you do have a subscription, then follow the steps to join Office Insiders: insider.office.com/en-us/
Right now, it is a small subset of customers. (a) Microsoft 365, (b) Home or Student, (c) Opt in to Office Insiders beta channel and (d) be in the lucky 50%. All of those have to be true. But once they get the bugs shaken out, it will become more widespread.
This was a strange situation. It rolled out to Home customers first. For enterprise customers, there is still some question about allowing your Group Policy manager to control if you see it or not.
It won’t ever be in Office 2019 nor in Office 2022. Those editions are designed for people in top secret government bunkers without Internet access. The Microsoft assumption is that if you bought the version for people without Internet Access, then these features that require an Internet connection aren’t needed. I’ve always argued that there should be a bigger warning label on the Office 2019 box that you are buying half of Excel but the marketing people at Microsoft dismiss this idea.
I find your voice so relaxing. I think it's years of being stressed out over excel problems and then finding the solution in one of your videos. Thanks Bill, for making me employable and enabling me to have a good life.
I love to hear this, Stu! I've met a few people who said they've gotten good promotions at work because of their Excel skills from watching Excel videos on TH-cam. Thanks for being a subscriber!
Guess I need to go dig up how to return current weather for sites. Great historical weather source.
Awesome Mr. Excel! Thanks for sharing these new features :)) Thumbs up!!
Glad you like them! Thanks Wayne!
Any clue to get the daily data from another year? Thanks MrExcel!
Very cool Mr. Excel!
That is really amazing!!!!! I love it : )
Had no idea. Thank you.
Thank you so much for taking the time to make this video! For my purpose, I need a forecast based on a dynamic date. Is that possible with this data? It seems like it would be based on the +4 you added to the weeknum but I haven't worked it out yet. I would greatly appreciate your response!
That's Awesome I learned so much!
Is it possible to do an episode on whether forecast for a week - a month ahead?
Do you have a website that you use for getting a forecast that far ahead? If you can provide the URL of the website, I can see if this technique will work (it depends on how the weather website is set up.)
Great Mr. Excel!
Super Cool Demo..Thank You Mr Excel :)
Data Type buttons doesn't appear for me!
Good to know. Thank you! Why are you not using Ctrl+Enter when entering something in cells? It would be easier to immediately edit with F2 or make fewer clicks.
I am an old dog and those habits are hard to break!
Hello, so I am trying to input some data for a small town but I am not sure how to go about it. Ive been using "Underground Weather". and the town is Taft, Tx. How do I go about extracting that data for this town?
Thank You
I have a different video that deals directly with Weather Underground: th-cam.com/video/CsY9yb7Fm8E/w-d-xo.html
How does one get all these new functionality. I have an active 365 subscription and I am on the insider preview channel,yet I don't have any of these....what is the point if I can't use it..
I share your frustration. They are being very cautious rolling these out. There are a lot of chances for errors. Microsoft doesn't want it to arrive at corporate desktops until the home subscribers have had a chance to test it out. I can report that I've found some errors in the W-A data, AND crashes happening several times an hour.
Isn't it a bit crappy to find out from the comments that this video is not working?
hi Bill. location data looks to be so good and i'm trying to add this as a feature for a travel planning tool however; i can't see the location data type, only stock, currency & geography. can you advise how to expand the list of data types; i'm using MS 365.
The Location data type was part of a partnership with Wolfram and Microsoft. That deal was not renewed and Microsoft removed Location in June 2023.
The workaround would be downloading all data from somewhere else (Weather Underground perhaps) and then creating your own Data Type using Power Query. I have a video on using Power Query for Data Types: th-cam.com/video/z-WDstDUzyA/w-d-xo.html
@@MrXL bummer. i've been doing as you suggested but the Wolfram partnership method would have been so much easier to build in. anyway....thanks for your help. cheers
@@sjt042 I agree. However, the Wolfram data had obvious inaccuracies and Wolfram would not fix them. So, it would have been easy but potentially not accurate.
wow...so cool!
#BUSY such a fun video : ) : )
I love the #BUSY! status. I can empathize with it. I feel like I should have #BUSY! tattooed on my forehead.
@@MrXL TRUTH.
My Excel doesn't show me any kind of weather data. I can see coordinates, Mayor, population and some other but not weather. Is there any possibility to change that?
There are two icons in the Data Types for a city. One is called "Geography" and one is called "Location". The Geography does not offer weather, but Location does. Make sure you are using the correct icon. If you don't have the extra icons (they are in a section called Wolfram|Alpha, then it depends on your license type for Microsoft 365. If you have an Enterprise license, your I.T. department can disable these choices through group policy. If you do have the Location data type, trying using a nearby larger city.
@@MrXL Thanks for your quick response. Unfortunately I can only pick between Stocks and Geography. Theres no option for me to choose location or any other. Just those two.
It doesn't work with a nearby larger city, sadly.
Is there any option to still make it work?
@@hendrikq9849 Join the Office Insider program: insider.office.com/en-us/join/windows
Wolfram Alpha functions in Excel are no longer supported in Excel! But I liked the feature.
ISOWEEKNUM - never used it before but it's handy, especially for payroll.....
This is one of those that I discovered because Formula AutoComplete now matches from anywhere in the function.
It's been 2 years since this video. I still don't see a Location option under data types. Any idea if this was never fully implemented? Or if there is something I must do to add this data type? I am currently using M365 Apps for Enterprise. Thanks in advance.
The functionality was removed from Enterprise. The wolfram data had inaccuracies. Wolfram wouldn’t fix those. Many people count on Excel to be accurate. The features in this video are still in the Home edition. But I would never trust them.
@@MrXL Thanks for the reply.
In which version of excel this feature is available
Right now, you need a Home or Student subscription to Microsoft 365. Plus you have to opt in to the Beta channel of Office Insiders. Plus you have to be in the lucky 50%.
Mr. Excel, what program are you using that shares your live image inside the body of the worksheet? Great feature!
The lastest version of Camtasia does this. My thanks to @ExcelOnFire for showing me how to do this!
It's historical data. Are there any forecast data ?
No. The Wolfram company only seems to provide historical statistics.
Word of warning here; The Wolfram datatypes or which the weather is one, are going away in June 2023 according to MS. Not worth investing time and effort IMO. Thats what you get when you hitch to an external source
🤡
Hi how to add weather option in data tab as i can see only stock and geography
Microsoft recently announced that the Wolfram data (including Weather) will only be available for people with a Home license of Microsoft 365. That means anyone with an Enterprise or a Education license will not be able to use Wolfram. There were a number of inaccuracies with the Wolfram data and Wolfram was unwilling to correct those. So, to me, this is no great loss. I would rather have no data instead of wrong data.
Oh I'm using Excel 2016 and I don't see any feature like that. No Location option. Just the stock and geography. that's it.
Excel 2016 is now five years old and won't have any new features. I am surprised you have Stock and Geography, since they did not debut until Office 365. Try doing File, Account. On the right side at the top, does it say Excel 2016 or Subscription Product? If you do have a subscription, then follow the steps to join Office Insiders: insider.office.com/en-us/
@@MrXL sorry I'm using MS Office 365 ProPlus just rechecked. no I don't have this feature.
@@Nooruddin.Nazari Follow the instructions on how to become an Office Insider at insider.office.com/en-us/
Users with Office 365 also have this feature.
Right now, it is a small subset of customers. (a) Microsoft 365, (b) Home or Student, (c) Opt in to Office Insiders beta channel and (d) be in the lucky 50%. All of those have to be true. But once they get the bugs shaken out, it will become more widespread.
Mr. Excel are these the real time data fetched from internet or values entered by you
Real time fetched from the Internet.
@@MrXL okay but these two data types are not available in my excel. What version is this.how can I get it
@@kavinmathigopal706 It is in Microsoft 365. www.microsoft.com/en-us/microsoft-365/p/microsoft-365-family/cfq7ttc0k5dm?activetab=pivot%3aoverviewtab
is this feature currently in Beta?
This was a strange situation. It rolled out to Home customers first. For enterprise customers, there is still some question about allowing your Group Policy manager to control if you see it or not.
how to enable this feature to Office 2019? thanks
It won’t ever be in Office 2019 nor in Office 2022. Those editions are designed for people in top secret government bunkers without Internet access. The Microsoft assumption is that if you bought the version for people without Internet Access, then these features that require an Internet connection aren’t needed. I’ve always argued that there should be a bigger warning label on the Office 2019 box that you are buying half of Excel but the marketing people at Microsoft dismiss this idea.
Who are you????
See: th-cam.com/users/MrExcelcomabout
oh k