Which is better, Google Sheets or Excel Online (Microsoft’s free online spreadsheet program)? The differences are narrowing, but there is one clear winner. Many features are compared side by side in the first six minutes of the video:
00:30 – Excel Online overview
02:00 – Examples using Excel Online
03:25 – Google Sheets overview
04:30 – Google Sheets example
05:30 – Excel Online online survey and collaboration
06:30 – Opening Excel files in Google Sheets using Office Compatibility Mode
The video is narrated by Ian Lamont, author of Google Drive & Docs In 30 Minutes and Excel Basics In 30 Minutes.
Nguồn: https://blockchainvietnam.vn
Xem thêm bài viết khác: https://blockchainvietnam.vn/tong-hop/
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.