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:
[ Ссылка ]
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
![](https://s2.save4k.ru/pic/AEeqRlfuxVc/maxresdefault.jpg)