Making a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP Tutorial скачать в хорошем качестве

Making a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP Tutorial

Figuring out how to make encounters in Dungeons and Dragons the right amount of difficulty is a challenging task, involving a lot of trial and error and repetitive math. Here I walk you through creating an Excel spreadsheet to automate this process, starting with a blank file and ending with a fully-functional and well-polished tool. This spreadsheet relies heavily on XLOOKUP, so this tutorial is a great way to learn more about how XLOOKUP works, including some of its advanced features. Additional Links: Rockstar Excel website: https://rockstarexcel.com/ Newsletter for free tips on using Excel to make your life easier: https://rockstarexcel.com/newsletter/ Book a free consultation: https://rockstarexcel.com/book-a-free... Download the spreadsheet from this video: https://rockstarexcel.com/wp-content/... Video on cleaning data:    • How to clean messy data in Excel   Videos on using absolute, relative, and mixed references to build complex spreadsheets extremely quickly: Part 1:    • How to Use Relative and Absolute Reference...   Part 2:    • Mixed relative and absolute references mak...   Video on Center Across Selection:    • Don't merge cells in Excel! Center across ...   Instructions on building combat encounters from D&D Beyond: https://www.dndbeyond.com/sources/bas...