Google Spreadsheets - A not for profit practical example

Your the treasurer of a non profit organization and it's time to prepare the annual budget.  In years past this has been a challenge.  Your executive committee isn't the most technically savvy bunch.

A couple of them don't even have Microsoft Excel.  Of course being a number crunchier, or  at least playing one in your organization, you depend on a spreadsheet.  You spend hours in Excel getting all your formula's right and balancing the income and expenses.

Now you are ready to share.  So you email a copy to Exec members who have Excel.  You PDF for those that don't.  Off it goes and everyone has feedback.  Your VP faxes back a print out of the PDF with her changes.  By the way she can't add, but what is a zero or two between friends.  The others edit your spreadsheet and send it back, of course one forget to attach it to the e-mail.  Now how do you merge that all together make it work?  More hours adding all the changes, just to send it out again. 

Enter Google Spreadsheets; part of Google Docs.  Which is included in Google Apps for Domains,  have I mentioned I like Google Apps for Domains?

So here is what our budget looks like in Excel, you can download it if you would like.

image 
Now we need to upload it to Google Docs.  There quite few ways to do this,  but for this demo we will use the Google Docs web interface. We open our web browser and go to Google Docs for our domain.  For this demo I am using Google Docs associated with NonProfitITDept.com.  So I navigated to http://docs.nonprofitITDept.com/.  Obviously your URL will be different. 

image

Then I simply login

image

Press upload from the menu bar.

image

And here is our spreadsheet ready to be shared and edited.  The formatting was maintained, but more importantly so where all the formulas.

image

Now we click on the share tab and enter the email address of those we would like to share with. 

image

There are many more features of this application that I have not covered.  Hopefully this will get you started and can experiment with Google Spreadsheets.

Digg It!  StumbleUpon  Reddit  Del.icio.us  NewsVine  Furl  BlinkList  Ma.gnolia  Technorati