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

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 VLOOKUP and HLOOKUP functions in Excel, and how to use OFFSET to create dynamic ranges.

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

41

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 !