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. The Google Explore feature leverages artificial intelligence to help you calculate, analyze and present data automatically, even if you don't know how to perform the actions required. In a spreadsheet that has already been populated with data, open the explorer panel by selecting open explorer in the lower right corner of the Google Sheet. From the top of the panel, select edit to change the cell range, and select the header row if necessary. Alternatively, click and drag to select the cells in the sheet to explore. Suggested functions will appear depending on the data selected. From there, select the drop down next to explore to see a preview of the results of the formulas apply to the selected cell range. Take some time to explore this powerful feature in Google Sheets. There are many ways for dates to be expressed in a spreadsheet. In Google Sheets, a cell, a 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 dialogue will appear, from what 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 data sets in Google Sheets, naming data ranges can improve accuracy and efficiency. After a range is named, it can be referenced by that name and a formula. So, instead of a formula for calculating sales results for the year being written as sum A3 to 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 selected in the sheet, then click done. The named range can then be referenced in formulas in the sheet.