There are several options on the New menu when you’re in your Documents folder in your Office Live Workspace. The second option is to create a new List.
One way to think of this option is that it enables you to create a small database-type of list, e.g. a list all the DVDs you own. Or you make a list of all the towns you intend to visit on a trip along with the photos you took. By the way, for the latter you could choose to create a new workspace – one of those already set up for you to use is a travel workspace.
The list we’ll look at setting up in this tutorial is a free-form list where we can choose what columns to add and what sort of data we’ll put in each column. For example, we can have a column that contains text or we can set up a column that only contains numbers or another that stores dates.
To get started go to your workspace at http://workspace.office.live.com and sign in. Click your Documents folder and hover your mouse over the New button – you’ll see this:
Choose List from the dropdown list of choices and click to bring up the next page which starts off a new list for you:
Basically what we’re doing here is creating an online Excel spreadsheet document so if you have some experience with Excel you’ll be familiar with rows, columns and specially formatted data in cells.
The new list doesn’t yet have a name so it’s called List 1 for now. Under that line we can enter a description so we know what we’ll be using this list for.
Imagine you’re setting up a table of data, e.g. a list of your Music DVDs – you’ll need a column for the title of each DVD (e.g. Mothership), another column to store the name of the artist (e.g. Led Zeppelin), another column to record if you’ve loaded it to friends, another column to record when you loaned this DVD and another column to record that this DVD has been returned and is therefore in your home DVD library.
So let’s give this list a name and enter a description:
We now want to put a heading in Column 1 so click in the highlighted box:
Backspace and type in your own heading for this column – webDotWiz is using Title (of each music DVD; e.g. Mothership):
Clicking the arrow in the Title cell gives you the formatting options you have for the type of data we’ll be entering in each cell down the Title column. We’ll be entering text so choosing either Single line text or Multiple lines of text (for longish DVD titles) will be appropriate.
Now it’s time to add another column to record whether a DVD is a movie or a music DVD:
So click Add Column and the page refreshes to show:
The heading is ready for you to type in your own heading so do that – webDotWiz called his Movie or Music:
At this point, we can enter the title for a DVD in our library (e.g., Mothership) and we can type into the next column whether that DVD is a movie or music video. Let’s add another column – click Add Column – and enter Concert as the heading for this column:
You’ll see we’ve clicked on the arrow at the end of the Concert heading cell so we can choose a particular type of format for all the data that goes into this column – let’ls make it a Yes/No data type because we’ll be answering the question "Is this DVD a live concert?" as we make our catalogue.
You can create another column for the name of the artist or band for each music DVD and so far we’ve got our list looking like this:
You can see from the above that we’ve entered one row of data. For each DVD, we simply click Add Row and enter the data across the row under the corresponding heading so the list builds up:
Click on Save.
You’ll note that, if you have Microsoft Excel on your computer, you could load your list into Excel, add more data and save it back to your Office Live Workspace.
Another scenario is that you could share this list with a friend or workmate who doesn’t own Excel. However they could still view or edit this list (depending on your preference when you set Sharing for the document).
After you’ve Saved this list, click Close and you’re returned to your Documents folder:
Creating a new List as we’ve done here means we’ve been able to choose our own column headings and what type of data we’ll put in each.
Lists that are already set up for use for special purposes include the Task List (a to-do list), Contact List (names, addresses, phone numbers, email addresses and so on) and Event List (when the event is to be held, location, and so on).
If you’re looking for more options in types of lists, then look at the different types of workspace you can set up, each of which contains specific types of lists depending on the workspace. You can save yourself lots of time by checking out the New Workspace option.
For other tutorials to help you get started using Office Live Workspace, check the Office Live category from the front page.
This tutorial brought to you courtesy of Windows Live Writer, Microsoft OneNote, Paint.NET, Live Photo Gallery, and, of course, Office Live Workspace.