X

Tip of the Day: use functions in Google Docs spreadsheets

Whether you're using spreadsheets for work or play, Google Docs has a couple of neat tricks for pulling in data that you might otherwise spend valuable time tracking down.

Lexy Savvides Principal Video Producer
Lexy is an on-air presenter and award-winning producer who covers consumer tech, including the latest smartphones, wearables and emerging trends like assistive robotics. She's won two Gold Telly Awards for her video series Beta Test. Prior to her career at CNET, she was a magazine editor, radio announcer and DJ. Lexy is based in San Francisco.
Expertise Wearables, smartwatches, mobile phones, photography, health tech, assistive robotics Credentials
  • Webby Award honoree, 2x Gold Telly Award winner
See full bio
Lexy Savvides
Watch this: Tip of the Day: use functions in Google Docs spreadsheets

Whether you're using spreadsheets for work or play, Google Docs has a couple of neat tricks for pulling in data that you might otherwise spend valuable time tracking down.

Speaking of time, quickly insert the current date and time into a cell by typing =GoogleClock(). This will give you the current date and time from your computer, and is dynamic, so it keeps updating.

You can even translate text straight from a spreadsheet. To do so, type into a cell =GoogleTranslate("text you want to translate", "EN", "ES"), substituting the example here with the language codes of your choice. There are plenty more Google Docs spreadsheet functions that you can find by going to the Help menu and selecting Function List.

Computing Guides

Laptops
Desktops & Monitors
Computer Accessories
Photography
Tablets & E-Readers
3D Printers
Computing Coupons