Introduction to Lists

A very common use of Google Spreadsheet is to manage a collection of data ( known as a List) that are related in some way. We may have come across customer lists, that put together customer name, home / office address, phone number, email address etc. or a list of books that gives a set of details related to the title, author, price, publisher, location, availability of all the books in a book store or a stock list that gives the name of stock, sticker symbol, closing price of the day, 52-Week high and low prices, earnings per share, dividend yield etc.

Google Spreadsheet provides ways to manage such data. For instance we can store the books currently in stock and update the arrival and sale of books in the store, search for availability of a particular book in the store and retrieve the data to answer a customer’s enquiry.

Suppose you are an income investor in Canada who is primarily interested in investing in companies paying regular dividends, you may want to develop a list of such Canadian companies. Here is a partial list of such companies. For a complete list of stable Canadian and US companies who are dividend paymasters, you may want to visit this site: http://www.dividendachievers.com/

dividendachieverslist.gif

You may wonder what am I going to do with a list like this? Wait. You can use this list effectively once you have it in the form of Google Spreadsheet. In the next section we will go into the details.

<--BackTo: Chapter 4 Working with Lists

Next: Planning and creating a list –>