How's it going readers? If you've been paying attention and/or have the basic ability to count, you'll notice that this is the third post in a series about using Excel's secret Weapon of Math Destruction: PowerPivot. I highly suggest that if you haven't read the previous two posts, that you go ahead and do that. If you had, you would already:
- Have enabled Powerpivot through the COM add-ins.
- Know what Powerpivot is.
- Understand why powerpivot can make your life as an analyst a great deal easier.
- Be ready to power-up some ginormous flat files.
I'm going to assume that