Building a Basic Dashboard with Countifs and Sumifs in Microsoft Excel

Building a Basic Dashboard with Countifs and Sumifs in Microsoft Excel

Assessment

Interactive Video

Computers, Business

9th - 12th Grade

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial guides viewers through building a basic Excel dashboard using COUNTIFS and SUMIFS functions. It covers setting up data validation for department selection, calculating total salary and employees, and updating the dashboard dynamically. The session emphasizes the importance of practicing advanced Excel functions to master their usage.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF