Excel Hash 2021: The Facilitator | LET function | Power Query Custom Data Types

0:00 Introduction
1:06 My Solution
5:13 Rabbit needs water
7:26 Correction with the EVEN function

ExcelHash is back for 2021! This year we added more participants. Check out the full playlist and think about how you would create a solution.

The premise:
Take 4 random Excel features and bring them together into an integrated solution. It’s pretty difficult and forces a person to justify their choices; thinking about the essence of a feature.

ExcelHash 2021 Ingredients
– A Cutout Person
– EVEN function
At least 2 from the following:
– LET function
– Dynamic Arrays
– Custom Data Type
– LAMBDA function

In this video, I combine the ingredients into a workbook that helps manage and price dirty jobs in a post-apocalypse world of weirdos and chaos.

#ExcelHash
#ExcelChallenge

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2