Ah, the "Franken-Table." You've probably created one: a worksheet with umpteen VLOOKUP()'s referencing various other worksheets and perhaps (gasp!) even other workbooks. It's ugly and inefficient: …
Continue Reading about Learning guide: Introduction to Power Pivot in Excel, one-day workshop →