Likelihood to Recommend 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.
Read full review This is well suited to someone (or a team) who are technically minded and have a dataset that they need to be able to use in many ways. It's less appropriate for a team who isn't technically minded and/or don't have the data they need to manipulate. It would be useful for things that you could use a database or spreadsheet for such as CRM, Advertising database, Business tracking, Health tracking etc.
Read full review Pros 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. Read full review Provides amazing customer service, help, examples, and explains what they are having you do The layout is easy Read full review Cons 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 Read full review Making the user permissions more obvious on how to use them - They are highly adaptable, but hard to understand how to use them Small changes such as auto colouring the choices/toggles options and being able to edit them once set. Being able to copy the formatting from one column to the next Read full review Likelihood to Renew It is easy to use, free of charge for basic functionality, and easy to share with people within or outside your team or company
Read full review Alternatives Considered 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.
Read full review Grist is easier to use, faster, and loads quicker with heavy data.
Read full review Return on Investment 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 Read full review It's saved a lot of time in both creating an advertising database and managing it week to week effectively. I had previously created in others that haven't worked, and this does, saving me a good 1 hour weekly, and 5 hours or more each time I had problems with the last ones Being able to stay on track with this has meant I'm following up at the right time (advertisers) and keeping a professional manner and not losing business due to missed communication Saving me $ from buying a program like Access (or Airtable monthly) and then the learning curve that that has. This has a much easier learning curve to say the least. Read full review ScreenShots