Posts Tagged ‘google docs’

Create Forms or Surveys Using Google Docs

November 26, 2008

Create forms or surveys using Google Docs to save you both time or money. I used to use my email marketing software http://www.iContact.com or http://www.SurveyMonkey.com but it takes you way too much time.

Advantages that Google Docs that has using forms:

  1. Show analysis and statistics from survey
  2. Publish form as website
  3. Embed form into own website
  4. Automatic spreadsheet of answers
  5. Publish answers to its own website

What kind of forms are we talking about?

  1. Pre-program questionnaire
  2. Class feedback
  3. Registrations for classes
  4. Registrations for events
  5. Open house surveys

Here is an example of the published form to send out to clients interested in living green.

http://spreadsheets.google.com/viewform?key=p5g3XfKPKBcTtMzm27LUyZw&hl=en

Here is the example in Google Docs. Feel free to copy and paste into your own spreadsheet.

http://spreadsheets.google.com/ccc?key=p5g3XfKPKBcTtMzm27LUyZw&hl=en

If you decide to fill out the form, click on the spreadsheet of answers to see how quickly the information appears.

Also, please note you could link text such as “click here to receive a 20 page PDF on green homes”

111 Ways to Save Time and Money Using Google Docs

September 27, 2008

At the Missouri Association of REALTORS Business conference this month I had the priviledge to share all of the new ways you can use Google Docs for agents, brokers, REALTOR Associations, and instructors in 50 minutes.  How do you think I shared 111 in 50 minutes?  I explain the benefits, how to create the documents and then opened up the floor to see what documents they could create, edit, and share online.  I knew we couldn’t get all of them covered so I came up with my own 111 ways to share with the group when they were stuck.  Would you know that they had some similar ideas but had some gems that I want to share with you on the PowerPoint presentation listed below.

If you have some more ways please share them with everyone by making comments

Publishing to Your Blog Using Google Docs

September 7, 2008
to

This is amazing. Anyone who has set up a Google Docs account and a WordPress blog can now post their content directly from their documents created in Google Docs. If you are the sole author, great! If you have people who will collaborate on the document, great! Anytime the document is created to in Google Docs it can appear right on your blog without having to log in to your blog administrator and copy/paste the text into your blog to publish.

Let’s take a look at some practical examples:

  1. A marketing assistant starts typing in their listings into a Google Docs document that he/she wants to appear on their blog. The assistant also invites the team leader to collaborate on the document just in case the team leader wants to make any last minute changes. Once the final changes have been approved the marketing assistant can now press one button and the document will not appear on their blog that includes, pictures, links, property information.
  2. A broker is looking at working with their agents on receiving testimonials on why their company is the best to work for. The broker starts out the templated document on Google Docs with company information, etc. and invites all of their agents to collaborate on why their broker is the best to work for in town. The broker or admin, can take the testimonial document from Google Docs and post it directly to the blog. One email is sent to the agents to collaborate. That is all.
  3. A REALTOR association is looking to set up a meeting agenda for their education committee next month. The Education Director starts out a quick few lines about past discussions in a Google Docs Document. Each committee member receives an email from the Education Director to collaborate on the agenda so that all of the hot topics and new items are discussed in the meeting. If any new items appear on the agenda the Education Director or committee chair can decide on the order or which topics to focus on. The agenda is set. Since the association posts all agendas to their blog every member can see the direction that the association is leading them to further develop member benefits.

Gadgets In Google Docs

August 15, 2008

A gadget is a tool that makes numbers, words, or phrases and turns them into diagrams, charts, maps and processes. There is no such term as gadget in Microsoft Excel. In Google Docs there is gadgets.

Example gadgets:

1. Map of addresses in a geographic location

2. Pie chart to show visual percentages of a certain group

3. Bar graph that reveals statistical trends

4. Line graph that indicate financial analysis

5. Translation from English phrases into Spanish phrases

Gadgets let you do more than what you can do with Excel. My suggestion is to create your data in a Microsoft Excel spreadsheet and upload into Google Docs. Once the data is selected choose, Insert Gadget, to determine how the data will be used in the Gadget.

Use the tools you have

Use the tools you have

Your choices are to:

1. Publish gadget within the spreadsheet

2. Publish the gadget to a new worksheet

I prefer the latter.

Play with this and have some fun. You will be able to take real numbers, addresses, names, and terms and show them in a unique way that people will understand and appreciate the creativity. Don’t forget that these spreadsheets can be published within a website or a blog.

You must be using Google Docs to create gadgets.

Create a Website for Each Client

August 13, 2008
Weave webs of communication

Weave webs of communication

Websites do not require a web developer to make changes anymore.  Google Docs allows you to create websites for FREE!  What type of websites can you create?  Let your mind wander.  Anything you create in Microsoft Office you can upload to a website using Google Docs.  All files must be saved as a 97-2003 document and meet the size requirements for each file type.

Here are 25 types.  Choose one at least:

  1. New listing flyers
  2. Marketing plan
  3. Rent vs. Own spreadsheet
  4. Postcards
  5. Listing presentation
  6. Financing alternatives
  7. Prospecting sheet
  8. Phone duty schedule
  9. Print advertising proof
  10. Buyer rep presentation
  11. Listing agreement
  12. Broker dislcosure form
  13. Seller closing costs
  14. Business cards
  15. Open house flyers
  16. Mortgage accelerator
  17. Staging tips
  18. Relocation guides
  19. Investment presentation
  20. Budget
  21. Letters to clients
  22. Listing reports
  23. Address labels
  24. Closing paperwork
  25. Calendar of marketing activities

