Tag

Video Archives - Page 2 of 3 - Google Drive & Docs In 30 Minutes

How to convert multiple Google Docs files to Microsoft Word .docx

By | Video | No Comments

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!

Google Docs: new document creation explained

By | Video | No Comments
Google Docs new document creation explained

Google Docs: how to create a new document

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.

Windows/Mac/Chromebook

  1. Open drive.google.com and log on.
  2. 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.
  3. From the Google Docs main screen: Click the “+” icon.
  4. A blank document will appear (see screenshot). You can start typing right away.
  5. 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.

Android/iOS

  1. Open the Google Docs app.
  2. Click the large “+” icon.
  3. 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 icons explained

By | Blog, Video | No Comments

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:

Topics include:

  • Main menu
  • New document
  • More actions icon
  • AZ/Sort options
  • List vs. grid view
  • File picker
  • How the Docs interface differs from Drive

How to permanently delete a file in Google Drive or Docs

By | Blog | No Comments

How to permanently delete a file or folder in Google Docs, Google Sheets, Google Slides, or Google Drive, using the new Google Drive interface released in 2015. While most people think that clicking the trash can icon for a selected file or folder in Google Drive will remove it for good, that’s not the case — it still exists in a sort of holding pen. The following two-minute video explains how to permanently delete a file or folder in Google Drive:

For more tips and tricks on how to get the most out of Google Drive, check out Google Drive & Docs In 30 Minutes, 2nd Edition.

Google Docs: How to add an image from the Internet

By | Blog | No Comments

This three-minute video shows how to add an image from the Internet to a Google Docs file, using a URL of an image from the World Wide Web. This is useful if you see an image on the Web that you want to include in a report, letter, or other document you are writing in Google Docs. Of course, only use the image if you have permission, or it’s marked with the appropriate Creative Commons or Public Domain license.

Without further ado, the video:

For more tips and tricks that can show you how to get the most out of Google Docs, check out my book, Google Drive & Docs In 30 Minutes.

How to convert a text file to a PDF using Google Docs

By | Blog | No Comments

This short video explains how to convert a text file (.txt) to a PDF using Google Docs. It’s quick, and the conversion process adds a few extra benefits that aren’t found in other text-to-PDF converters. The three minute video explains how:

Why would you want to convert a text file to a PDF? Perhaps it’s because you want someone else to see it, but you don’t want them to edit it. Or maybe you want to post it to the Web, Scribd, or some other online service.

For more tips about Google Docs, check out the latest edition of my guide, Google Drive & Docs In 30 Minutes, 2nd Edition.

How to restore a deleted file in the new Google Drive

By | Blog | No Comments

Learn how to restore a deleted file or folder, using the new Google Drive interface released in 2015. Because Google Drive doesn’t delete selected files or folders when you “remove” them using the trash can icon in the Google Drive toolbar, you can restore them. This means that old project folder or a Google docs file you mistakenly trashed can be recovered as long as you haven’t emptied the trash. The video below explains how it works:

This video is less than 2 minutes long. For more tips and tricks on how to get the most out of Google Drive, check out Google Drive & Docs In 30 Minutes, 2nd edition.

Google Sheets: How to embed a live spreadsheet

By | Blog | 4 Comments

Recently, I published Sample spreadsheet: AutoFill on the official Excel Basics In 30 Minutes website. In addition to including a sample Excel .xlsx file, I also embedded a live version of the same spreadsheet that people can edit and play with, right on the blog post. This post explains how to embed a live spreadsheet using Google Sheets, the free online spreadsheet program offered by Google. It involves a small hack, which I will describe below.

While Google Sheet’s Share button makes it easy to share a link to a spreadsheet, and allows the owner of the spreadsheet to enable anyone to edit it, editing is not possible if the embed option is chosen for the File>Publish to the Web feature.

That is, when you embed the spreadsheet on a blog post or Web page, you won’t be able to edit or format the cells, or create formulas. For example, here is an embedded spreadsheet. Notice you can highlight cells, but can’t input or change information, or use any other features of Sheets:

Google Sheets how to embed a live spreadsheet that can be edited

But there’s a workaround. Follow these steps:

  1. Open the spreadsheet, and select _File>Publish to the Web
  2. In the Publish to the Web popup, press the Start publishing button
  3. Under Get a link to the published data, change Web page to HTML to embed in a page
  4. Copy the embed code, which will look something like this:

After copying the text (Edit>Copy) and pressing the Close button, paste the embed code into a text editor or the blog editor (make sure the raw code or HTML view is showing). At this point if you publish the page, the sheet will be viewable but not editable. Follow these steps to enable live editing of the spreadsheet on the page:

  1. Go back to the spreadsheet in Google Sheets, and press the Share button
  2. In the Share with others popup, click Advanced
  3. Under Who has access, click the Change link and select On: Anyone with link
  4. At the bottom of the Who has access popup, change the Can view drop-down to Can edit and click Save
  5. The Sharing settings popup will appear. Copy the Link to share and close the popup

Now what needs to happen is most of the URL in the iframe embed code needs to be deleted, and replaced with the link you’ve just copied from the Sharing settings popup. Basically, delete everything in the quotation marks after src= starting with https:// but leave &widget=true. Then, paste in the other URL before the ampersand. I’ve highlighted the part of the iframe code that needs to be replaced:

iFrame Google Sheets URL

At that point, once you’ve published the page, the live spreadsheet will not only be visible, but it will also be editable. To see an example, visit this page on the official Excel Basics In 30 Minutes website.

If this tutorial has been helpful, please consider tweeting or sharing it elsewhere.