Excel on Bootcamp

Hi there,

As you may know microsoft excel has certain tools thar you can’t run on a mac such as power pivot, power query or power maps. That’s why I’m planning to install Bootcamp. What I still don’t know is if I would need to buy a license of microsoft to be run on bootcamp and if this would run with all the capabilities as if it was on a windows operating system. Does anyone know how I can go about this? 

Looking forward to hearing your great input.

Fred