Learn how to create Excel Dashboards - Part 1 - Intro and functions 1

Abdelrahman Abdou, Data Analyst & Excel Lover!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Videos (1h 20m)
    • Introduction

      5:34
    • Data Preparation

      6:16
    • VLOOKUP

      8:56
    • HLOOKUP

      4:25
    • MATCH Function

      3:57
    • ROW ROWS COLUMN COLUMNS

      15:08
    • OFFSET Function Basics

      6:57
    • Offset Function Application 1 - Data Validation Lists

      14:05
    • Dynamic Ranges Part 2 Dynamic Ranges with Charts

      14:31
    • Offset Function Application Part 3 Dynamic Expanding Ranges

      9:55