SW BOM vs Excel based BOM

Hey guys,

I'm just wondering what the specific pros and cons of using the two different types of boms is?

As far as I know, Excel boms take a little more setting up but beyond that Im in the dark over here knowing which is the one for me to use.

Pennies for your thoughts.

SolidworksBill Of Materials