Excel Dashboard with 4 Strange Features (Excel Hash Episode)
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
-
1:54:42
Kimberly Guilfoyle
15 hours agoSave America: President Trump in Erie, PA- Replay September 29
115K51 -
59:12
Flyover Conservatives
1 day agoUN Power Grab… Are They Using Google to Control Dissent and Push Propaganda? - Alex Newman; Economic Update - Dr. Kirk Elliott | FOC Show
77.4K9 -
1:13:55
Abigail Joy
9 hours agoYou're Not Bullish Enough! - Human 1.0 w/ Abigail Joy - September 30 2024 - LIVE STREAM
60.9K4 -
14:35
China Uncensored
10 hours agoI Wasn’t Expecting THIS Would Turn China Against Xi Jinping
67.6K20 -
55:21
LFA TV
1 day agoNetanyahu Understands War | Trumpet Daily 9.30.24 9PM EST
59K21 -
1:13:17
We Like Shooting
22 hours agoDouble Tap 377 (Gun Podcast)
45.7K -
1:00:44
The StoneZONE with Roger Stone
10 hours agoWill Hurricane Helene Affect The Election In 35 DAYS? The StoneZONE w/ Roger Stone
48.1K33 -
3:12:23
Tundra Gaming Live
16 hours agoThe Worlds Worst Horror Streamer Has Heart Attack Playing Phasmophobia
37.1K -
56:22
Patriots With Grit
14 hours agoReclaiming The Republic One County At A Time | Natalie Scholl
29.6K1 -
1:59:52
VOPUSARADIO
18 hours agoThe Dan Smeriglio Show With Special Guest: Mandy Gunasekara, President Trump's EPA Chief of Staff
35.7K