Human Tech - Fantabulous Google Sheets Tools For Assessment Together With Grading

July 29, 2015
Google Sheets add-ons shop has a multitude of fantabulous educational apps teachers tin employ to heighten their productivity in addition to meliorate their classroom workflow. Today nosotros spent one-time wading through these extensions in addition to curated the listing below. This is a collection of about useful add-ons to assist yous alongside the assessment in addition to grading of your students work.

1- Flubaroo

‘Flubaroo is a FREE summation to Google Forms/Sheets which lets yous speedily degree in addition to analyze pupil functioning on multiple pick in addition to fill-in assignments. Within a infinitesimal you'll hold out able to:

  * Get scores for each student, in addition to pose students inward demand of extra help.
  * View average score, in addition to a histogram of scores.
  * Quickly pose questions which a bulk of the students missed.
  * Email students their scores, along alongside optional notes to the course of instruction and/or to each student.
  * Assign your ain score to open-ended questions.’

2- Doctopus

‘Doctopus gives teachers the mightiness to mass-copy (from a starter template), share, monitor pupil progress, in addition to create produce grading in addition to feedback for pupil projects inward Google Drive…Doctopus increases pupil collaboration in addition to enables a powerful shift inward instructor workflow --  scaling teachers' mightiness to create produce in addition to assess writing tasks in addition to projects that motivate rich, authentic pupil production in addition to collaboration (e.g. the evolution of meat career, college, in addition to 21st-century skills).’

3- Super Quiz

‘Super Quiz adds vivid functionality to a quiz made alongside Google Forms. By completing the quiz ane time alongside an response key, all futurity submissions are automatically graded right or incorrect. What’s to a greater extent than - yous tin larn a pause downwards of course of instruction agreement in addition to a listing of wrong students for each query - perfect for intervention!’

4- Online Rubric

‘Use Online Rubric for whatever assignment, including presentations, performance, in addition to participation grades, in addition to ship grades to your students without the hassle in addition to waste product of newspaper in addition to copiers.Online Rubric supports multiple emails for each pupil inward the illustration of revisions in addition to allows yous to utilization previously created rosters in addition to rubrics inside the add-on.’

Follow us on : Twitter, Facebook , Google plus, Pinterest .

Human Tech - Ii Of Import Google Sheets Tips For Teachers

July 30, 2015
In today’s post, nosotros are sharing amongst yous ii of import Sheets tips pertaining to electronic mail notifications. You tin purpose these tips to have electronic mail notifications together with proceed rails of the forms yous exercise together with percentage amongst your students. The offset agency is through the purpose of Sheets integrated characteristic called ‘ Notification rules’ together with the minute i is through using a 3rd political party summation called Form Notification.

1- Notification rules
 This is a characteristic nosotros bring covered inward an before post a few months ago. 'Notification rules' allows yous to have a notification electronic mail  every fourth dimension a pupil submits a form. You tin select whether yous desire to last notified each fourth dimension a modify is made to the shape or solely when a user submits a form. Similarly, yous tin every bit good pick out whether yous desire to have a daily digest electronic mail or an instantaneous email. In this way, yous volition last able forthwith rails all the forms submission from your students together with decide who submitted what together with when. Here is how to activate it:

Head over to your Google form, together with click on “ Tools” together with select “Notification rules”

Select from the options provided inward the box.

Watch this video to larn to a greater extent than most this tip.

2- Form Notification
This is a peachy Sheets summation nosotros discovered through Time Saving Tips. 'This summation allows users to exercise together with configure electronic mail notifications that are sent when a Form receives submissions. Users tin bring emails sent to the creator of the Form and/or ship short, customized respond emails to the Form submitter.'

Watch this video to larn to a greater extent than most this add-on

 Follow us on : Twitter, Facebook , Google plus, Pinterest .

Human Tech - Eight Fantabulous Google Sheets Add-Ons To Practise Smarter Spreadsheets

