Bryan Brownlow speaks on Part 2 of joining datasets. Bryan will review 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 & Tricks Joining Datasets Part 2 Spreadsheet
Tips & Tricks Joining Datasets Part 2 PowerPoint
