Now Quickly Discover and Understand All Powerful Google Spreadsheets Functions

August 9, Google Spreadsheets received the following improvements that help quickly discover and understand all of the powerful functions that Google spreadsheets has to offer. All of the following improvements are now in English, and will be available in additional languages in the coming weeks, informs Michael Schidlowsky, Software Engineer.Help snippets directly in spreadsheetsTo help […]

August 9, Google Spreadsheets received the following improvements that help quickly discover and understand all of the powerful functions that Google spreadsheets has to offer. All of the following improvements are now in English, and will be available in additional languages in the coming weeks, informs Michael Schidlowsky, Software Engineer.

Help snippets directly in spreadsheets
To help you have an uninterrupt work, Google added help documentation directly into Google spreadsheets. "As soon as you start typing a formula into a cell, you'll notice an auto-suggest box with the name and syntax of the function you might be looking for. Mouse over any of the suggested functions, and you'll see a description that explains the function, its syntax, and how it's used. You'll also see links to related content and a link to the complete list of functions," explains Schidlowsky.

Auto-suggest displays syntax and help documentation for all 300+ available functions and even recognizes nested functions, making it easier to build complex formulas.

Revamped help documentation in the Google Docs Help Center
Also, the docs team has completely "rebuilt the help documentation for Google spreadsheet functions with invaluable input from some of our most active forum users such as ahab, yogia1, Ted J, A.P.L, MarinusP, and other forum Top Contributors," revealed Schidlowsky.

Here's a look at what's new:

  • A completely new table for browsing help documentation for all 300+ Google spreadsheets functions. This table is easy to browse, sort or search. To view the table, you can visit the Google Docs Help Center, click the complete list of functions link in the auto-suggest help snippets, or select Help > Function list in any Google spreadsheet.
  • Help documentation for nearly 60 new functions and formulas.
  • More detailed help documentation, including better instructions for some of our most sophisticated and complex functions.

[Source: Docs blog]