Get 40+ Datasets for Your Data Analysis Projects

A truly insightful session. Thank you theoyinbooke 

Please is there a way of getting microsoft 365 free version. because ive not been able to practice due to unable to download the app and i dont have money now for subscrition.

@theoyinbooke 

Hello,

I still can't find the "analyse data" button on my excel. I have added the plugin, and I am an Office 365 subscriber. I don't know what's wrong or what else I need to do. Please, help. Thanks

ebohamFaith_Oseghale data_dr280 

I must confess that I'm getting to understand Microsoft Apps and Services better (than I do... Really!)

I ran into a problem as many others also did; couldn't find "import from web" on Excel (web). I tried reaching out but you will agree with me that the community is quite populated and monitoring all message is (perhaps) impossible, hence I decided to share my findings with as many having same issue.

First, Microsoft 365 (which include Office 365 Apps; Word, Excel, Powerpoint...) can be categorized into;

Microsoft/Office Desktop (the one you install on your PC)
Microsoft/Office Web App/Services (when you use it via your browser)

Is the above clear? as it will help you continue.

There are some features that aren't available yet on the web version (Microsoft/Office services/Web App), meaning you can only access them when you download and install Microsoft packages (say Excel) on your PC, unfortunately, the "import from web" is one of them.

[if you noticed @theoyinbooke used Excel Desktop to scrape the COVID 19 data in the walkthrough, though he didn't explicitly mention it (you may go back to the video to be sure]. Also, let me mention that you need to be connected to the internet (Just in case)

You may checkout Microsoft documentation to figure out the differences between the WEB (version) of EXCEL and the DESKTOP (version) here;

https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-i...

https://support.microsoft.com/en-us/office/data-import-and-analysis-options-3ea52160-08bc-45ac-acd9-...

Also, checkout my blog! I hope this helps!

Thank you so much sir@theoyinbooke

data_dr280 , this issue has been resolved. In most cases, the Excel you are using isn't that of Office 365. 

Signing in with your Developer Account will not turn it to Office 365. All you need to do is to uninstall the current version of Excel and Install directly from office portal https://office.com 

The complain is true sir. The office365 Excel on our side does not have the Get Data Tab and even analyze Data. I added the add-in already but it's not showing up. This complaint is similar to a number of us. theoyinbooke 

I was able to save the page as a .csv and imported that into Excel.

But then I won't be getting daily updates I guess... and I can't get the Power query options shown in the video to transform the data

theoyinbooke This is what pops up from that option please

theoyinbooke I also cannot find it on my Excel 365 and my Excel 2013 doesn't function the same as yours.