I like the Paste keyboard shortcuts which enable you to copy and paste data as text much faster than Microsoft Excel. This speeds up the workflow significantly. I feel that the copy and paste is smoother than Excel, since you can highlight, copy, delete the copied cells, and then paste somewhere else without losing that data. As far as I know within Excel, you cannot copy, delete, and then paste the data.
Compared to Excel, Sheets simplifies the process of filtering data in columns by removing extra steps, and allowing you to click the column and sort by a variety of options without only filtering the data in that specific column. I found Excel's filtering feature to require too many steps just to sort all data by one column, but this is much easier to accomplish in Sheets.
Sheets lacks many obvious keyboard shortcuts that one would think would be standard. For example, the only way to merge cells is by navigating through the dropdown menu (3-4 clicks), and then repeating the same steps each time you want to merge a column or row. While some workarounds have been found, this is not a long-term solution to the lack of basic shortcuts.
Sheets does not allow you to automatically format a number to a percentage without adding two additional decimal points (i.e. 25 becomes 25.00%, and you cannot decrease the decimal point any lower than that to just 25.0% or 25%.). This is very odd and requires you to manually add the percentage unless you want two decimals in each percentage.
What is also disappointing is the lack of customization options for the menu. You are stuck with the standard menu layout, unlike Excel, where you can pick and choose what appears in the menu. Allowing users to customize the menu would fix many of the keyboard shortcut shortfalls, and would ultimately speed up your workflow by removing excessive clicks.
Finally, the biggest issue with sheets is performance. Performance will drive you away from using this application. There are periods of time when, for any variety of reasons, performance will lag and make Sheets very difficult to navigate and use. Though performance tends to vary by browser, I found Chrome to handle Sheets the worst out of Firefox and Safari. When this happens, there's not much you can do, especially if you've checked all the obvious culprits (add-ons, browser extensions, large amounts of data, etc.).
While it lacks some basic, seemingly obvious features and shortcuts, Sheets is great for quickly creating and sharing basic spreadsheets.
We are able to easily create and share spreadsheets throughout the company, while updating them in real-time. This eliminates unnecessary email chains and duplicate spreadsheets since everyone always has the latest version. Using Google Sheets has ultimately helped us become more organized.