The Google Sheets Course
Google Sheets Meets Reality TV & Pop Culture
THE GOOGLE SHEETS COURSE
Course Curriculum
-
-
Datasets & Practice Workbooks π
-
Welcome to The Pop Culture Data Academy
-
101 Workbooks 101 π
-
102 Optimizing your Keyboard & Shortcuts βοΈ
-
103 Introduction to Functions and Formulas π©βπ³
-
104 Relative & Absolute Referencing π
-
105 Working Across Worksheets βοΈ
-
106 Sharing Worksheets Safely π
-
-
-
201 Formatting Basics βοΈ
-
202 Building a Color Palette π¨
-
203 Data Validation β
-
204 Hyperlinking π
-
205 Alternating Colors π
-
206 Designing your Workbook π©βπ»
-
207 Themes ποΈ
-
208 Format as Table (NEW Sheets Feature)
-
-
-
301 Conditional Formatting Basics π¨
-
302 Format Cell Rules π
-
303 Color Scales π‘οΈ
-
304 Managing Conditional Formatting Rules βοΈ
-
305 Entire Row Conditional Formatting π
-
306 Highlight Duplicate Values π
-
-
-
401 Number Formatting π’
-
402 Splitting Data π€ΈββοΈ
-
403 Combining Data π€
-
404 Extracting Data βοΈ
-
405 Case Functions π€
-
406 Beginner Functions π±
-
407 IF Functions π€
-
408 Naming Ranges π
-
409 Checkboxes β
-
410 Wildcards π¦
-
-
-
501 Intro to Data Visualization π
-
502 Bar and Column Charts π
-
503 Chart Design π¨
-
504 Line Charts π
-
505 Pie Charts π
-
506 Combo Charts π€
-
507 Move Charts into Dashboards π
-
-
-
601 Splitting Data (Advanced) βοΈ
-
602 Filtering Data π
-
603 Filtered Views π
-
604 Sorting Data βοΈ
-
605 Find & Replace Data π
-
606 Remove Duplicates ποΈ
-
About this course
- $297.00
- 69 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.