Import, export, date types, and more

1. Import, export, date types, and more

Once you've added a chart to a sheet, click the More Options button on the upper right corner of the chart to edit, delete, download, publish, or copy the chart. You can also choose to move the chart to its own sheet. To make the chart public, choose Publish chart. It can be shared via a link or embedded in a website. To create a link to a chart, click Link on the Publish to the web card. A unique link will be created and displayed, which can be copied and pasted anywhere. When publishing a chart, you can choose to publish just the chart, a sheet, or the entire spreadsheet, and choose to make it interactive or just an image. Click the embed tab to create an embed code for adding a chart to a website. Again, choose to publish the chart, the sheet, or the entire spreadsheet, and whether it will be interactive or an image. Google Sheets will generate custom embed HTML code. If you're comfortable doing so, you can modify the code to add it to a website. To use the embed code, copy and paste it. Click Stop publishing at any time to disable public access to the chart. There are many ways for dates to be expressed in a spreadsheet. In Google Sheets, a cell, or range of cells, or an entire sheet can have a specific date format applied to it. To apply a format, select the data or area, open the Format menu, hover over Number, and select from the predefined date and time formats, Date, Time, Date time, and Duration. For more options, hover over More Formats, and select More date and time formats. The Custom date and time formats dialog will appear from which you can apply further customizations. You can choose from the predefined list of date and time display options. In addition to formatting, Google Sheets also has over 20 functions to display, format, or calculate a date. When you're working with datasets in Google Sheets, naming data ranges can improve accuracy and efficiency. After a range is named, it can be referenced by that name in a formula. So, instead of a formula for calculating sales results for the year being written as =SUM(A3:D15), it can be =SUM(monthly_results), which is easier to read and easier for collaborators to understand when editing a sheet. To add a named range, open the Data menu, and select Named Ranges. Alternatively, right-click on a cell or selected range, and select Define named range from the menu. The Named ranges panel will open on the right side of the sheet. Enter a name for your named range. If necessary, click to enter the range address, or select it in the sheet. Then click Done. The named range can then be referenced in formulas in the sheet.

2. Let's practice!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Google Workspace End User: Google Sheets

BeginnerSkill Level

5.0+

1 reviews

This module covers the agenda. It also introduces students to On the Rise and the course business challenge.

Exercise 1: Course introduction Exercise 2: Agenda

In this module, we will look at the different ways to share your spreadsheets with others. You will learn how to add collaborators and assign them roles and permissions, and also learn how you can share your Google Sheets spreadsheet with a link. You will understand how to transfer ownership of your spreadsheets to another collaborator, track changes, and manage versions.

Exercise 1: Share your Google Sheets spreadsheets Exercise 2: Activity 7 explained Exercise 3: Activity 7 Explore sharing options Exercise 4: Quiz Question 1 Exercise 5: Quiz Question 2