Technology Problems for REALTOR Associations

August 4, 2008

My limited experience in working with associations has provoked me to ask staff some of the problems they face with technology.

What should I do next?

What should I do next?

Here are the top ten…

  1. The time that it takes to find important attachment someone sent them two weeks ago.
  2. Members want to help create documents and can only share them by emailing to everyone.
  3. The amount of paper that is wasted by printed documents that need to be changed in the future.
  4. Members miss new events to the because the email servers are not working correctly.
  5. The time that it takes to open up multiple programs to produce one and share one document.
  6. The number of emails addresses of members that do not work.
  7. Controlling who can make see online documents and who can edit documents
  8. Everyone haves a different version of Microsoft Office.
  9. Keeping information current that all members have access to on a regular basis.
  10. Entering information on multiple emails and websites.

Solution…

Google Docs

Ten Ways to Use Google Docs for Real Estate Education

August 3, 2008

Don’t buy any software, don’t buy any templates, don’t buy any websites when you can do it ALL for free. Contrary to the popular belief that you have to spend to make is a thing of the past. Why not save your money for the $10 beer at the ball game instead of paying 60 minutes to share on a teleconference.

Quit sending attachments and start sending links. Links do not eat up memory on the email server and get opened more consistently than attachment. Also viruses are non existent at the moment since the technology is so new. Although there are more benefits let’s get down to the details on how you can use this system to integrate into your real estate education practice.

Here are the Ten Ways to Use Google Docs for Real Estate Education

  1. Budget. Your 2009 budget may need some guidance from your close colleagues, mastermind, or accountant. Draft the most common expenses in a spreadsheet format and invite your trusted advisers to preview your budget or make suggestions on how you could better use your money. Use already designed templates or upload your existing excel or .csv file to Google Docs and begin sharing. I think you will agree that it is not recommended to publish this document to the internet.
  2. Flyers. Every seminar, class, convention, or webinar that you participate in will need to be produced in a Microsoft Word Type format. Why not upload the flyer to Google Docs and invite others to collaborate on your verbiage, style, or content so that when it is time to go live then you have people that are ready to say yes to attending your event.
  3. Creating websites. Every single document that you create in Google Docs creates a unique web page. This can be published to the internet for the entire world to see. Also if you are creating documents you can link individual pages to each other. I recommend designing a template of links that can appear either as a header or footer for you to copy and paste on to every page that you create.
  4. PowerPoint presentations. Collaborate and share your commonly used PowerPoint presentations with your group, students, and real estate commission. Instead of sending the email attachment that gets deleted more often than not send the link of the presentation. Google Docs will also let you post your PowerPoint to your own web page. For example see http://docs.google.com/Present?docid=ddtd5whr_37q5krkxhk
  5. Templates. Every school, speaker, association, or instructor has its own unique brand and color scheme that is consistent on all of their promotional materials. Create one document that contains the “header” of Microsoft Word with your business information at the top. Each time you add a new document, memo, or letter then copy the document to a new page and rename the page to title of your choice.
  6. Surveys. Surveys are the best methods to ensure you are meeting the expectations of the people that you are trying to serve. Create a spreadsheet in Google Docs and choose the form icon. Next, add the questions, answer style, and answers to the questions. Fill in the blank is also an option. Once the form is finished then you will need to set up a formula using the =COUNTIF(range,value) in the desired cells where the answers will not appear. Next create a chart from the values assigned to the answers of the questions. This data will now be used to create the style of chart you prefer. As individuals type their answers to the questions asked the values will change and so with the graph. This survey and results can appear on a website, blog, or withing Google Docs. How COOL!
  7. Registration forms. Since Google Docs will not allow for secure credit card payments to transact you may want to create a document that your attendees will want to fax in. Simply choose from one of the fax templates in Google Docs and copy and paste the basic information for registration. Add your fax number in the fax to:, add the name of the class in the subject, and fill in any of the other fields so that attendees can fill in their contact information and send it in. Snail mail is also an option but highly unlikely.
  8. Handouts. Each class that meets the needs of the kinesthetic learners will demand thorough handouts that explain complicated examples or exercises. Create and upload from Microsoft Word to Google Docs so they can then be shared. Encourage your students to download the materials ahead of time so you can save some trees.
  9. Class rosters. Create a registration form for classes or functions that do not require payment.  Do this by starting a spreadsheet in excel and choose the form tab.  Select create a new form and start adding the contact information.  This can be useful for generating email lists, phone numbers, license numbers and other important data that would be a challenge to receive individually by asking.
  10. Webinars. Webinars can now be free for the host and free for the students. This would apply to non-for profit organization and people who donate their expertise for a group in need. Create a PowerPoint presentation in Google Docs and publish it to the internet. Next choose start presentation. At the top right of the screen there will be another website that will take people to the presentation mode of your PowerPoint and allow for instant messaging. Set up a free teleconference service at http://www.InstantConference.com that gives you a number and passcode for the meeting. Generate the teleconference meeting information, website for presentation mode in PowerPoint, and email the information to your attendees. This will allow for a synchronous learning environment to communicate with the instructor over the phone and by email. If you want to enable a polling feature then pay $50 a month for http://www.zukuweb.com to allow your attendees to vote using their cell phone.

The only challenge with using Google Docs is the limitations of the service we will discuss in another blog post in the future. The main being that Google appears on everything which may effect the image of the brand. For for small business owners, the tech challenged, and those who are on a limited budget will love the benefits of participation. Stay tuned for more ideas and innovation using Google Docs.