October 20, 2015
In today’s post, nosotros are introducing y'all to a collection of of import add-ons to usage on your Google Sheets to practice smarter spreadsheets amongst beautiful designs as well as to a greater extent than sophisticated functionalities. Using these extensions volition enable y'all to add together dissimilar styles as well as fonts to your spreadsheets; take duplicate values betwixt ii tables or inwards ane sheet; honor as well as construct clean upward data; dissever names to several columns, search inwards values, formulas, notes as well as hyperlinks inwards all sheets at once; easily generate Gantter schedules from your sheets; add together reminders to your sheets; smart autofilling of information into other columns based on the values of the other columns, as well as many more.

1- Styles

'This improver volition brand adding beauty to your spreadsheet a breeze. It's thus slowly to use, all y'all demand to practice is select a few cells y'all desire to fashion as well as and thus click ane of the styles inwards the Style viewer sidebar.'

2- More Fonts

'More fonts plant exactly similar the default fonts inwards your spreadsheet. After selecting to a greater extent than or less cells to format, only click More Fonts inwards the improver bill of fare as well as pick out a font. If y'all desire to pick out from fifty-fifty to a greater extent than fonts as well as encounter what they await like, all y'all demand to practice is pick out Show More Fonts inwards the menu. This volition opened upward the spreadsheet sidebar where y'all tin encounter the total listing of fonts formatted inwards their ain style. '

3- Remove Duplicates

'Follow five uncomplicated steps to honor duplicate or unique values betwixt ii tables or inwards ane sheet. This improver comes amongst ii useful wizards. One volition aid y'all compare ii dissimilar tables or columns as well as take duplicates; the other volition search for unique as well as duplicate rows inside ane sheet. '

4- Power Tools

'One-click solutions for daily tasks: dissever cells, take duplicates, alter case, honor as well as construct clean upward data, piece of work amongst formulas & more. Power Tools improver cuts the clicks on repeated tasks as well as brings features for organizing as well as unifying information inwards Google Sheets. '

5- Split Names   

'Enable this improver for your sheets if y'all always demand to accept origin as well as final names inwards dissimilar columns. You tin consummate this task inwards a click: pick out the advert parts y'all demand as well as click "Split" to accept them pulled out to separate cells. That's it!'

6- Schedule Generator    

'This improver allows y'all to speedily generate Gantter™ schedules from Google Sheets. With ane click, y'all tin highlight a listing of tasks inwards Sheets to practice a Gantter™ schedule or usage a template to practice a to a greater extent than robust schedule amongst start date, halt date, resource, as well as notes! Once your Gantter™ schedule is created y'all tin usage Gantter for Google Drive™ to opened upward as well as salve your files guide from Drive as well as usage all the ability of Gantter™ to prepare gantt charts, assign resources, rail terms as well as completion for all your projection tasks.'

7- Add Reminders   

    

'This spreadsheet tin hold upward a uncomplicated personal task listing or a project-management interface that requires team-wide coordination. Add Reminders lets y'all have e-mail reminders earlier dates inwards a specific column of your spreadsheet are reached.'

8- Smart Autofill

'Smart Autofill improver uses Machine Learning via the Google Prediction API  to fill upward missing values inwards a column of data, based on other information inwards the column as well as the information inwards following columns. It volition await for patterns inwards the rows of information where at that topographic point are values acquaint inwards the column, as well as apply them to fill upward inwards the missing values of the column.'

 Follow us on : Twitter, Facebook , Google plus, Pinterest 

Human Tech - Ii Wonderful Google Sheets Features For Teachers

October 23, 2015
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.

This is how to add together a nautical chart or formula to your spreadsheet

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

 Follow us on : Twitter, Facebook , Google plus, Pinterest 

Human Tech - Ii Must Convey Google Sheets Templates For Teachers

October 27, 2015
Google has late revamped its template galleries for Docs, Sheets as well as Slides as well as introduced roughly handy pre-designed templates to role amongst students inwards class. The galleries are even as well as thence a work-in progress as well as characteristic solely a express ready of templates only to a greater extent than volition move released inwards the upcoming weeks. We spent onetime sifting through the Sheets gallery  and picked out these 2 beautiful templates for you lot to role inwards your daily teaching. You tin customize the templates as well as alter the values to include yours.

