The Excel Course

Excel Meets Reality TV + Pop Culture

THE EXCEL 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 Format as Table πŸ‘€

    6. 206 Designing your Workbook πŸ‘©β€πŸ’»

    7. 207 Themes πŸ–ŒοΈ

    1. 301 Conditional Formatting Basics 🎨

    2. 302 Format Cell Rules πŸ“

    3. 303 Color Scales + Data Bars πŸ“Š

    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 Filtering Data πŸ”

    2. 602 Sorting Data ↕️

    3. 603 Combining Functions 🀝

    4. 604 Splitting Data (Advanced) βœ‚οΈ

    5. 605 Find & Replace Data πŸ”„

    6. 606 Remove Duplicates πŸ—‘οΈ

About this course

  • $297.00
  • 68 lessons
  • 4.5 hours of video content
EXCLUSIVE DATASETS
Your Choice of Datasets

The Pop Culture Data Academy comes with exclusive datasets collected by Suzana analyzing social media growth for reality TV and pop culture moments. Choose your dataset to tailor your learning experience to the topic you enjoy most.

  • Bachelorette 15: Hannah Brown's Season
    Instagram Data and Demographics
  • Bachelor 24: Peter Weber's Season
    Instagram Data and Demographics
  • Bachelor 28: Joey Graziadei's Season
    Instagram+Tiktok Data and Demographics
  • Love is Blind Season 6
    Instagram+Tiktok Data and Demographics
  • The Traitors Season 2
    Instagram Data and Demographics
  • Vanderpump Rules Season 10
    Instagram Data and Demographics
  • Taylor Swift/Travis Kelce Crew Fall 2023
    Instagram Data and Demographics