Excel Dashboard with 4 Strange Features (Excel Hash Episode)

1 year ago
98

11 Dec 2019 #MsExcel

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

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

VOTE for your Favorite solution: http://bit.ly/VoteHash2019 (UPDATE: Voting has ended)

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/

✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

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!

#MsExcel
#ExcelHash

Loading comments...