To access as well as role whatsoever of these templates, larn to Sheets Gallery as well as click on 'More' on lead house correct paw side as well as scroll downward to  'Education' category.


1- Grade Book

This is a wonderful grading canvas that allows you lot to calculate as well as salvage students grades. Using the Grades tab, you lot tin move inwards the assignments, quizzes as well as tests inwards Row 2. Then assign the full points possible for each i inwards Row three as well as students grades volition automatically calculated as well as displayed inwards columns C/D. This canvas equally good includes an ‘Individual Report’ tab that lets you lot sentiment reports for private students. There are equally good illustrative charts that are generated automatically for flat distribution based on flat average as well as for average scores per assignment.

2- Attendance 

Use this template to easily tape flat attendance using 4 major values: nowadays (P), belatedly (L), excused absence(EA), as well as unexcused absence(UA). You tin customize these values from  the Attendance Key tab as well as role the ones you lot want.

 Follow us on : Twitter, Facebook , Google plus, Pinterest 

Human Tech - Explore The Hidden Gems Of Google Sheets Alongside These Add-Ons

November 23, 2015
Google Sheets add-ons allow you lot to add together around swell functionalities to your sheets in addition to aid you lot tap into the existent educational potential of Google Sheets. Over the by twelvemonth or so, nosotros get got reviewed a bunch of these extensions in addition to get got specially focused on the ones that are straight relevant for us inwards education. Today's post features around other railroad train of instrumental applications to heighten your Google Sheets productivity. These add-ons volition innovate you lot to around hidden gems on how to smartly piece of work on columns, cells in addition to rows inwards your tables. Check them out in addition to every bit ever portion amongst us your feedback. Enjoy

1- Remove Duplicates

‘This plus comes amongst 2 useful wizards. One volition aid you lot compare 2 dissimilar tables or columns in addition to take duplicates; the other volition search for unique in addition to duplicate rows inside 1 sheet.’

2- Split Names

‘Enable this plus for your sheets if you lot ever demand to get got outset in addition to final names inwards dissimilar columns. You tin hand the axe consummate this project inwards a click: pick out the holler parts you lot demand in addition to click "Split" to get got them pulled out to divide cells. That's it!’

3- Add Rows & Columns

‘With this add-on, you lot no longer get got to add together rows in addition to columns 1 at a time. Just select a cell, select the carte pick nether "Add Rows & Columns", in addition to add together whatever give away of rows or columns amongst a unmarried click.’

4- Remove Blank Rows

Do you lot get got Sheets that comprise nagging blank rows in addition to it takes a lot of fourth dimension to delete or enshroud them in addition to non to advert the adventure of accidentally deleting the incorrect rows? If you lot do, instruct this plus to speedily instruct rid of them. Once you lot get got the add-on, click the demonstrate push to hand it a try.

5- Insert in addition to Delete Cells

‘This plus creates carte items that allow you lot to easily insert blank cells inwards the middle of a spreadsheet, shifting the existing content downward or to the right. It likewise allows you lot to delete cells inwards the middle of a spreadsheet, shifting inwards content upwards or left.’

Follow us on : Twitter, Facebook , Google plus, Pinterest 

Human Tech - Two Useful Tools To Generate Qr Codes From Google Sheets

November 25, 2015
Google Sheets add-ons shop comprises unopen to truly non bad extensions to job amongst your sheets. Add-ons select many functionalities that are non truly provided yesteryear Google Sheets together with that tin move assist you lot last to a greater extent than productive amongst your sheets creation. For instance, at that topographic point are add-ons that assist you lot convert sheets into Google docs, add-ons to assistance you lot inward grading quizzes, others to job to uncover the hidden gems of Google sheets together with many more. Today, nosotros are sharing amongst you lot 2 to a greater extent than add-ons particularly useful for generating QR codes from information sheets. The commence one, QR Code Generator, is quite pop amidst educators together with has to a greater extent than interesting features. It allows you lot to generate QR codes from your sheets together with salve them to your Google Drive. The bit add-on, Create QR Codes, is too useful only it is lacking inward together with thus many features. We invite you lot to motility them out together with portion amongst us your feedback. Enjoy

