Summary
Full Transcript
Welcome to the Google Sheets Masterclass, part of the Digital Computer Packages Course. In this full beginner-friendly tutorial, you will learn how to use Google Sheets for data entry, formatting, calculations, and productivity — even if you have zero experience. 🌐 Enroll in a Job-Ready Digital Skills Program Here: https://digitalcomputercamp.co.ke/courses/ Download Resources: https://digitalcomputerpackages.xo.je/ Digital Computer Packages Course: https://www.youtube.com/playlist?list=PL54gXZRrQjlDzymrxbLDKtcjD1QVOJ4Ak Submit Exercises: https://forms.gle/8GtdjNNvj44zUTR69 Timestamps: 00:00 Introduction to Google Sheets Masterclass for Beginners 03:33 Module 1: Introduction to Google Sheets 19:11 Module 2: Creating and Managing Spreadsheets 46:50 Module 3: Entering and Formatting Data 1:05:45 Module 4: Basic Formulas and Functions 1:32:45 Module 5: Data Management and Sorting 1:46:27 How to Do Exercises & Submit 2:02:45 How to Join Our Part-Time Digital Computer Packages in March 02, 2026 This lesson covers everything from basic spreadsheets to formulas, functions, sorting, filtering, and data management. ⭐ What You Will Learn in This Google Sheets Lesson ✔ Introduction to Google Sheets and the interface ✔ Rows, columns, cells, data types & navigation ✔ Entering and formatting data (text, numbers, dates) ✔ Conditional formatting & cell styling ✔ Auto-fill, drag, freeze & hide options ✔ Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT ✔ Using absolute vs relative cell references ✔ Using IF & nested IF functions ✔ Applying formulas across rows & columns ✔ Sorting, filtering & using Filter View ✔ Data validation (drop-down lists) ✔ Protecting cells and sheets ✔ Importing & exporting Excel files By the end of this lesson, you’ll be able to create, analyze, and manage spreadsheets like a pro. 🎯 Who This Video Is For? • Students • Office workers (admin, finance, HR, data entry) • Beginners learning computer packages • Freelancers and virtual assistants • Anyone who wants to improve their Excel/Sheets skills #GoogleSheets #GoogleSheetsTutorial #GoogleWorkspace #DigitalSkills #SpreadsheetTraining #ComputerPackages #DataEntry #BeginnerCourse #ProductivityTools
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
