Excel Online vs. Google Sheets

hi there. I believe there are filters in Excel Online. may be a new feature but I am sure there are filters now available. Click on "format as table" in "Home" tab and there they are.

Has this changed at all in 2020? Has Excel Online become anymore sophisticated?

good

Hi Ian. I'm hoping that you might be able to help me out. I'm in an online investment group and I was chosen to help create a spreadsheet that lists roughly 200 stocks. I'm currently using Google sheets, with many of Google's IMPORTXML functions, pulling multiple bits of info, from several different websites – dividend info, expense ratios, market caps, etc… As you may have guessed, I'm getting way too many #NA, in random cells. I've read that I can only import so many IMPORTXML codes per sheet, so I thought I could create a bunch of individual sheets, with 25 or so codes per sheet, then have my main sheet import info from these individual sheets. I hope that makes sense. For instance, my main sheet will have cells that retrieve info from sheet2!F13, for example. I have roughly 66 sub-sheets that the main sheet is pulling data from. I guess my question is – if I chose to use Excel, instead of Google Sheets, will I be running into that same #N/A issue? Does Excel allow me to import data like Google Sheets' IMPORTXML function? I'm trying to eliminate having to keep chasing these #N/A. Any help or advice would be greatly appreciated!!

hi, nice video,
can i ask some more,
how many cell limit for google spreadsheet and excel online?
which is faster to work when there is so many data?
which is run faster to run with javascript?
and which is have better security?

yes, we spent all our money in Fortnite so we are seeing what we can get for free, thank you!

Best comparison ever!!! You show the true about these two without being a Google or Microsoft fanboy. Take my like and share.

Add-in A-Tools in Microsoft Excel is better Google sheet!!!

This is old version

Your beef with Excel online is it doesn't have a "filter" button? Format the data as a table, which Sheets cannot do, and and filter away. Also, you get the added benefits of using structured references that come along with a table.

Who wins ?

Hi which video have you showed please how to copy excel values and formulas in docs please?

You can also layer shapes to make beautiful spreadsheets on google sheets as well!!!

How do I make google sheets landscape instead of portrait

I have an excel document that has been emailed to me
I do not have excel on my computer I refuse to pay for it
Would I still be able to open it in excel online or in google sheets

I struggled to embed an editable sheet into a blog…Google Sheets was not great for this..but Excel Online sheet..great.

Great info!

Sigma!

Dude,

Video is informative but you missed the part, you didn't actually convert the excel file to google spreadsheets but just opened in office accessibility mode. Once uploaded to google drive, excel can be converted to google sheets n you can achieve almost all the stuffs. This is happening since ages

4:13 That's the Greek letter Sigma. Epsilon looks exactly like E.