Vlookup vs Relationships The Back Door For Power Pivot

In this tutorial I build a Pivot Table report using almost 250 K VLOOKUP functions then I rebuild it using relationships to replace the 250K VLOOKUPS and dramatically reduce the file size. Along the way, I will invoke some DAX functions without even enabling The Power Pivot Tab on the ribbon… You can Download the Exercise file and follow along by clicking on the link: https://www.amazon.ca/clouddrive/shar... To read my Step by Step Blog articles or Register to one of my Free Webinars, visit my blogsite: www.OfficeInstructor.com Follow me on Facebook: www.Facebook.com/OfficeInstructor To book a Corporate Training or take a Microsoft Office Specialist Exam, visit: www.OfficeInstructor.ca Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come. So let’s build our project from ground up in Excel