How to: Google Sheets
This practical beginner course teaches students and recent graduates how to use Google Sheets effectively for job readiness. You will learn to create, organize, format, calculate, and analyze data using spreadsheets. Essential skills for almost any modern workplace role.
-
15 Lessons
-
Beginner
-
3 hours 46 minutes
- Format Flexible learning
- Category Job readiness
This practical beginner course teaches students and recent graduates how to use Google Sheets effectively for job readiness. You will learn to create, organize, format, calculate, and analyze data using spreadsheets — essential skills for almost any modern workplace role.
- Google Sheets Basics & Navigation – Creating spreadsheets and understanding the interface.
- Data Entry & Formatting – Entering, organizing, and formatting data professionally.
- Formulas & Functions – Performing calculations with SUM, AVERAGE, and more.
- Sorting, Filtering & Basic Analysis – Organizing data and gaining insights quickly.
- Create and navigate Google Sheets spreadsheets confidently.
- Format data and apply basic organization techniques.
- Use essential formulas and functions to perform calculations.
- Sort, filter data, and create simple visualizations.
- 4 structured video lessons with clear explanations and practical examples.
- Quizzes after each lesson to test and reinforce understanding.
- Official SkillUp Certificate of Completion upon finishing all lessons and quizzes.
Lessons
-
-
-
Getting Started with Google Sheets: Interface and Basics2 Sections 17 minutes
Learn the Google Sheets interface, create your first spreadsheet, enter and format data, and understand basic navigation.
1 reading 1 assignment -
Essential Formulas and Functions2 Sections 18 minutes
Master key formulas and functions to perform calculations and analyze data efficiently.
1 reading 1 assignment -
Data Visualization, Charts & Dashboards2 Sections 16 minutes
Learn to organize data, create charts, and build simple dashboards for better insights.
1 reading 1 assignment -
Collaboration, Sharing & Turning Sheets into Apps3 Sections 21 minutes
Learn real-time collaboration, sharing, and the “Sheets to Apps” approach to building simple automated tools.
2 readings 1 assignment -
Data Cleaning & Automation with Macros2 Sections 18 minutes
Learn how to clean messy data and record macros that can be turned into Apps Script code.
1 reading 1 assignment -
Managing Timesheets & Vacation Requests2 Sections 13 minutes
Build practical workflows for collecting and approving timesheets and vacation requests.
1 reading 1 assignment -
Building Reports with BigQuery2 Sections 13 minutes
Connect Google Sheets with BigQuery to build powerful automated reports.
1 reading 1 assignment -
Advanced Apps: Mail Merge & Notifications2 Sections 14 minutes
Learn advanced automation such as mail merge and sending notifications.
1 reading 1 assignment -
Sending Text Messages with Twilio2 Sections 14 minutes
Learn how to send SMS/text messages automatically from Google Sheets using Twilio and Apps Script.
1 reading 1 assignment -
Auto-calculate Rooms Needed for Events2 Sections 9 minutes
Build a tool that automatically calculates the number of rooms needed for events based on attendance.
1 reading 1 assignment -
Personalized Budget App2 Sections 14 minutes
Create a personalized budget submission and tracking app.
1 reading 1 assignment -
Connecting BigQuery to Google Sheets2 Sections 17 minutes
Learn how to connect BigQuery to Google Sheets for advanced data analysis.
1 reading 1 assignment -
Calculate Customer Lifetime Value2 Sections 15 minutes
Learn how to calculate Customer Lifetime Value (CLV) using formulas and Apps Script in Google Sheets.
1 reading 1 assignment -
Track Expenses from Email Receipts2 Sections 13 minutes
Automatically extract and track expenses from email receipts.
1 reading 1 assignment -
Track Time with Google Calendar2 Sections 14 minutes
Sync and track time entries between Google Calendar and Sheets.
1 reading 1 assignment
-
