Excel Hash 2021 Challenge - Secret Formula for Sales Commission

Описание: In this Excel Hash Challenge 2021, we have some great ingredients to mashup and provide solutions. This is the third edition of Excel Hash Challenge and there are some great participants around the globe. Please feel to check other participant's videos & don't forget to give a vote, like & subscribe.
Vote here:
http://bit.ly/ExcelVotingTool

00:00 Intro
00:39 ExcelHash 2021 Ingredients
01:12 Understanding the dataset
01:54 Power Query Custom Data Type
05:54 Cutout Person
06:50 Dynamic Arrays (Unique Function)
08:36 Even Function
10:00 Building Solution as Dashboard
14:24 End Screen


Check out other entries:
   • Excel Hash 2021  

--------------------------------------------------------------
ExcelHash 2021 Ingredients
A Cutout Person
EVEN function
At least 2 from the following:
LET function
Dynamic Arrays
Custom Data Type
LAMBDA function
--------------------------------------------------------------
🛒 Affiliate links :
Support me with your Amazon purchases: https://amzn.to/3tR4AUN
Buy Office365: https://bit.ly/3nKcbnk

📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-m...
--------------------------------------------------------------
👍🏻 Like Facebook Page :
  / excelexciting  

👥Join The Facebook Group -
  / excelexciting  
***********************************************************
DISCLAIMER: If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Custom functions in Power Query (and more) with Gašper Kamenšek
   • Custom functions in Power Query (and more)...  

How to Leave or Exit an Organization in Microsoft Teams
   • How to Leave or Exit an Organization in Mi...  

Insert Data from Picture In Excel for Mac
   • Insert Data from Picture In Excel for Mac  

Change Multiple Value using Array Method [Excel for Mac & Windows]
   • Change Multiple Value using Array Method [...  

***********************************************************
#Excel #ExcelHash #Excel2021 #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks