Google Sheets vs. Microsoft 365

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.

Incentivized

Microsoft 365 is well-suited for:Small and Medium-sized Businesses (SMBs): Microsoft 365 offers a cost-effective solution for SMBs to access a suite of essential productivity tools without the need for extensive IT infrastructure. It provides a wide range of applications, allowing teams to collaborate, communicate, and manage documents efficiently.Remote Work and Collaboration: Microsoft 365's cloud-based nature makes it ideal for remote work scenarios. With tools like Microsoft Teams, employees can easily communicate, hold video conferences, and collaborate on projects in real-time, regardless of their location.Microsoft 365 may be less appropriate for:Organizations with Specific Software Requirements: Some organizations may have specialized software needs that are not met by Microsoft 365. In such cases, they may require industry-specific software or custom solutions.Limited Internet Connectivity: Microsoft 365 is a cloud-based platform, which means a stable internet connection is essential for optimal functionality. Organizations with poor internet connectivity might face challenges using the cloud-based applications effectively.

• It is a cloud-based platform.
• You can work in the same file simultaneously with your colleagues.
• It allows you to share files much faster.
• It allows you to access your Google Sheet files whenever you like and wherever you like if you have stable internet connection.
• It has great integration with other Google software.
• Google Sheets is very user-friendly and very intuitive to use.

Incentivized

• keeps me extremely organized. It is so easy to link calendars, emails, and documents.
• keeps me well connected. It is so easy to send a quick message on teams or send an email to a group (for example, my particular team within the company).
• easy to use. Everything is straightforward, making it easy to find an answer to a question. There is even a search option to figure out how to do something within Microsoft.

• Pivot tables are different but could be improved upon; sort, totals, filters
• When entering negative numbers as the first in a formula you need to remember to "+-100+25" instead of "-100+25"
• The power of the internet of course makes it easy to find solution, but the help function is not easily available
• Color coding changes on the cell, but there is not an easy way to click on a cell and use the selected color; like excel

Incentivized

• Microsoft 365 really needs to work on protection part. In complex environment it is not reliable as compared to its competitors like Proofpoint. There are many instances where it fails to perform effectively.
• In SharePoint Online the versioning feature of the document needs to be improved by Microsoft. Sometimes when we have to roll back to the previous version it does not work as expected.
• In Teams messaging and app permission policies can be improved. There are some settings where we have to add a lot of things manually.

It is easy to use, free of charge for basic functionality, and easy to share with people within or outside your team or company

Incentivized

There are many features of Office that we cannot replicate in any other tool. Plus people know it already. It's not going away anytime soon.

Incentivized

The interface of the different tools (this suite has MANY different tools) is usually simple to use and intuitive, and you can always re-arrange and add or remove the task you use most frequently from the menus and task bars.

Each tool / product includes a lot of features that may require a more intensive learning, but usually Office 365 tools are simple to learn from scratch, adding more knowledge as you required more advanced features

Incentivized

Over the past 8 years of using Microsoft 365, I have noticed that they change vendors often. This always leads to a poor experience in the beginning, then levels out after some time for the company to get things worked out. As a customer, it is really frustrating because I don't have time when something isn't working to have them "look into my issue" and get back with me. They have even closed a ticket I specifically told them to keep open. Your applications are only as good as the support.

Incentivized

Everything works and I use it all the time.

Incentivized

The major reason I use Google Sheets over Microsoft Excel and Apple Numbers is for its ability to allow multiple users to access and work on the same spreadsheet at once. This is incredibly more efficient and effective than updating and sending copies upon copies of the same Excel or Numbers spreadsheet back and forth as email attachments.

Incentivized

Google Sheets is better for sharing and collaborative editing. Versioning of the same file is also one of Google Sheets strong points.

Microsoft 365 is better for working with local files. It is much easier to store the file in multiple places and backup multiple versions in multiple places.

LibreOffice is free but the usage is much counter intuitive than Microsoft Office. OpenOffice is worse when it comes to UI.

Microsoft Excel's performance with larger files is much better. When opening huge files, excel loads it asynchronously and I can start working right away.

• We've used it to prepare quick budgets, presentations for funds that have helped raise money
• It has helped us quickly analyze raw data, collaboratively.
• it has helped us work more efficiently by making it easier to work from one sheet and not lose track of versions by passing around attached documents

Incentivized

• Positively, it has increased productivity and efficiency in creating templates and being able to systemize some of the protocols we are working on putting into place.
• It has been a positive as well as most individuals and companies that we associate with also use MicroSoft 365 and therefore there is no need to have formats change in our documents when they open them up using another type of program.
• Getting work done quickly.... One and Done!!!

Incentivized