Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial

Learnit Training via YouTube Direct link

Introduction

2 of 28

2 of 28

Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Google Sheets Advanced Tutorial

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Start
  2. 2 Introduction
  3. 3 List, Format, and Sort
  4. 4 Multi-Column Sort
  5. 5 Filters
  6. 6 Conditional Filters and Filtered Views
  7. 7 Creating Charts
  8. 8 Editing Charts
  9. 9 Removing and Deleting Chart Data
  10. 10 Sparklines
  11. 11 Formatting with Alternating Row Colors
  12. 12 Pivot Tables
  13. 13 Pivot Charts
  14. 14 Named Ranges
  15. 15 IF Functions
  16. 16 Nested Functions
  17. 17 VLOOKUP
  18. 18 SUMIF and AVERAGEIF
  19. 19 SUMIFS
  20. 20 AVERAGEIFS
  21. 21 IFERROR
  22. 22 LEFT and RIGHT
  23. 23 CONCATENATE
  24. 24 Sharing Files
  25. 25 Real-Time Authoring
  26. 26 Google Sheets Add-Ons
  27. 27 Introduction to Google Apps Scripts
  28. 28 Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.