Excel Dashboard with 4 Strange Features (Excel Hash Episode)

In this challenge we'll be building an interactive dashboard to monitor attendance for two different events. We'll utilize XOR for attendance analysis, FILTER and XLOOKUP for dynamic lists, and INDIRECT for dynamic images. The dashboard will include interactive dropdowns, dynamic icons, and a real-time attendance chart.

The ingredients for this year's Excel Hash are:
1. Excel XOR Function (1:17)
2. At least one Excel Dynamic Array Function (2:05)
3. At least one Icon (3:11)
4. Linked Picture in Excel (3:29)

A lot is going on in this video that I didn't get to cover in detail. Please check out these videos for a step by step approach:

Video summary:
This is my Excel Hash entry for 2019. I decided to create an interactive Excel dashboard based on the 4 ingredients we were given:
- The XOR Excel function was used to derive if either cell resulted in a TRUE. I also explain a little about Excel's logical test formulas and what Excel sees as a TRUE in a cell.
- Excel FILTER function together with XLOOKUP were used to return multiple match results from Excel with a simple formula (2:05)
- The icons and pictures were used to add dynamic visualization to the Excel dashboard report
- Name manger and the Indirect formula were used to create a dynamic linked picture

As a bonus I added in a bar-in-bar column chart to compare the count for each selection to the total count.

Other Excel MVPs in the Excel Hash challenge are:
Bill Jellen - MrExcel
Mynda Treacy - MyOnlineTrainingHub
Jon Acampor - Excel Campus
Oz du Soleil - Excel on Fire
Unfortunately Mike Girvin - Excel Is Fun couldn't attend this year

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel
#ExcelHash

[OzduSoleilDATA]

Convert-to-Shape, Named Range, Doulbe-Unary ... Brilliant solution to all these weird ingredients.
Soooo nice! Thanks for playing Excel Hash!

[yeba]

although all other videos are made with the same concept, but yours is the most elegant, simple and efficient. ... have voted for you.

[oro]

Thanks so much Leila. Beautiful and very intelligent teacher.

[vipinarora]

Awesome video. Really helpful. Thank you for preparing such kind of videos

[mauriceatkinsonii]

Leila, I just watched these videos. I thought they were awesome and look forward to using all of the tools each of you presented once I learn them! I love the collaboration between you all as Excel MVPs. I am going to become an excel MVP one day. I have taken so many classes by Excel MVPs and they have helped me much. Thank you ALL! Leila, one day I will have time to absorb your courses. You and this group of MVPs really rock!

[SyedMuzammilMahasanShahi]

Beautiful Dashboard ... Thanks for the share.

[khadejaal-awadhi]

You are amazing, I love your way in explaining excel

[courtn]

Wow, great video Leila. The kitchen suits you :). Seriously very professional, well explained and appreciated!

[hattemghanoom]

Thank you Leila
Very useful techniques

[excelisfun]

Great video Leila!!!! Sorry I could not do it this time : ( I can't wait till next year!

[ExcelExciting]

Wonderful..!! Great idea... 💡
Thanks for sharing !

[sarojsuwal]

Liked the way you illustrate. And Voted !!

[yulinliu]

Thanks Leila! Excel Hash 2019. Time flies.

[wayneedmondson]

Hi Leila.. I like it.. very clean and neat.. useful too. Thanks for sharing your tips and tricks (convert icon to shape, FILTER with XLOOKUP, INDIRECT in a named range to make the image link dynamic).. all great. I give it a thumbs up!

[GeertDelmulle]

This is an action- and feature-packed quick snack with an exotic touch. Love it!
Can’t wait for the dynamic array functions (new calc engine) to come to us O365 Outsiders!
That’s my New Years wish list no. 1 item, right there.

[jonk]

Amazing...its so clear...you make it seem easy and for you. I have been struggling with something though..its a little bit off this topic. Is it really possible to print a document containing unique code/numbers for future reference in Excel without having to use VBA

[Computergaga]

Crikey! A whirlwind of Excel goodness.

[chaule]

Great tutorial Leila ! if the filter and xlookup is not available in older version, is there any useful formula can be used to replace in this case to index the name of attendance ? Or we just do it by an "old traditional" way ? Thanks !

[pankajkaushik]

Hi liela searching for a method of dynamically changing the measure in pivot table, need your help in that. Pls make a video on this

[saids.]

So many ovens in this PRO-kitchen 😋
Each Excel-project should be rewarded with a delicious meal ✨