Google Sheets is the spreadsheet app available on Google Workspace, or standalone, with a free plan for personal use and accessible via mobile apps for iOS and Android.
N/A
Microsoft Excel
Score 8.7 out of 10
N/A
Microsoft Excel is a spreadsheet application available as part of Microsoft 365 (Office 365), or standalone, in cloud-based and on-premise editions.
Google Sheets is a great tool mostly for people in the finance department such as accountants who have to analyze hundreds of transactions. The software makes it easy to organize data and handle some analysis. Also, when it comes to data presentation, Google Sheets offers some of the best features. However, this is not to sat people outside the finance docket cannot benefit from this software. It is a great tool to have when handling data.
I find it easier to use than Google Sheets , though it's easier to collaborate with other teams using Google Sheets. I also feel like Microsoft Excel is more suited to deal with complex formulas. The best way to put it, if I have a project that I'm solely working on, I'm going to use Microsoft Excel. If it's going to be shared, then I'm using Google Sheets.
Shifting to Sheets after years and years of Excel is like learning to crawl after I've been running for years. Some sort of translator document. Such as if you use XYZ in Excel, the same function can be found here in Sheets
Functionality shuts down after 5K or so lines are used. I work in finance. We have hundreds of thousands of transactions we need to analyze.
If Big Query is the answer to large amounts of data, it needs to be as easy to use as Sheets is.
Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.
I am not involved in the purchase/selection process, but my organization is a Google shop, and Sheets meets most of our spreadsheet needs and works seamlessly with our other tools. I don't anticipate our switching anytime soon.
Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.
Overall the formula functions could improve but there's workarounds for them. Utilzing different formulas or approaches for building out accounting schedules. While collebrating with multiple team members and different departments being able to go in and see where others are on the sheets is helpful. Google Sheets overall is a great product
Overall I think the usuability is great and offers everything it should. I have never not be able to use it for what I wanted it for. However, it is so detailed and offers so much it can be difficult to use. Better descriptions or explanation to all the information could be helpful
Like most Google products, Google Sheets rarely has outages or slowness, and when it does, connection is always momentarily restored. I can't recall a time when I've been unable to access Google Sheets but able to access other sites just fine. That said, errors aren't uncommon when handling large data volume. You know what they say about using spreadsheets as databases, but sometimes it's just the most convenient option, especially for smaller or one-off projects, and not being able to store large amounts of data hampers our ability to move quickly with scrappy prototypes or full solutions. It would be great if we could better integrate our data manipulation (Apps Script) with big data in the sheet.
Again, Google Sheets is no exception to Google's general high speed and reliability, but load times can be slow for larger amounts of data. I've used Sheets with Zapier and have used the Python API, and speed has never been an issue.
I have never contacted Google Sheets support, but Google Sheets makes it very easy to report an issue or suggest a feature from Sheets itself (Help > Help Sheets improve), and I've had mostly good experiences with support for other Google products.
Microsoft Excel and Numbers on Mac. Used the first reiteration of the Windows 365 and was terrible. It stacks up well against excel due to power of two other Google products 1) Google search and 2) YouTube. If you cannot find an article or video to help you might be disappointed but keep looking.
Excel is one of the tools I use for everyday work but fits alongside all the other programs I use. I keep Excel as a way of tracking projects from start to finish as well as document content strategy and audits. There are not many programs like Excel that I can think of other than Google Sheets and I find Excel is far better.
Google Sheets works very well with multiple users. It's convenient to see in real-time who is collaborating in a sheet, down to the specific cell that they're viewing/editing. Linking Sheets across departments is convenient with the IMPORTRANGE function.
Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise
It helps to me gather my thoughts, organize my research, and most importantly prioritize information in an easy to digest manner depending on what I am most interested to see at that time.
It helps me quite a bit to talk my clients through the financial implications of various office leasing transactions under consideration and coach them in a way that is very unbiased and fact-driven which I like.
It helps me to be more thoughtful as well when thinking about the various different situations in which I use Excel. And because it ultimately results in my clients getting comfortable ultimately pulling the trigger on a given deal, it directly leads to more commission in my pocket which I love!
