Google Sheets for Administrative Assistants Tutorial

Google Sheets for Administrative Assistants Tutorial

Learnit Training via YouTube Direct link

Sparkline Chart 41:24

9 of 21

9 of 21

Sparkline Chart 41:24

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Google Sheets for Administrative Assistants 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 Converting a List into a Table 1:33
  4. 4 Organizing Table Columns 7:57
  5. 5 Removing Duplicates 13:56
  6. 6 Conditional Formatting 18:16
  7. 7 Chart Basics 27:28
  8. 8 Customizing Charts 34:20
  9. 9 Sparkline Chart 41:24
  10. 10 Freezing Rows and Columns 44:06
  11. 11 Export to PDF with Headers and Footers 48:05
  12. 12 Linking to Sheets 51:34
  13. 13 Linking to Cell Ranges and External sites 54:36
  14. 14 Module 2 Intro 59:27
  15. 15 Pivot Table Basics 1:00:04
  16. 16 Filtering a Pivot Table 1:07:20
  17. 17 Pivot Table Options 1:09:55
  18. 18 Data Validation Basics 1:15:12
  19. 19 Troubleshooting Data Validation 1:23:53
  20. 20 Collaborating in Google Sheets 1:27:40
  21. 21 Conclusion 1:34:55

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.