Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

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.

If you'd like to learn about the new Excel functions like FILTER check out the complete course here: https://www.xelplus.com/course/excel-dynamic-array-365-formulas/

⯆ DOWNLOAD the workbook (scroll to the bottom of the blog post): https://www.xelplus.com/excel-hash-2019/

All Excel Hash 2019 Videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxfOLvOtx76xw8bbKgDvUwp

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:
How to create Bar-in-Bar Chart: https://youtu.be/6iZT74sKi50
Linked Pictures step by step: https://youtu.be/wlW2UKml9CY
Link to XLOOKUP Video: https://youtu.be/4c0CLUER6nw
Excel Hash 2018 video: https://youtu.be/N0MesGk0VpI
To learn more about Excel Dynamic Arrays - check out the full course: https://courses.xelplus.com/p/excel-dynamic-array-formulas

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

My Online Excel Courses ► https://www.xelplus.com/courses/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

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