Major Updates to Google Docs Spreadsheets App - Menus, Named Ranges, Toolbar

Google Docs - spreadsheet application has introduced some major upgrades to their editor today.
Some of the key changes include:

Introduction of menus to access all spreadsheet functions / features by category: Now the spreadsheet app menus look more like Excel 2003 menus. Looks like Google is trying hard to close gap between the two applications.
Improved [...]

Web Page Monitor using Google Docs

My guest post on monitoring web page changes using google docs is posted in Digital Inspiration - one of the most popular technology blogs. Do read it to learn a little bit about using XPATH, RSS Feeds, Google Spreadsheet import() functions.
Here is a summary of the technique:

First go to the web page which you are [...]

Tracking your stock portfolio using Google Docs

By integrating services like Google Finance, Search in to spreadsheet functions, google docs has paved the way for endless possibilities.

Google spreadsheet function GoogleFinance() can be used to build stock portfolio tracker sheet that can fetch historical stock quotes to tell how your money is doing.
Click here to see the stock portfolio tracker sheet on Google [...]

Quickly process text using split() spreadsheet function in google docs

Google docs spreadsheet app is going mainstream with each passing day. Recently they have introduced split() formula to divide text in to multiple cells using a user specified delimiter.

The syntax for this function is =split(text value, delimeter), for eg. =split(”pointy haired dilbert”, ” “) would result in 3 individual cells with “pointy”, “haired” and [...]

Analyze your blog post’s readability with Google docs

How can you ensure that your blog post, term report or business case is readable without spending a lot of time getting beta reviews from others?
Thanks to google docs, you can do that with one click. Just upload your word document / txt file to google docs. Once inside, goto menu > tools > “word [...]

Want to Feed RSS to your Excel Sheet? Read this!

RSS feeds are everywhere. So much that you cannot avoid them in your data processing, analytics or day to day spreadsheet needs.
If you can get the RSS feeds to excel sheet you can do pretty interesting things with it, like:

Prepare a sheet to watch deals on Amazon, Craigslist, Deals2buy and other favorite sites
Watch news, [...]

Use Google docs to track your bucks - [spreadsheet forms idea]

Each of us have our mechanisms to track how we spend money. We use Excel, various online sites and software like Quicken or Microsoft Money to track how we spend our bucks. The bottom line is to track where each penny / paisa / cent is going. So, how great would be it be, if [...]