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
- 72 lessons
- 7 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.