1- QR Code Generator

‘QR Code Generator improver lets you lot easily practise QR codes from values inward Google Spreadsheets.You tin move generate multiple QR codes yesteryear selecting a arrive at of values inward a spreadsheet.QR codes are saved either inward a Google Document or every bit PNG files inward Google Drive.’

Watch this video to larn to a greater extent than nearly QR Code Generator

2- Create QR Codes

This is a pretty basic improver amongst the minimum features. It allows you lot to practise ‘qr code for given text inward predefined together with too to check to cell. Simply acquire inward the text together with click "Insert QR Code" button’.

 Follow us on : Twitter, Facebook , Google plus, Pinterest 

Human Tech - Xi Powerful Google Sheets Add-Ons For Teachers

January 11, 2016
Google Sheets add-ons' shop embeds roughly actually handy tools to occupation to expand in addition to add together novel functionalities to your spreadsheets. We cause got reviewed several of these add-ons inwards the by in addition to today nosotros cause got curated for you lot this collection featuring roughly of the near pop Sheets add-ons out there. We invite you lot to cheque them out and, every bit always, part amongst us your feedback. Enjoy

1- Flubaroo

‘Flubaroo is a FREE improver to Google Forms/Sheets which lets you lot apace flat in addition to analyze educatee surgery on multiple alternative in addition to fill-in assignments. Within a infinitesimal you'll live on able to:
  * Get scores for each student, in addition to position students inwards demand of extra help.
  * View average score, in addition to a histogram of scores.
  * Quickly position questions which a bulk of the students missed.
  * Email students their scores, along amongst optional notes to the shape and/or to each student.
  * Assign your ain score to open-ended questions.’

2- Doctopus

‘Doctopus gives teachers the mightiness to mass-copy (from a starter template), share, monitor educatee progress, in addition to grapple grading in addition to feedback for educatee projects inwards Google Drive…Doctopus increases educatee collaboration in addition to enables a powerful shift inwards instructor workflow --  scaling teachers' mightiness to grapple in addition to assess writing tasks in addition to projects that motivate rich, authentic educatee production in addition to collaboration (e.g. the evolution of nitty-gritty career, college, in addition to 21st-century skills).’

3- Super Quiz

‘Super Quiz adds bright functionality to a quiz made amongst Google Forms. By completing the quiz i time amongst an response key, all hereafter submissions are automatically graded right or incorrect. What’s to a greater extent than - you lot tin larn a intermission downwards of shape agreement in addition to a listing of wrong students for each inquiry - perfect for intervention!’

4- Online Rubric

‘Use Online Rubric for whatsoever assignment, including presentations, performance, in addition to participation grades, in addition to transportation grades to your students without the hassle in addition to waste materials of newspaper in addition to copiers.Online Rubric supports multiple emails for each educatee inwards the instance of revisions in addition to allows you lot to occupation previously created rosters in addition to rubrics inside the add-on.’

5- Remove Duplicates

‘This improver comes amongst ii useful wizards. One volition assist you lot compare ii dissimilar tables or columns in addition to take duplicates; the other volition search for unique in addition to duplicate rows inside i sheet.’

6- Split Names

‘Enable this improver for your sheets if you lot ever demand to cause got rootage in addition to final names inwards dissimilar columns. You tin consummate this task inwards a click: select the yell parts you lot demand in addition to click "Split" to cause got them pulled out to separate cells. That's it!’

7- Add Rows & Columns

‘With this add-on, you lot no longer cause got to add together rows in addition to columns i at a time. Just select a cell, select the bill of fare alternative nether "Add Rows & Columns", in addition to add together whatsoever set out of rows or columns amongst a unmarried click.’

