Google Sheets Erfahrungen

I consider Google Sheets the ultimate spreadsheet app (at least from what i used until now). I really like it because it works very good and is really fast even with large amounts of data. Another great feature I really like is that the spreadsheet is stored securely in Google Drive and can be accessed from any device, this also makes sharing possible.

There are no cons for Google Sheets from my side.

The basic features of Google Sheets are very easy to use, especially if like me, you spent the first 30 years of your life on Microsoft products. Google didn't reinvent the wheel and most of the functions used in Google have identical syntax to Excel, so you won't spend time re-learning how to sum your rows or columns. If you don't need to do anything overly complex in a spreadsheet, Sheets is an absolutely acceptable alternative to its competitor

While the basic features are simple and easier. Some of the "intermediate" features require a bit of research. For example, basic conditional formatting is fairly straight forward—however, if you want to do even a little bit beyond basic, for example, look for duplicates (which is very straightforward in Excel), you need to apply custom functions within conditional formatting rules. And if you're not relatively informed or willing to sit through a YouTube tutorial, it's not going to be super clear what the correct answer is. Also, Google's customer service doesn't usually supply any help here; I've seen numerous threads between customers and Google where customers ask how to do very common tasks or ask about common features and the reply is a resounding "We don't do that.". I'm in a privileged position because I work at a company that actually teaches people how to use Google Sheets, so I have a free resource to teach myself tricks if necessary, but despite this, the syntax for "complicated" tasks is easy to forget and I do often find myself looking up the same things over and over again.

In my opinion, Google Sheets is the best sheet app on the market. The main reason I use Google Sheets is that is an online app, stored in Google account and accessible from any device. When it comes to sharing and collaboration Google Sheets is flawless.

If you are used to Excel not all formulas are the same.

I use google sheets to keep track of email lists, budgets, and to list professional opportunities. I’m a PhD student and college instructor. Google sheets is great for making quick tables of info that I can share and allow people to add their info. So, instead of having to input everything myself, google sheets allows for more crowdsourcing and collaboration. It’s also a simple looking design that’s attractive and easy to read for a wide audience.

Google sheets has many buttons and drop down menu options. Despite this, I always have to search for how to perform certain functions beyond the basics. The buttons and menu options are not very clear or helpful. It’s very confusing and takes me awhile to learn how to perform basic functions. It’s sometimes a hassle to use google sheets for this reason.

Google Sheets offers an excellent (see what I did there?) spreadsheet experience with easy team collaboration and loads of extensibility. I can share a sheet with collaborators and have easy-to-use, granular control over access levels from team member to team member, down to the individual spreadsheet cell! Google Apps Script means that if there's a feature you need that Sheets doesn't have, you can create it.

My only issue is that I can't customize the menus the way I could in Microsoft Excel. The finicky little differences in functionality between Sheets & Excel used to bother me, but that has fallen off over the years.

Sheets is almost as good as Excel, but with slightly fewer features. My favorite thing about it, though, is that it's free and automatically saves to the cloud, meaning it can be accessed by just logging into your account from anywhere with an internet connection. Also very useful is being able to share it with others and collaborate on documents simultaneously, which is great for team projects. It also has a mobile phone app which is convenient for quick, on-the-fly changes. That is mainly why I switched from Excel.

It does have slightly fewer features than Excel, but mostly ones I can live without. I'm sure there's a way to do macros in Sheets, but that requires plugins and the like and I'm not quite advanced enough to do that.

I also wish there were optional in-app tutorials on things like how to write a specific formula or whatever.

It works great in all those usual spreadsheet ways but the sharing and collaboration is really top notch and while it's a bit standard nowadays when it launched it was really revolutionary. No more emailing files back and forth or file shares with permission issues. While many of those problems can be solved with good IT practices Sheets made it out of the box easy. It really just works and it's fast to load as well.

Printing setup could be better, i know that's a compromise with the browser running the show, but it almost always takes some adjusting to get things to print out the way you want.

Mostly every SaaS and web apps has an Google sheet endpoint making it universal sheets usage platform to integrate, share and manage data in business with team and members

It has limited operation capabilities t work with multiple images... Need an inbuilt image management system

I love how simple to use Google Sheets is, that it is all online (but also with the ability to use it offline too - giving you the best of both worlds). If you have used Excel, then there is no learning curve, and Google Sheets is totally free. The collaboration is excellent, allowing you to work with clients in real-time while both updating the same document.

