Completed
Conclusion
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Google Sheets Full Course Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Accessing Google Sheets
- 4 Navigating in Cells and Menus
- 5 Keyboard Shortcuts
- 6 Editing Cell Contents
- 7 Templates
- 8 Using Explore
- 9 Opening and Saving Sheets
- 10 Using Google Drive with Google Sheets
- 11 Showing and Using the Formula Bar and Gridlines
- 12 Basic Formulas
- 13 Using Autofill to Copy Formulas
- 14 Using Autofill to Create Redundant Data
- 15 Simple Formulas
- 16 Formulas with Absolute References
- 17 Cut, Copy, and Paste
- 18 Inserting Rows and Columns
- 19 Wrapping Text, Rotating, and Aligning Cells
- 20 Cell Formatting
- 21 Hiding Rows and Columns
- 22 Freeze Panes and Full Screen View
- 23 Spell Check and Printing
- 24 Sharing and Emailing Sheets
- 25 Publishing to Web
- 26 Conclusion
- 27 Introduction
- 28 List, Format, and Sort
- 29 Multi-Column Sort
- 30 Filters
- 31 Conditional Filters and Filtered Views
- 32 Creating Charts
- 33 Editing Charts
- 34 Removing and Deleting Chart Data
- 35 Sparklines
- 36 Formatting with Alternating Row Colors
- 37 Pivot Tables
- 38 Pivot Charts
- 39 Named Ranges
- 40 IF Functions
- 41 Nested Functions
- 42 VLOOKUP
- 43 SUMIF and AVERAGEIF
- 44 SUMIFS
- 45 AVERAGEIFS
- 46 IFERROR
- 47 LEFT and RIGHT
- 48 CONCATENATE
- 49 Sharing Files
- 50 Real-Time Authoring
- 51 Google Sheets Add-Ons
- 52 Introduction to Google Apps Scripts
- 53 Conclusion
