The Excel Course
Excel Meets Reality TV + Pop Culture
THE EXCEL 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 Format as Table π
-
206 Designing your Workbook π©βπ»
-
207 Themes ποΈ
-
-
-
301 Conditional Formatting Basics π¨
-
302 Format Cell Rules π
-
303 Color Scales + Data Bars π
-
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 Filtering Data π
-
602 Sorting Data βοΈ
-
603 Combining Functions π€
-
604 Splitting Data (Advanced) βοΈ
-
605 Find & Replace Data π
-
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.