Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

33 Practical Projects in Excel and Google Sheets for Beginners

via freeCodeCamp

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master spreadsheet fundamentals through 33 hands-on projects in this 4.5-hour course designed for both Microsoft Excel and Google Sheets users. Build practical tools including a personal finance tracker, dynamic search bars, and automated email systems. Learn essential skills like creating calendar events, implementing user-defined functions, and utilizing Apps Script for advanced automation. Develop proficiency in features such as data validation, dependent drop-down lists, and VBA programming. Practice real-world applications by constructing dynamic invoice generators, travel checklists, and YouTube analytics dashboards. Access included project demo sheets to follow along and reinforce learning through practical implementation. Advance from basic spreadsheet operations to sophisticated automation techniques while creating useful tools for personal and professional use.

Syllabus

⌨️ Intro
⌨️ Create a Personal Finance Tracker
⌨️ Create All Day Calendar Events
⌨️ Auto Numbering in Excel
⌨️ Create Dynamic Search Bar
⌨️ Excel User Defined Functions
⌨️ Apps Script Form to Calendar
⌨️ Embed YouTube in Sheets
⌨️ Send Email From Google Sheet
⌨️ Automate Reminder Emails with Lido
⌨️ Create Image Lightbox in Google Sheet
⌨️ Create Travel Checklist in Sheets
⌨️ Mail Merge with Lido
⌨️ Regular Expressions in Excel
⌨️ Table in Google Sheets finally
⌨️ Create a Daily Taskmaster
⌨️ Link Google Tables to Google Docs
⌨️ Excel vs Sheets Tables
⌨️ Create a Dynamic Monthly Calendar in Sheets
⌨️ Create Multiple Condition Dynamic Checkboxes
⌨️ Apps Script - Extract Data From LinkedIn
⌨️ Apps Script - Get Last Row
⌨️ Multiple Dependent Drop Down Lists
⌨️ Multiple Selection Data Validation update
⌨️ YouTube Analytics In Google Sheets
⌨️ Excel File Types
⌨️ Excel - Create Search Bar
⌨️ Quickbooks Fast Bulk Import from Excel
⌨️ 14 Excel Shortcuts
⌨️ Excel - Make a Dynamic Invoice Generator
⌨️ Excel - Make a Calendar with Sequence
⌨️ Automatic notifications from Google Sheet
⌨️ Excel - Create Color By Number Generator
⌨️ Excel - Make a Directory of Sheets with VBA

Taught by

freeCodeCamp.org

Reviews

Start your review of 33 Practical Projects in Excel and Google Sheets for Beginners

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.