Google Sheets - Full Tutorial (2021)
New to Google Sheets? Watch my fresh tutorial for beginners!
Already familiar with Google Sheets? I guarantee you'll still learn something valuable from all of the useful tips and hidden gems in this video (see timestamps below)!
TIMESTAMPS
0:00 - Introduction
0:50 - How to access Google Sheets
4:39 - Interface and menus
14:52 - Cells and navigation
20:34 - How to input and edit data
25:10 - Things are not always as they appear: Data entry vs. Formulas in cells
28:10 - Equations vs. Formulas vs. Functions
34:46 - Naming and saving spreadsheets
37:47 - Google Drive and collaboration
42:57 - How to access and restore previous versions of the same spreadsheet
44:46 - Functions and function helpers
49:08 - How to copy, paste, and move data around
59:59 - Auto-fill and Paste Special
1:05:36 - Absolute vs. Relative references
1:15:56 - Must-know keyboard shortcuts to save you time and effort
1:23:40 - How to format cells, columns, and rows
1:34:52 - Add and remove columns and rows
1:38:16 - Hide and group columns and rows
1:42:16 - Add a filter
1:48:09 - Create a chart
1:51:42 - Images: everything you need to know, and more
1:59:01 - Merge and unmerge cells
2:02:22 - Conditional formatting
2:10:57 - Data validation: how to create drop-down menus and get rid of human error
2:24:13 - How to get live data from the web and combine spreadsheets with IMPORT functions
2:33:41 - Sharing spreadsheets, adding permissions, and protecting cells
2:51:49 - How to print, email, convert and download spreadsheets
3:06:21 - Different interface views and space management
3:10:41 - Conclusion
For more free Google Sheets and Microsoft Excel content, check out my website:
Have you heard of the Ultimate Athlete Monitoring Toolkit in Google Sheets? If not, you're missing out! It includes Google Sheets tutorials and free spreadsheets that bring you from a blank spreadsheet to having a robust, integrated athlete monitoring tool in Google Sheets. All videos are in this free Youtube playlist: • Ultimate Athlete Monitoring Toolkit (UAMT)...