Viewers: in countries Watching now:
Google Sheets is a feature-rich, cloud-based spreadsheet application that allows you to format and analyze all kinds of data. In this course, author Sally Norred shows you how to get the most from Google Sheets. Discover how to get around the interface, enter and work with data, and use formatting and function features, and learn smart ways to make your data work for you. Plus, see how to work with your spreadsheet data on the go with the Google Sheets mobile app.
Google Sheets allows you to publish your spreadsheet to a web page with a single click. Publishing your spreadsheet to the web allows you to share your spreadsheet for viewing with the URL address. Keep in mind that when you publish a spreadsheet, you're making that spreadsheet available to anyone on the web who has the URL. It doesn't matter if you've set the visibility to private in your Google Drive. Once it's published to the web, it's publicly accessible. Others will only be able to view the spreadsheet from the shared URL. They will not be able to edit or revise the published spreadsheet.
The original version of the spreadsheet that resides in your Google Drive will still be editable by you, and by other editors. Let me show you how quick and easy it is to publish a spreadsheet to the web. With your spreadsheet open, select File from the menu and select Publish to the web. Keep the Automatically republish when changes are made check box checked if you'd like to keep the revisions in sync with the published version. Then click the button labeled Start publishing. Click OK to confirm.
Now that you've published the spreadsheet, you'll see a link to the published document. From here, you can click and copy that link to your clipboard, and send or post it anywhere you wish. Let's see how this looks on the web. I'll copy the link, open a new browser tab, and I'll enter it in my browser address bar. Now, we see the viewable spreadsheet in a web page. The first thing you notice is that my spreadsheet had three tabs, but I see those three tabs up along the top of the screen rather than the bottom.
I can click through these tabs to see the different sheets. You'll also notice that even if I click somewhere on the spreadsheet it's not editable or selectable. I can only view the data. Editing is not possible in the published web view. Let's return to our original spread sheet by clicking the tab. And let's take a look at our sharing options for this published spreadsheet. I can copy this URL and send it to people in an email or an instant message. Or I could post this link on a webpage or blog. I could also use this embed code to embed a view of the spreadsheet on my website.
To do that, I'd copy and paste the code in to my HTML editor for my blog or website. I could also share this link quickly using Google Plus, Gmail, Facebook, or Twitter by clicking one of these icons. Once you're done publishing and sharing the spreadsheet, click the Close button. To find the link in sharing settings at a later time, or to turn off publishing the spreadsheet, click File > Publish to the web, once again. To turn off publishing and remove the spreadsheet from the web, click the Stop Publishing button. Click OK to confirm. The spreadsheet will be removed from its web page location.
If your spreadsheet is confidential or contains personal information, be cautious about publishing the spreadsheet to the web. As soon as you click Start Publishing, the data becomes publicly available for anyone with the URL
There are currently no FAQs about Google Sheets Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.