A few months ago, I created a video series on Udemy called Google Drive & Docs In 30 Minutes. The series mirrors most of the book I wrote about Google Drive and Docs, but has the advantage of being really visual. In this post I will be sharing one of the foundation videos that explains the Google Drive interface. It’s less than 6 minutes long. Enjoy!
I recently tried out the new Google Forms while writing an update to Google Drive & Docs In 30 Minutes. The new interface is a lot slicker than the old version of Google Forms, and gives more control over the look and feel of the forms. It’s a great way to create an online survey, or have people enter data for a variety of purposes. It’s also worth noting that Google Forms has been partially decoupled from Google Sheets, meaning it’s possible to create a form directly from Google Drive and see the results within Google Forms, instead of having to open up Google Sheets. This post will show what the new Google Forms interface looks like, and then give a brief Google Forms tutorial.
Google Forms is a tool to build online forms, which can then be emailed, shared on social media, or embedded on a public-facing website. The forms can really change the way you gather data. Think about it: Instead of manually entering data, you can make a simple form or survey, post it on the Web and let other people do the work for you! This tool is perfect for signup forms, surveys, and simple reporting.
Once a form has been created, it can be accessed via a Google link that you can email or post on a social network. The form can also be embedded on a blog or company Web page. Customization options can make the form look more professional, or match the fonts and colors you want to use. The data from the form is only visible to you and designated collaborators (as described in ).
The Google Forms tutorial below applies to the updated interface for creating new forms, which was rolled out in late 2015 and early 2016 for some users. I expect it will be rolled out to most Google Drive and Docs users later in 2016.
How to create a form
- You can either use an existing spreadsheet (select Tools > Create a form) or make a new form from Google Drive’s main screen by pressing the New button and selecting More > Google Forms.
- The form editor appears (see screenshot, below).
- Enter the title.
- Enter the description. Make it clear what the form is being used for, and add any instructions that can help people complete the form. Absent context or appropriate instructions, users may be reluctant to use the form, or they may enter the wrong type of data.
- Edit the first untitled question. Change the name of the question by clicking on the title. Change option labels by clicking on them. Select different question types from the drop-down menu labelled Multiple choice. Select Required to force users to answer a question.
- Add a new question using the Add question There are more than a half-dozen types of questions that can be used.
- Short answer. A one-line text field.
- Paragraph. Allows for longer answers.
- Multiple choice. Create a multiple-choice question, with as many possible answers as you want.
- Checkboxes. People can check off one or more items from a list.
- Dropdown. Creates a drop-down menu.
- Linear scale. Users choose from a range of numbers.
- Multiple choice grid. Users fill in data according to a table.
- Date or Time. Users can select the date or time (useful for scheduling purposes).
The form builder has additional functions:
- Icons allow form creators to add titles, sections, photos, and video.
- Change the colors used in the form by clicking the easel icon.
- Preview the form by clicking the eye icon.
- The settings icon (look for the gear) controls who can use the form, as well as presentation options. Use the drop-down menu to select Anyone or one of the other options, if available.
When complete, click the Send button, which shows various distribution options. Email is the default choice, but social media icons, Web links, and embed code (which can be used to insert the form into a blog post) are other possibilities.
Data entered into the Web form can be accessed via the Responses tab at the top of the form editor. Click the Sheets icon to flow the data into a new or existing spreadsheet, which can then be formatted, sorted, filtered and otherwise manipulated. To return to a form, search for it in Google Drive or visit https://docs.google.com/forms.
I hope this Google Forms tutorial was useful. For more information, check out the updated version of Google Drive & Docs In 30 Minutes.
Here’s the situation: You write all of your reports, letters, invoices, and fiction masterpieces in Google Docs. There are scores of Docs files in your account, but now you need to convert the Google Docs documents to Microsoft Word .docx. Why? Maybe you want to apply special formatting to the files (Microsoft Word is far better than Docs when it comes to formatting). Or you need to share them with someone else who doesn’t use Google Docs, but does have MS Word. Here’s how to handle the conversion of multiple Google Docs files at once, without opening the files and converting them one by one.
The method basically involves selecting (but not opening) multiple Google Docs files in Google Drive, and then using the “download” option, which auto-converts them to MS Word .docx. The following video shows how to do it:
For more information, tips, and tricks related to Google Drive and Google Docs, check out my book!
Last month, I demonstrated the new Google Docs interface for the Web. This month we’re going to take a look at one of the most common actions in Google Docs — how to create a new document. There are a few ways to do it. The post below describes Google Docs new document creation in a browser (Chrome) or an iOS/Android mobile device. There is a also a short video that shows how to create a new document in Google Docs.
- Open drive.google.com and log on.
- From the Google Drive main screen: Click the New button on the left side of the screen. You will see different formats to choose from. Pick Google Docs.
- From the Google Docs main screen: Click the “+” icon.
- A blank document will appear (see screenshot). You can start typing right away.
- To change the name of the document, click the default “untitled” name at the top of the screen.
The document is now ready for you to add text, pictures and other elements. You can type some text to get started. There is no “save” function—Docs auto-saves as you type.
To close the document and return to the Google Docs home screen, tap the blue icon with white lines in the upper left corner.
- Open the Google Docs app.
- Click the large “+” icon.
- Enter a name for the document.
You can now begin typing or adding other elements to the file. To close the document and return to the Google Docs home screen, tap the blue icon in the upper left corner of the screen.
Google Docs new document creation video
The following video demonstrates how to create a new document in Google Docs. There are two easy ways to do it. This 2-minute video shows how:
Google Docs has a new stripped-down interface. It may look modern, but it can also be puzzling to people who are new to Google Docs and Silicon Valley software design standards. What do all of the icons do, how can users find what they are looking for, and how is the Google Docs interface different than Google Drive? The following short video explains it all in just 4 minutes:
- Main menu
- New document
- More actions icon
- AZ/Sort options
- List vs. grid view
- File picker
- How the Docs interface differs from Drive
So you have a report or letter or some other document that you’ve been working on in Google Docs, and you want to convert it to a PDF. The following 90 second video shows how:
For more Google Docs conversion tips, check out the videos on this site or download/purchase the latest edition of Google Drive & Docs In 30 Minutes.
In the following quick video, learn how to make a pie chart in Google Sheets, using the new interface released in 2015. This covers the basics of creating a pie chart, but the instructions apply to bar charts, line charts, etc. It assumes the data used to create the chart is valid — for instance, if it’s a pie chart the values should add up to 100.
The video is just two minutes long, and starts below:
For more tips about Google Sheets, including conversion between Microsoft Excel and CSV formats, and how to use the Sheets app for iOS and Android devices, check out Chapter 3 of Google Drive & Docs In 30 Minutes.
The following video covers formatting basics in Google Sheets, using the Google Sheets toolbar. Bold, text color, fill color, and other options are demonstrated. The instructions apply to the new version of Google Sheets on a PC, Mac, or Chromebook:
Note that formatting options are far more limited on the Google Sheets app for iPhones, iPads, and Android devices.
For more tips and tricks about Sheets, check out the latest edition of my guide, Google Drive & Docs In 30 Minutes.
The following short video shows two methods for renaming a spreadsheet using Google Drive or Google Sheets. Both are quick ways to update names, or get rid of the default “untitled spreadsheet” name that is given to all new spreadsheets. Here’s the two-minute video:
For more Sheets tutorials, check out the latest edition of my book, Google Drive & Docs In 30 Minutes.
How do you add an image from your hard drive or desktop to your Google Docs file? There are actually several different ways to do it, and the video below (just over 2 minutes long) shows all three:
For more useful tips and tricks about Google Docs, Google Drive, Google Sheets, and Google Slides, check out my latest edition of my book, Google Drive & Docs In 30 Minutes.