You can always download open office for free and have the same things MS office can do..
As far I know, there is no equivalent to Powerpivot on OpenOffice. Powerpivot is based on SQL server and gives powerful datamining and business intelligence features to Excel, far above the "simple" pivot tables.