The Google Sheets Course

Google Sheets Meets Reality TV & Pop Culture
Enroll Now

THE GOOGLE SHEETS COURSE
Course Curriculum

    1. Datasets & Practice Workbooks 📚

    2. Welcome to The Pop Culture Data Academy

    3. 101 Workbooks 101 🍎

    4. 102 Optimizing your Keyboard & Shortcuts ✂️

    5. 103 Introduction to Functions and Formulas 👩‍🍳

    6. 104 Relative & Absolute Referencing 🔒

    7. 105 Working Across Worksheets ✈️

    8. 106 Sharing Worksheets Safely 🔗

    1. 201 Formatting Basics ✏️

    2. 202 Building a Color Palette 🎨

    3. 203 Data Validation ✅

    4. 204 Hyperlinking 🔗

    5. 205 Alternating Colors 👀

    6. 206 Designing your Workbook 👩‍💻

    7. 207 Themes 🖌️

    8. 208 Format as Table (NEW Sheets Feature)

    1. 301 Conditional Formatting Basics 🎨

    2. 302 Format Cell Rules 📝

    3. 303 Color Scales 🌡️

    4. 304 Managing Conditional Formatting Rules ✏️

    5. 305 Entire Row Conditional Formatting 👀

    6. 306 Highlight Duplicate Values 💃

    1. 401 Number Formatting 🔢

    2. 402 Splitting Data 🤸‍♀️

    3. 403 Combining Data 🤝

    4. 404 Extracting Data ⛏️

    5. 405 Case Functions 🔤

    6. 406 Beginner Functions 🌱

    7. 407 IF Functions 🤔

    8. 408 Naming Ranges 😌

    9. 409 Checkboxes ✅

    10. 410 Wildcards 🦁

    1. 501 Intro to Data Visualization 🔍

    2. 502 Bar and Column Charts 📊

    3. 503 Chart Design 🎨

    4. 504 Line Charts 📈

    5. 505 Pie Charts 🍕

    6. 506 Combo Charts 🤝

    7. 507 Move Charts into Dashboards 📌

    1. 601 Splitting Data (Advanced) ✂️

    2. 602 Filtering Data 🔍

    3. 603 Filtered Views 👓

    4. 604 Sorting Data ↕️

    5. 605 Find & Replace Data 🔄

    6. 606 Remove Duplicates 🗑️

About this course

  • $297.00
  • 73 lessons
  • 7 hours of video content