There are two ways to review survey or form responses on Google Forms. This quick video will show both methods, and describe the pros and cons of each. Google Forms is Google’s free alternative to Surveymonkey that integrates with Google Sheets and Google Drive. The video is about 5 minutes long and is narrated by the author of Google Drive & Docs In 30 Minutes.
Learn how to convert a Google Slides presentation to a PowerPoint .pptx file. The video is three minutes long and can be useful for sharing presentations with people who do not have – or cannot use – Google Slides, or to leverage PowerPoint’s superior formatting and themes. The video is narrated by the author of Google Drive and Docs In 30 Minutes.
Want to create a company letterhead or a more professional-looking invoice in Google Docs? In this quick video, learn how to add, delete, and modify a graphic logo in the Google Docs header, including resizing the logo and changing its position. This video is narrated by Ian Lamont, author of Google Drive & Docs In 30 Minutes.
How to convert an MS Word .docx or .doc document to a PDF for free, using the new Google Drive interface. It’s a three-step process, but it’s relatively quick and avoids using Adobe Acrobat or spammy online services. This tutorial uses the new Google Drive/Google Docs interface, introduced in 2015. This Google Drive tutorial is narrated by Ian Lamont, author of the top-selling technology guides Google Drive & Docs In 30 Minutes, Excel Basics In 30 Minutes, and Twitter In 30 Minutes. Leave questions in the comments, and the author will try to answer them to the best of his ability!
In less than 12 minutes, learn how to take a PDF table and import it into Google Sheets in order to change the data, create charts, or reconvert it to another format such as Microsoft Excel .xlsx. Note that it’s a complicated workaround involving other tools in the Google Suite (including Google Drive and Google Docs and text and CSV files), and will only work with simple PDF tables – complex tables, or mixed tables and other content on the PDF page can’t easily be converted to PDF using this method. This video also shows how to handle errors in the import process, such as mismatched columns and rows. The PDF to Sheets tutorial is a huge time-saver for power users, accountants, bookkeepers, MBA students, and others who want to save time with Google Sheets. This short G Suite video is narrated by the author of Google Drive and Docs In 30 Minutes.
Things may look a bit different in the latest update of Google Drive’s website interface, but the functionality is still the same … for the most part. Check out this short video to learn what is new. Narrated by the author of Google Drive & Docs In 30 Minutes.
In less than 4 minutes, learn how to print docs from Google Docs for iPhone. This iPhone video tutorial explains Google Cloud Print vs. Apple AirPrint and which one is better for easy mobile printing from your iPhone or iOS device. Narrated by Ian Lamont, the author of the top-selling Google Drive & Docs In 30 Minutes and iPhone Basics In 30 Minutes.
If the virtual keyboard on your phone is difficult to use with the Google Docs mobile app, and you don’t want to use voice-to-text dictation features of Android or iOS, you have the option of pairing a Bluetooth keyboard to your phone.
Bluetooth is a short-range wireless technology that lets people wirelessly connect their phones to other computers or accessories. Bluetooth keyboards are inexpensive and lightweight, and can easily fit into a briefcase or small backpack. For the Google Docs mobile app on an iPhone or Android phone, serious typing is only possible with a bluetooth keyboard.
After turning on Bluetooth on your Phone (via Settings > Bluetooth) and charging the keyboard, follow the manufacturer’s instructions to pair it to your phone using a special on-screen code. This only needs to be done once; afterwards the phone will automatically detect the keyboard as long as the phone’s Bluetooth is activated and the keyboard has power. The following video shows how to pair a bluetooth keyboard to an iPad running a recent version of iOS:
You can then use the keyboard to type email or use other applications, including productivity apps such as Microsoft Word, Google Docs, PowerPoint, and more. I have heard of students who can’t afford a computer using their phone and a Bluetooth keyboard to complete reports and other homework assignments using Google Docs!
If you have never owned a touch-screen device, entering text into the Google mobile apps (including Google Docs for iOS) will seem strange at first. Instead of a tiny physical keyboard (like the BlackBerry) letters and words are entered on the iPhone’s screen using a tiny virtual keyboard. The touch screen can also be used to select, copy, and paste.
Step-by-step instructions on how to use these features are shown below. Once you get the hang of it, the touch screen will seem like second nature.
How to use the iPhone’s virtual keyboard
Tapping your finger in any area that allows text input (including the cells in Google Sheets, the composition field in Google Docs, or the name field on any of the iOS apps) brings up a virtual keyboard, which covers the bottom third of the screen.
If you have never used a touch screen keyboard before, it will be awkward at first. To type a single letter, a light tap is all it takes. As you type the letter, a tiny square displays the letter being typed right above the key. This is a visual confirmation that you are typing the correct key.
Other keyboard functions include:
- Deleting a letter. Press the gray Delete button on the right side of the keyboard.
- Make a letter uppercase. Tap the shift key (upward-pointing arrow highlighted in the image below) once and then tap the letter.
- Tap the shift button once. It will change from gray to white, and the letters will change from lowercase to uppercase.
- Shift-lock. Double-tap the shift key. It turns white, and the arrow is underlined. Tap it again to switch back to lowercase mode.
- Add basic punctuation or numbers. Tap the “123” key once, which brings up the numbers keyboard (see screenshot, above).
- Add advanced punctuation and numerical operators. From the numbers keyboard, tap the “#+=” button.
- Emoji and international keyboards. Tap the globe or emoji icon next to the space bar.
How to place the cursor to add or delete text
To place a cursor on another part of the screen (for instance, to add or delete text in the middle of the sentence) follow these instructions:
- Hold your finger on the place on the screen where you want to place the cursor.
- A magnifying glass appears under your finger, showing the text and the placement of the cursor (see image, below). Move your finger down slightly to get a better view, but don’t let go.
- Move to the left or right to move the cursor.
- When the cursor is placed where you want it, lift your finger.
- Add or delete text as needed using the keyboard.
How to copy and paste text
It is also possible to select a word or phrase. Tap and briefly hold a word. The word will be highlighted, with two handles on either side and a menu above:
- Pull the handles to increase the size of the highlighted text, or select All.
- Copy or cut the text (you can paste it somewhere else later by double-tapping where you want to insert the text).
- Tap the arrow to see other options, which may include formatting and inserting photos into emails.