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
10 Lessons (54m)
    • 1. Please Follow me

      0:17
    • 2. Index Using it for Lookups

      6:19
    • 3. Index Creating Dynamic Ranges with Index

      9:43
    • 4. Choose Function

      5:11
    • 5. Choose Function Application Dividing Data into quarters

      6:00
    • 6. SUMIF,SUMIFS

      15:19
    • 7. SUMIF,SUMIFS Exercise

      0:28
    • 8. COUNTIF,COUNTIFS

      10:16
    • 9. Countif and Countifs Exercise

      0:35
    • 10. Thanks for Watching

      0:18

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.