Bryan Brownlow speaks on joining datasets. Bryan gives an overview of Lookup tables, Fact tables, VLOOKUP, and Match Index in Excel as well as how to use these tools to your advantage. He also compares Lookup tables vs Fact tables, as well as compares the joining tools VLOOKUP vs Match Index and discusses how best to apply those tools to your datasets.
Please see the below attachments to download the Excel Workbook and PowerPoint Slides Bryan uses during the session. Feel free to build the tables and scenarios along with him!
Tips & Tricks11-16-2023_PP Slides
Tips & Tricks11-16-2023_Worksheet
