Learn how to create Excel dashboards Part 2 - Functions Part 2 | Abdelrahman Abdou | Skillshare

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.

13

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