Learn how to create Excel Dashboards - Part 1 - Introduction and Lookup Functions Premium class

Abdelrahman Abdou, Data Analyst & Excel Lover!

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

      8:06
    • Data Preparation

      6:16
    • VLOOKUP

      9:38
    • HLOOKUP

      5:49
    • Match

      4:30
    • Row,Rows,Column,Columns

      13:15
    • Offset Function Basics

      5:22
    • Dynamic Ranges with OFFSET (Part 1) Data Validation

      10:10
    • OFFSET Dynamic Ranges (Part 2) Creating Dynamic Charts

      13:27
    • OFFSET Dynamic Range (Part 3) Dynamically Expanding Ranges

      10:55
    • 1 Index and Using it for Lookups

      6:38
    • 2 Dynamic Ranges with Index

      14:11
    • Choose Function

      5:25
    • Choose Function Application Dividing Data into quarters

      6:00

About This Class

This class is the first class in a series of classes on how to create Interactive, Professional looking dashboards using Microsoft Excel.

This first class shows how to prepare data and how to use Different lookup functions in Excel to perform lookups and create dynamic ranges.

It also shows different applications of dynamic ranges which are a very important building block for creating Excel Dashboards !

35

Students

--

Projects

Abdelrahman Abdou

Data Analyst & Excel Lover!

Hi, I'm Abdelrahman and I'm and Excel Lover :)

I have a Bachelor's Degree in Chemical Engineering.

I Work as MIS and Reporting Analyst in Vodafone International Services In Egypt.

I have more than 5 Years of Experience in Excel including building Dashboards and VBA.

I have created numerous dashboards in my company and automated tens of reports.

I love learning new things and my main learning method is through self-learning by watching video tutorials.

I love Excel and I'm trying to share the love with everyone else !