What constraints does Google Sheets have in relationship to Microsoft Excel?

Workplace licenses are pricey.

What attributes of Microsoft Office are missing out on from Google Sheets that would certainly be of value in average individual or organisation usage?

0
2019-05-07 01:25:10
Source Share
Answers: 7

I locate the lack of ability of Google spread sheets to select noncontiguous rows or columns a significant constraint, specifically when formatting a spread sheet. Key-board faster ways that will certainly work with one system yet not an additional seriously prevents my use Google docs as a whole. (That claimed, I make use of Google Documents a whole lot and also dream I can utilize it for even more.)

0
2019-05-13 17:46:25
Source

I would certainly claim both that I see are:

  • Lack of spell checker
  • Not as several graph kinds constructed in, specifically, standard graphes for supplies.
0
2019-05-13 16:57:53
Source

Besides what is currently been claimed:

Lack of message - to - column parsing.

That is, if I have a raw string like

Blah|2|4|5|www.google.com
Foo|2|1|1.2|www.twitter.com

It is unimportant to have Excel promptly do a message - to - columns on that particular, making use of | as a delimiter. Making information format as straightforward as feasible is critical to individuals that require to create or connect with information tables often.

(You can get far more imaginative with its usage ; I consistently layout facility, unpleasant information collections with simply a couple of message - to - column interations.)

Update (Evan): This isn't constructed - in attribute yet it can be included

The first strategy makes use of some spread sheet function magic

In cell B2 paste the following:

=ARRAYFORMULA(IFERROR(SPLIT(A1:A;"|")))

Then paste your information beginning with cell A2. As quickly as you enter the information it will instantly divide the mixed values to a value - per - column making use of the' |' as a delimiter.

Below is credit to the original writer of this strategy.

The 2nd strategy makes use of some scripting magic to expand Docs

Goto:

Tools -> Script editor...

Paste the following:

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [];
  menuEntries.push({ name:"Text to column", functionName:"textToColumn" });
  menuEntries.push({ name:"Text to column (custom separator)", functionName:"txtToColumnCustom" });
  ss.addMenu("Advanced", menuEntries);
}

function txtToColumnCustom() {
  var separator = Browser.inputBox("Text to column","Enter the the separator",Browser.Buttons.OK);
  textToColumn(separator);
}

function textToColumn(separator) {
  var sep = typeof(separator) != 'undefined' ? separator : ',';
  var ss = SpreadsheetApp.getActiveSheet(); 
  var c = ss.getActiveCell();
  var input = c.getValue();
  var values = input.split(sep);
  var row = c.getRow();
  var col = c.getColumn();
  ss.getRange(row,col,1,values.length).setValues(new Array(values));
}

Save and also close the manuscript editor. After that, rejuvenate the spread sheet. It'll take a 2nd to load yet you need to see a food selection called 'Advanced' popup after 'Help' in the toolbar.

To utilize it:

  • Select the cell having the values
  • Select 'Advanced' - > 'Text to column (personalized separator)'
  • When the punctual turns up enter' |' (without quotes) right into the area and also hit enter

It is magic, it'll instantly divide the values out right into columns. If you were asking yourself the non - personalized 'Text to column' function makes use of commas as separators.

This variation just works with one row at once. I have actually been doing a great deal of personalized Google Apps Scripting recently so it essentially just took around 20 - 30 mins to get this from principle to functioning. If you desire one where you can select and also divide numerous rows simply request it in the remarks or make use of the formula over.

Whatever you do, do not take too lightly the power of Google Apps Scripting. In the right-hand men, it can doing impressive points.

0
2019-05-13 16:48:29
Source

Google Spreadsheets does not have actually Pivot Tables constructed in. For any kind of significant information evaluation that can be an actual bargain breaker.

Nonetheless, it does show up that there are applications in the industry that add this capability in, as an example :

Google Apps Marketplace

0
2019-05-08 23:00:43
Source

Google spread sheets formatting is restricted contrasted to the more recent variations of Excel (2007+). I have actually located it a lot easier to create useful spread sheets with a suitable UI making use of Excel than Google Spreadsheets - every little thing I perform with the last resemble Excel 2003!

Google spread sheets does internet communication better than Excel (fetching details from the internet such as share rates, internet searches etc).

0
2019-05-08 17:28:29
Source

If you're simply seeking rows/columns to insert information, after that Google Spreadsheets are the means to go. 2 actually trendy applications for Google Spreadsheets is utilizing it to create a real-time Feedback kind for any kind of internet site (if you recognize just how to modify HTML, after that you can also take the features from the Google Form and also utilize your very own internet site's HTML and also CSS to layout the kind). Additionally, Google permits wonderful cooperation (although if you're on a neighborhood network, sharing an Excel workbook does the very same point).

A webapp that is, in my point of view, extra effective than Google Spreadsheet is Zoho Sheets. Zoho has both great VBA assistance along with pivot tables.

For anything else, sorry, yet you're mosting likely to need to fork over the cash to Microsoft.

0
2019-05-08 17:19:29
Source

I can not talk with a details constraint yet Google Spreadsheets do points in different ways than MS Excel. As an example if you require to program in succeed you will certainly make use of VBA. If you are mosting likely to program in Google Spreadsheets you will certainly require to make use of javascript.

I am rather certain that you will certainly not reach maintain your macro's when you import a spread sheet from Excel right into Google Spreadsheets. If that is a concern for you after that you could not intend to transform.

As a whole Google Spreadsheets can do a great deal of the very same points yet you might locate convenience of usage points like several of the innovative graph and also chart attributes that exist in Excel either do not exist and also have to be constructed, call for an application from the industry, or are simply tougher to make use of. Google is continually upgrading their item though so it will certainly get closer.

Given that Google applications are free, I would certainly invest concerning a 2 weeks experimenting with Spreadsheet. If you have not face anything quiting you after that you are possibly not mosting likely to have any kind of concerns.

0
2019-05-07 18:01:56
Source