Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Tuesday, 9 August 2011

Making Google spreadsheet functions easier to discover and use

Posted on 10:00 by Unknown
From the simple SUM function to GoogleLookup, Google spreadsheets continues to add features that help you power through data. But sometimes it can be a challenge to find the one you need to use or figure out the right way to use it. We’ve made the following improvements to help you quickly discover and understand all of the powerful functions that Google spreadsheets has to offer.



Help snippets directly in spreadsheets

You shouldn’t have to interrupt your work to figure out how to build a particular formula, which is why we’re bringing 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.





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

We’ve also completely rebuilt our 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. 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.
All of these improvements are now in English, and will be available in additional languages in the coming weeks. So take advantage of these new resources at your fingertips and you’ll be a Google spreadsheets ninja in no time.



Posted by: Michael Schidlowsky, Software Engineer
Email ThisBlogThis!Share to XShare to Facebook
Posted in Google Apps Blog, googlenew, spreadsheets | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • Docs on the iPhone with Chris Pirillo
    Posted by: Meredith Whittaker, Program Manager Chris Pirillo , Gnomedex Conference founder, CNN.com Live technology contributor, and one of ...
  • Writing a campaign speech with Google Docs
    A few months ago, my colleague Julia and I were at a technology conference for educators. Teachers were very enthusiastic when we demonstrat...
  • Google Now for Google's Homepage in Testing
    It looks like Google Now won't be limited to Android, iOS and Chrome , it will also be added to Google's homepage. Some code from a...
  • Google spreadsheets, now with discussions
    Getting things done with others would be much easier if everyone was sitting right next to you. But since that’s rarely the case, we’re alwa...
  • Collect audience input with Google Sites & Moderator
    Google Moderator helps anyone find the best input from their audiences, whether it’s suggestions on how to stop the oil spill , debate que...
  • Get Docs in 38 languages
    Posted by: Ken Norton, Product Manager, Google Docs Earlier today we launched Google Docs in 13 more languages, bringing our total number of...
  • View .doc attachments right in your browser
    Cross posted on the Gmail blog If you receive Microsoft® Word files as attachments in Gmail, you can now view them with a single click -- no...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ▼  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ►  September (10)
    • ▼  August (11)
      • Access Google Docs with FedEx Office Print Online
      • This week in Docs: Page numbers in documents and o...
      • The Google Docs app for Android now with Web Clipb...
      • How I use Google Docs as a student
      • The Google Docs team beats the heat at our summer ...
      • Better control in Google Sites with page-level per...
      • Making Google spreadsheet functions easier to disc...
      • Give your templates a refresh in the new document ...
      • Try out a new look and keyboard shortcuts for your...
      • Use new Google spreadsheets charts in your documen...
      • This week in Docs: Copying drawings and better rig...
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ►  2010 (118)
    • ►  December (11)
    • ►  November (16)
    • ►  October (6)
    • ►  September (13)
    • ►  August (13)
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ►  February (6)
    • ►  January (6)
  • ►  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ►  October (10)
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ►  February (7)
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile