Google Sheets

How robust it is for an online application and how good it can handle complex formulas and allow you to online-share and live work with coworkers when analyzing data. Also the options to export it as an .xls and mobile app offerings that can allow me to keep track of the ranges of application data I need to use. You can share the links with permissions and if you're in a group/organization you can also keep the files safe for coworkers. Exporting is great too for working with Excel and same with importing excel documents.

Sometimes the mobile offering can lack a bit. It's mostly based for basic data viewing and nothing too heavy and complex. Same with trying to open the link on an mobile phone. If there's a lot of tabs with data, it can be really laggy and take a while to load. Also sometimes importing stuff from Excel won't show appropiately because they are Microsoft propietary so keep in mind when importing excel spreadsheets.

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.