Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial

Learnit Training via YouTube Direct link

Conclusion 1:01:44

13 of 13

13 of 13

Conclusion 1:01:44

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 0:00
  2. 2 Introduction 0:09
  3. 3 Creating Named Ranges 1:18
  4. 4 Naming Multiple Ranges 6:32
  5. 5 Accessing Name Ranges Manager 8:01
  6. 6 XLOOKUP Function 9:09
  7. 7 XLOOKUP Approximate Match 15:33
  8. 8 Data Mining with XLOOKUP 19:50
  9. 9 IF & IFS Function 28:25
  10. 10 Database Functions 37:31
  11. 11 PMT Function 45:38
  12. 12 Smart Chips 54:30
  13. 13 Conclusion 1:01:44

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.