Google Sheets is very similar to Excel, and has about 95% of the same functionality. However, from time to time there is an advanced feature that I previously used from Excel that has no equivalent in Google Sheets. This is only for more advanced use cases, and on a day to day basis, it covers 99% of what I need to do.

I love being able to work on a project with another teammember simultaneously. This helps increase productivity and cut down on back and forth communications. Its nice to be able to discuss on a project on the phone and look through a sheet together even when video call with screen sharing is not available. I've found google sheets most helpful for tracking data on monthly events and being able to review the year on the whole.
Google sheets makes working across Mac/Windows computers much easier. Its nice to not have to worry about being able to see/access a sheet due to the other party not having and updated platform for Excel.

I caution working on google sheets together without having an agreed upon method for data management. Simple rules like 'only numbers OR only letters' in a single cell can be a good starting point. Frustrations can really rise if there is misunderstanding on general sheet management. You may find yourself documenting the same thing just on different sheets within the same sheet if you don't start with some basic rules.
Like google docs is similar but not the same as Word, so is google sheets to Excel. There are limitations to the functions in google sheets but it is an excellent starting point.
Biggest downside on the whole is being tied to an internet connection to be able to access information.

1) Accessibility: You can access Google Sheets from any device at any time and continue working on a spreadsheet. This is because Google Sheets is cloud-based and your changes are saved in real-time.

2) Adaptability: If you've used MS Excel in the past, then using Google Sheets will be a piece of cake for you.

3) Document Sharing: Google Sheets makes it possible for you to share your spreadsheet with other people so that they can review your document in real-time.

4) Sharing Security Options: Not only is the spreadsheet sharing option an amazing feature, it also allows you to apply certain restrictions to the people you share your document with. For example, you may want someone to help you compose the document. You can give that person editing rights, as opposed to the 'view only' option where he can only view your spreadsheet without editing it.

1) Internet Connectivity: Since Google Sheets is cloud-based, you're going to have to stay connected to the internet. Although you have the 'edit offline' option, you're going to have to be connected to an internet connection in case you've shared your work with someone and they are referring to it on a regular basis.

2) Confusion: There could be a lot of confusion when two people are working on the spreadsheet at the same time. However, if you're careful enough, then Google Sheets highlights the cell that each user is currently editing with different colours.

There are many things about Google Sheets that makes it incredible to use. Google Sheets implements the use of Google and has integrated google translate into the sheets mechanism. So not only do you have your basic formula letter values you get to enter you can also create quick translations into a sheet. By this I mean you can have a column of English and for example, the Japanese quickly translated into another column. This makes the whole system so much quicker and easier to use.

Now Google Sheets already does the basics of what Excel would have, but with MORE. Google Sheets also can be used to make worksheets, data and charts, graphs and more. The only thing is it sometimes takes a lot of trial and error to get used to the commands and everything else that is needed to get the hang of it you just need some practice and guidance since there is so much that you can do with it.

Sometimes it is difficult to get a hang of google sheets because at times it feels as though there is a little too much going on and at times it is difficult to get a good print out because the sheets would not come into the framing properly. So there really isn't a good boundary system with the Google Sheets system. Also, it is all connected to the cloud and internet, but it can be hard to have a proper save of your Sheets if anything with the internet goes wrong.

What I like most about Google Sheets is that it shares most of the same features as MS Excel. However, the best part is that it's free. I also like how easy it was to set up and use. It's also very easy to collaborate and share files with my team. I use Google Sheets to track sales calls, leads, expenses, etc. Another added benefit is that it's all on the cloud. So accessing files is a breeze. This makes more sense for me to use than other alternative. Furthermore, Sheets can do almost everything that Excel can. In fact, I don't plan on using Excel anymore. With all of the features that Google keeps rolling out, it's only a matter of time before they catch up to Excel.

Truthfully, there really isn't anything that I don't like about Google Sheets. I mean, what is there to complain about, it's free. Google is always rolling out new features so the longer you use it the better it will get. If I had to pick out one thing, it would be the formatting. I ran into some trouble formatting and duplicates. However, I was able to find a solution on YouTube. The reality is that it will likely take you some time to get used to the functionality, but that's to be expected. Once you take the time to learn the basics the rest comes easy.

The ease of use, the fact that there is infinity undo’s, a timeline of all the changes youve made to the document, the query function as well as the importrange function make this product the most versatile program out there. In my opinion its a mix of excel, and database software wth a very nice ease of use.

I wish this software would allow to lock some cells from being able to be modified by the creator of the document. I think thats just nitpicking though cause its difficult to find flaws.