Keep Your Data Model Clean: Regularly review and clean up your data model by removing unnecessary columns and tables. This will help maintain performance and make your model easier to manage.

To see what Excel did, click Manage Data Model in the Data Tools group. If this option is greyed out, you don’t have a supporting version.

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.