Google Sheets 2023 Tutorial - Learn Advanced Functions by Building a Zelda Dashboard
🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/
Learn Advanced Google Sheets Functions by building a Zelda Breath of the Wild recipe dashboard using multiple data validation drop down selections to dynamically toggle results.
We'll build a recipe dashboard using all the unique ingredients in Zelda Breath of the Wild to toggle on recipes containing any of the selected ingredients.
Use Dropdown Data Validation, Named Ranges, QUERY(), IFS(), ISTEXT(), ISBLANK(), IMPORTHTML(), CLEAN(), SPLIT(), MID(), LEN(), TRIM(), UNIQUE() and more.
⚔️Zelda Dashboard (You can make your own copy by selecting File - Make a copy); https://docs.google.com/spreadsheets/...
🕹️IGN Recipe List - https://www.ign.com/wikis/the-legend-...
🧙♂️Hylia Serif Font - https://zeldauniverse.net/media/fonts/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
😀Please subscribe to my channel for more coding and spreadsheet content: https://www.youtube.com/@eamonncottre...
►You can find more of my work including articles and podcasts on my website at https://www.eamonncottrell.com/
============================================================
⌚Chapter Time Markers:
00:00:00 - Intro and Demo
00:02:12 - Begin Project
00:02:34 - Zelda Font
00:02:43 - Import Picture
00:02:55 - Import HTML Table Data
00:04:17 - Clean up Data
00:04:51 - Name Ingredient Ranges
00:05:37 - Zelda Heading Font
00:06:04 - Make Full Ingredient List
00:06:16 - Make Dashboard
00:06:43 - Create Dropdown Lists
00:08:05 - Create the Query
00:08:52 - Formula Logic
00:10:50 - Query Message Building From Formula
00:12:01 - Reference Formula for Query
00:13:00 - Name Query Range
00:13:16 - Move Formulas to New Sheet
00:13:45 - If blank condition
============================================================
#googlesheets #zeldabreathofthewild #spreadsheet #datavalidation #query
