Published On Oct 21, 2021
New to Google Sheets? Looking for the most comprehensive and up-to-date GSheets tutorial for beginners? Watch Railswareās updated 2024 guide on how to use Google Sheets!
šTo follow along, make your copy of the practice sheet: https://bit.ly/practice-gsheets
After watching this tutorial, youāll learn how to:
ā
Create and modify a spreadsheet
ā
Work with rows, columns, and cells
ā
Enter different types of data
ā
Format cells and tables
ā
Use the most common formulas and functions
Timestamps on how to:
0:00 Intro
01:20 Create a spreadsheet in Google Sheets
04:31 Add and navigate the tabs
06:05 Use rows, columns, and cells in a spreadsheet
08:11 Add links and images
13:03 Autofill data in GSheets
15:50 Format text in Google Spreadsheets
19:55 Copy and paste values
22:42 Split Text in Google Sheets
23:35 Use Googleās Smartfill function
25:34 Make your Google Spreadsheet available offline
25:57 Find a specific value in a cell
26:28 Find and Replace values in Google Sheets for free
28:34 Edit your spreadsheet history and get back to a previous version
30:08 Freeze rows and columns
32:25 Use formulas and functions in Google Sheets
36:34 Share spreadsheet access with other people
37:38 Print a spreadsheet from Google Sheets
šRead Railsware article about Google Sheets: https://bit.ly/gsheets-article
ā¶ļø Watch our videos on SUM Ā Ā Ā ā¢Ā HowĀ toĀ totalĀ aĀ columnĀ inĀ GoogleĀ Sheet...Ā Ā and COUNT Ā Ā Ā ā¢Ā COUNT,Ā COUNTIF,Ā COUNTIFSĀ functionsĀ in...Ā Ā functions in Google Sheets!
šTry Coupler.io for the safe data import from various tools to GSheets. Visit Coupler.io website for more details: https://bit.ly/best-gsheets-addon
š¤ Join Railsware team http://bit.ly/railswarecareers
Weād love to hear from you!šāāļøš¬ Share your cases of using Google Sheets in the comments ā¬ļø Make sure to subscribe to Railsware Product Academy and hit the bell button š to learn more spreadsheet tips from our next videos!
Design and video production: Oleg Gorovoi
Case creator: Natalia Gorovaia
Speaker: Anastasiia Avramenko
#GoogleSheets #GoogleSheetsTutorialForBeginners #HowToUseGoogleSheets #GoogleSheet #GoogleSheetsTutorial #GoogleSpreadsheetTutorial #GoogleSheetTutorial #HowToUseGoogleSheet #HowToUseGoogleSpreadsheet #HowToUseGoogleSheetsForBeginners #GoogleSpreadsheet #HowToMakeGoogleSheet #HowToCreateGoogleSheet #SpreadsheetTutorial #GoogleExcelSheetTutorial #HowToUseSpreadsheet #GoogleSheetsForBeginners #HowToMakeAGoogleSheet #HowToCreateAGoogleSheet #GoogleExcelSheets