8- Remove Blank Rows

Do you lot cause got Sheets that comprise nagging blank rows in addition to it takes a lot of fourth dimension to delete or cover them in addition to non to elevate the adventure of accidentally deleting the wrong rows? If you lot do, larn this improver to apace larn rid of them. Once you lot cause got the add-on, click the present push to give it a try.

9- Insert in addition to Delete Cells

‘This improver creates bill of fare items that allow you lot to easily insert blank cells inwards the middle of a spreadsheet, shifting the existing content downwards or to the right. It also allows you lot to delete cells inwards the middle of a spreadsheet, shifting inwards content upwardly or left.’

10- Power Tools

'One-click solutions for daily tasks: carve upwardly cells, take duplicates, alter case, discovery in addition to construct clean upwardly data, piece of work amongst formulas & more. Power Tools improver cuts the clicks on repeated tasks in addition to brings features for organizing in addition to unifying information inwards Google Sheets. '

11- Schedule Generator    

'This improver allows you lot to apace generate Gantter™ schedules from Google Sheets. With i click, you lot tin highlight a listing of tasks inwards Sheets to practise a Gantter™ schedule or occupation a template to practise a to a greater extent than robust schedule amongst start date, halt date, resource, in addition to notes! Once your Gantter™ schedule is created you lot tin occupation Gantter for Google Drive™ to opened upwardly in addition to salve your files straight from Drive in addition to occupation all the mightiness of Gantter™ to railroad train gantt charts, assign resources, rails damage in addition to completion for all your projection tasks.'

 Follow us on : Twitter, Facebook , Google plus, Pinterest .

Human Tech - Google Sheets Released A Novel Interesting Characteristic To Convert Text To Columns

February, 2016
Google Sheets announced yesterday the free of a novel handy characteristic that allows yous to easily convert text to columns. This is specially helpful when pasting delimited information ( information separated past times commas) inward a spreadsheet. With a unmarried click yous volition bring all your delimited information spread across unlike columns.

To dissever your delimited data, yous merely select the column yous desire to split, click ‘data’ as well as therefore guide ‘Split text to columns’ as well as pick i of the options there. You tin dissever information using commas, periods, spaces, semicolons as well as many other pop separators.

‘In improver to the “Split text to columns” option, yous tin too format cells containing delimited information using a contextual bill of fare that appears straight off later you’ve pasted data, every bit shown inward the animation below. You tin guide a custom separator through this method also’. Check out Google Sheets Help Center to larn more.

 Follow us on : Twitter, Facebook , Google plus, Pinterest .

Human Tech - An First-Class Google Sheets Plus To Interpret Spreadsheets Jail Cellphone Past Times Cell

February , 2017
When it comes to translating spreadsheets nearly of the translation applications out at that spot won’t serve the purpose. Information separated inward unlike cells renders translated versions irrelevant too sometimes ridiculous. However, at that spot is this Google Sheets summation that tin live on actually helpful. It has likewise received quite many positive reviews inward the add-ons store.

Translate My Sheet is a Google Sheets extension that you lot tin utilisation to interpret spreadsheets from i linguistic communication to the other. The service supports over 100 languages. You tin utilisation it inward 2 ways: you lot tin either interpret the content of a spreadsheet prison theatre cellphone past times prison theatre cellphone or opt to interpret the whole spreadsheet at once. The agency it plant is really simple: Once you lot accept installed the summation on your Sheets, click to opened upwards it. Select your origin linguistic communication (it is on automobile respect past times default) too your target linguistic communication too thence banking concern gibe whether you lot desire a ‘Full sheet’ or ‘Selected range’ too at that spot you lot go. Simply highlight whatever you lot desire to interpret too you lot volition larn it converted to the linguistic communication of your alternative inward a thing of a few seconds. Give it a displace too encounter if it plant for you.

Human Tech - X Of Import Google Sheets Tips For Teachers

