Learn how to create Excel Dashboards - Part 1 - Intro and functions 1 | Abdelrahman Abdou | Skillshare

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 30m)
    • 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!

121

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Abdelrahman Abdou

Data Analyst & Excel Lover!

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

I'm also the founder of ExcelBonanza.com, a website dedicated to making you better at Microsoft Excel!

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 report...

See full profile

Report class