Course curriculum

    1. Welcome (3:06 min)

    2. Lab File

    1. Part 1 (6:15 min)

    2. Part 2 (4:23 min)

    1. Part 1 - Filter & Dynamic Table (5:24 min)

    2. Part 2 - Slicers (6:48 min)

    3. Part 3 - Conditional Formatting (6:09 min)

    4. Part 4 - Data Validation & more (9:46 min)

    1. Part 1 - Sum & Subtotal (7:12 min)

    2. Part 2 - Vlookup & more (10:45 min)

    3. Part 3a - Flashfill (6:24 min)

    4. Part 3b - Flashfill (1:19 min)

    5. Part 4 - Identify Unique Values in a Column (1:27 min)

    1. Part 1a - Pivot (5:12 min)

    2. Part 1b - Multiple Pivot (3:17 min)

    3. Part 2 - Visualize (9:24 min)

    4. Part 3 - Using Slicers in Multiple Pivots (4:58 min)

    1. Quiz

    2. Assignment

About this course

  • 19 lessons
  • 1.5 hours of video content