33 Practical Projects in Excel and Google Sheets for Beginners

33 Practical Projects in Excel and Google Sheets for Beginners

freeCodeCamp.org via freeCodeCamp Direct link

⌨️ Auto Numbering in Excel

4 of 34

4 of 34

⌨️ Auto Numbering in Excel

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

33 Practical Projects in Excel and Google Sheets for Beginners

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

  1. 1 ⌨️ Intro
  2. 2 ⌨️ Create a Personal Finance Tracker
  3. 3 ⌨️ Create All Day Calendar Events
  4. 4 ⌨️ Auto Numbering in Excel
  5. 5 ⌨️ Create Dynamic Search Bar
  6. 6 ⌨️ Excel User Defined Functions
  7. 7 ⌨️ Apps Script Form to Calendar
  8. 8 ⌨️ Embed YouTube in Sheets
  9. 9 ⌨️ Send Email From Google Sheet
  10. 10 ⌨️ Automate Reminder Emails with Lido
  11. 11 ⌨️ Create Image Lightbox in Google Sheet
  12. 12 ⌨️ Create Travel Checklist in Sheets
  13. 13 ⌨️ Mail Merge with Lido
  14. 14 ⌨️ Regular Expressions in Excel
  15. 15 ⌨️ Table in Google Sheets finally
  16. 16 ⌨️ Create a Daily Taskmaster
  17. 17 ⌨️ Link Google Tables to Google Docs
  18. 18 ⌨️ Excel vs Sheets Tables
  19. 19 ⌨️ Create a Dynamic Monthly Calendar in Sheets
  20. 20 ⌨️ Create Multiple Condition Dynamic Checkboxes
  21. 21 ⌨️ Apps Script - Extract Data From LinkedIn
  22. 22 ⌨️ Apps Script - Get Last Row
  23. 23 ⌨️ Multiple Dependent Drop Down Lists
  24. 24 ⌨️ Multiple Selection Data Validation update
  25. 25 ⌨️ YouTube Analytics In Google Sheets
  26. 26 ⌨️ Excel File Types
  27. 27 ⌨️ Excel - Create Search Bar
  28. 28 ⌨️ Quickbooks Fast Bulk Import from Excel
  29. 29 ⌨️ 14 Excel Shortcuts
  30. 30 ⌨️ Excel - Make a Dynamic Invoice Generator
  31. 31 ⌨️ Excel - Make a Calendar with Sequence
  32. 32 ⌨️ Automatic notifications from Google Sheet
  33. 33 ⌨️ Excel - Create Color By Number Generator
  34. 34 ⌨️ Excel - Make a Directory of Sheets with VBA

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.