Date, time and number patterns i Google spreedsheet

Formatting dates, time and numbers in a Google spreadsheet is very simple using the Text() method - like this

=TEXT( NOW() ; "yyyy" )

but it's only simpel if you know the different format patterns ;) They are not very well documented but there is a spreadsheet out there with all the answers. Go here

http://goo.gl/lUUo4

I'm sorry but I know who to give credit for creating all this information - but he/she should have a medal.

Presentations in Google Docs gets a big update

Google has updated presentations in Google Docs/Apps. New features include:

• Transitions to move between slides with simple fades or spicier 3D effects
• Animations to add emphasis or to make your slides more playful
• New themes to create beautiful presentations with distinct visual styles
• Drawings to build new designs, layouts, and flowcharts within a presentation
• Rich tables with merged cells and more options for adding style to your data

For now you need to change your settings to enabled the new features - go to your Document settings and click "Create new presentations using the latest version of the presentation editor."

When creating a new presentation you should be able to use the new features:

Source