February 7, 2017
After Google Docs poster, hither is the i nosotros promised to laid upwards for Google Sheets. Our piece of occupation behind these visuals is to highlight basic features teachers (and students) involve to know to brand the best of Google Drive services inward their didactics (and learning).  These are peculiarly helpful for novice users. All of the information nosotros include are taken from guidelines provided inward Google Drive Help Centre. Today's postal service features what nosotros mean value are the 10 basic Google Sheets tips to attention y'all brand improve spreadsheets. Again, experience complimentary to download, print, percentage or distribute the visual the mode y'all desire provided y'all credit our weblog equally the beginning together with continue it complimentary of charge. You tin equally good download it inward PDF format from this link.

Human Tech - A Novel Interesting Google Sail Characteristic For Teachers

February 14, 2017
Google announced yesterday the liberate of a novel interesting characteristic inward Google Sheets. Users are at nowadays able to link to content inward specific cells. This is particularly helpful if yous convey a long spreadsheet amongst several cells. You tin halt easily usage links to dissimilar cells making it easier for anyone checking out your canvas to easily navigate in addition to deed merely about your file.‘With this novel functionality, yous tin halt usage a “table of contents” for your spreadsheet, at 1 time others to specific content inside your spreadsheet, in addition to retain links to cells when yous import spreadsheets from other applications.’

Here is how to usage links inward a spreadsheet:

• Open a spreadsheet
• ‘Click where yous desire the link, or highlight the text that yous desire to link.
• Click Insert in addition to and thence Link.
• In the "Text" field, type the text yous desire to live on linked.
• In the "Link" field, instruct into a URL or e-mail address, or search for a website.
• Click Apply.’

Here is how to link to a gain of cells inward a spreadsheet:

• ‘Open a spreadsheet inward Google Sheets.
• Select the prison theatre cellphone yous desire to link.
• Click Insert in addition to and thence Link.
• Click Select a gain of cells to link Grid. 
• Select the gain of cells yous desire to link to.
• Click Apply.’

Human Tech - Everything Teachers Ask To Know To Create, Edit Together With Portion Spreadsheets Using Google Sheets

March 14, 2017
This is the 6th postal service inwards a serial of posts geared towards helping teachers, educators together with students brand the best of Google services inwards education. Today nosotros are featuring Google Sheets, an fantabulous tool to assist you lot create, edit, format together with part a broad diverseness of spreadsheets alongside others. Using the guidelines below. you lot volition acquire to acquire most everything you lot ask to main Sheets from creating together with sharing spreadsheets to viewing together with editing settings of spreadsheets.

Previous charts nosotros accept published together with therefore far include: Google Drive Chart, Chromebook chart,  YouTube chart,  Google Maps guidelines chart, together with Google Forms chart.

Google Sheets Guidelines for Teachers

Create, edit together with format spreadsheets	How to utilisation Google Sheets Create a spreadsheet Edit together with format a spreadsheet Import information sets together with spreadsheets Format numbers inwards a spreadsheet
Work alongside sheets,	Protect, hide, together with edit sheets Edit rows, columns & cells inwards a spreadsheet
Publish together with embed your spreadsheet	Publish together with embed Google Docs, Sheets, Slides & Forms
Functions together with formulas	Add formulas together with functions to a spreadsheet See the amount of cells inwards a spreadsheet Reference information from other sheets Google spreadsheets business office list
Create together with edit charts	Create, edit & delete charts Chart types See together with utilisation suggested charts together with analysis inwards a spreadsheet Save, print, or import your chart
Tools	Turn on notifications inwards a spreadsheet Use add-ons & Apps Script Keyboard shortcuts for Google Sheets
Spreadsheets settings, views together with printing	Edit together with persuasion text from correct to left Set a spreadsheet’s place together with calculation settings
Work alongside data	Create together with utilisation pin tables Name a attain of cells Sort together with filter your data Create an in-cell dropdown list Automatically practice a serial or list Use conditional formatting rules inwards Google Sheets Using arrays inwards Google Sheets Separate jail mobile telephone text into columns

Source: Docs Editor Help