Learn how to create Excel dashboards Part 2 - Functions Part 2

Abdelrahman Abdou, Data Analyst & Excel Lover!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Videos (54m)
    • Index Using it for Lookups

      6:19
    • Index Creating Dynamic Ranges with Index

      9:43
    • Choose Function

      5:11
    • Choose Function Application Dividing Data into quarters

      6:00
    • SUMIF,SUMIFS

      15:19
    • SUMIF,SUMIFS Exercise

      0:28
    • COUNTIF,COUNTIFS

      10:16
    • Countif and Countifs Exercise

      0:35

About This Class

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

This class shows how to use INDEX Function to create dynamic ranges, and how to use SUMIF, SUMIFS, COUNTIF, and COUNTIFS functions.

It also shows the CHOOSE function.

2

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.

See full profile