Ready to start learning Google Sheets? Get started with this Google Sheets tutorial for beginners. Learn how to create your first spreadsheet, through to formatting and adding visualizations. Download the example file at https://lovesdata.co/cONsHe
JUMP TO A TOPIC:
00:00 Introduction to Google Sheets
00:47 How to create a new spreadsheet in Google Sheets
02:28 How to import data into a spreadsheet in Google Sheets
04:07 Understanding columns and rows in Google Sheets
05:09 How to freeze the header row in Google Sheets
05:34 Text wrapping in Google Sheets spreadsheet cells
06:23 Formatting values and text in Google Sheets cells
08:00 Sorting values in a Google Sheets spreadsheet
08:39 How to use conditional formatting in Google Sheets
09:36 Calculating new values in Google Sheets
13:30 Inserting extra columns in a spreadsheet
14:03 Using functions in Google Sheets
16:26 How to use filters in Google Sheets
17:19 Validating data in Google Sheets
18:03 Visualizing data in your Google Sheets spreadsheet
19:28 Sharing and collaborating in Google Sheets
19:53 Next steps
WHAT TO WATCH NEXT:
○ Creating charts and graphs in Google Sheets - https://youtu.be/IFX9e9SqGlw
○ Google Sheets tips - https://youtu.be/Pn8ZIM0My9I
○ Looker Studio tutorial - https://youtu.be/Coe_f79Xc2o
TOOLS WE USE AND RECOMMEND:
○ Data connector – https://lovesdata.co/oOWkI
○ Cookie banner – https://lovesdata.co/letON
○ Email platform – https://lovesdata.co/zrLd7
○ Course platform – https://lovesdata.co/2Zzfq
Join our courses: https://www.lovesdata.com/courses
Subscribe to our YouTube channel: http://www.youtube.com/subscription_center?add_user=lovesdata
#googlesheetstutorial #googlesheets