Below is an first-class video tutorial from Google for Work inward which John as well as Debbie explicate how to exercise the novel Google Sheets features. As y'all in all likelihood know, Google has late added a publish of powerful novel functionalities to Sheets allowing users to produce to a greater extent than amongst their spreadsheets. Two primary features are reviewed inward this tutorial: Explore as well as Templates. Here is a quick overview of these features from Google Docs Help page.
A- Explore
Explore allows y'all to meet automatic charts as well as analysis based on the information inward your spreadsheet. You tin gain the axe too exercise it to honour patterns inward your information as well as add together the charts straight to your spreadsheet. This is how to meet charts as well as analysis automatically on your computer
- Open a spreadsheet. If y'all desire to meet information for a specific percentage of your data, direct a gain of cells. Otherwise, y'all volition acquire insights based on where your cursor is.
- In the bottom right, hold off for the Explore icon
. If the icon is green, click it to meet recommendations as well as tips.
- If the icon is gray, at that topographic point is no analysis to meet at the moment.
- Charts as well as analysis volition appear, showing trends as well as patterns from the information inward your spreadsheet. Hover over a nautical chart to meet which information inward the spreadsheet is existence used inward the chart.
- You tin gain the axe dice on to meet to a greater extent than recommendations yesteryear selecting dissimilar parts of your data.
- To unopen the Explore panel, click the X inward the live on yesteryear correct corner.
To add together a nautical chart or formula from the Explore panel to your spreadsheet, y'all tin gain the axe drag the nautical chart or formula into your spreadsheet. You tin gain the axe too add together a nautical chart yesteryear clicking the Insert nautical chart icon
.Note: You tin gain the axe alone add together a nautical chart or formula to a spreadsheet if y'all accept permission to edit the file.
B- Templates
You tin gain the axe straightaway direct from a publish of pre-designed templates to exercise amongst your Sheets. These templates are arranged into 4 primary categories: late used, personal, work, as well as education. To access the templates gallery click on sheets.google.com as well as hence direct i of the featured templates at the live on yesteryear of the page. Or, to meet all of the templates, click More inward the live on yesteryear right.
Watch the video below to larn to a greater extent than nigh how to exercise Explore as well as Templates features. Enjoy
No comments:
Post a Comment