To activate Power Pivot, enable it through Excel’s “COM Add-ins” settings, which adds a dedicated tab to the ribbon for advanced data modeling tools.